2019 up to now | 2018 2017  |  2016  | 2015 | 2014 | 2013 | 2012

Mailing List - Entries of 2012

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [QF-Test] Error when try to connect to a sql server database using Jython (executeSelectStatement procedure).

  • Subject: Re: [QF-Test] Error when try to connect to a sql server database using Jython (executeSelectStatement procedure).
  • From: "Robert Lahmer, QFS support" <support@?.de>
  • Date: Fri, 30 Mar 2012 10:53:15 +0200

Hello Gustau,

looks indeed that the manual is wrong or at least incomplete - thank you for bringing this up.

Microsoft changed the JDBC driver name and the connection URL between SQL Server 2000 and SQL Server 2005. For the latter it should read




Best regards,

--On Mittwoch, März 28, 2012 18:58:47 +0200 Gustau Mansanet Perez <GUSTAU.MANSANET.PEREZ@?.COM> wrote:


My name is Gustau and I'm entering the world of QF-Test and I have
encountered the following problem: I can not connect to a sql server
database using Jython(executeSelectStatement procedure).

I have downloaded from the Microsoft website the driver "sqljdbc4.jar"
and have placed in the plugin folder, but the following error occurs:

The script failed with the Following message:
Traceback (most recent call last):
   File "", line 1, in
   File "C: \ Program Files (x86) \ qfs \ qftest \ qftest-3.4.5 \ jython
\ Lib \ qftest.py", line90, in runscript      qfcommon.runscript (ctxt,
code, exContext, dir)
   File "C: \ Program Files (x86) \ qfs \ qftest \ qftest-3.4.5 \ jython
\ Lib \ qfcommon.py", line 826, in runscript      exec compile (code,
file, "exec") \
   File "C: \ Users \ gmansane \. Qftest \
_script5127568149610756196.py", line 11, in      db = zxJDBC.connect
(rc.lookup ("connectionString"), user, password, dbclass)
zxJDBC.DatabaseError: driver
[com.microsoft.jdbc.sqlserver.SQLServerDriver] not found

The params I am using are:

com.microsoft.jdbc.sqlserver.SQLServerDriver connectionString
jdbc:microsoft:sqlserver://;DatabaseName=MyDatabase dbUser
dbPass                                   Pwd
statement                               Select * from tb_biblio
resultGroupName                  resultGroup

Which is what I am doing wrong?

Thanks in advance.

Este correo y la informaci?n contenida o adjunta al mismo es privada y
confidencial y va dirigida exclusivamente a su destinatario. everis
informa a quien pueda haber recibido este correo por error que contiene
informaci?n confidencial cuyo uso, copia, reproducci?n o distribuci?n
est? expresamente prohibida. Si no es Vd. el destinatario del mismo y
recibe este correo por error, le rogamos lo ponga en conocimiento del
emisor y proceda a su eliminaci?n sin copiarlo, imprimirlo o utilizarlo
de ning?n modo.

This message and the information contained in or attached to it are
private and confidential and intended exclusively for the addressee.
everis informs to whom it may receive it in error that it contains
privileged information and its use, copy, reproduction or distribution is
prohibited. If you are not an intended recipient of this E-mail, please
notify the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute any portion of this E-mail.

QFS Support - Robert Lahmer
Quality First Software GmbH                http://www.qfs.de
Tulpenstr. 41                         Tel: +49 8171 38648-20
DE-82538 Geretsried                   Fax: +49 8171 38648-16
GF: Gregor Schmid, Karlheinz Kellerer     HRB München 140833