Logo QF-Test

Finding valuable answers
in the Mailing List Archive.


Free Trial  Download  Buy

Thomas Max, QF-Test training and support

Use the full-text search on our web site to find helpful tips on the mailing list.

Thomas Max, 
Sr. Software Engineer & Trainer, QFS

2017 up to now  | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007

(older archive entries before 2007 are not shown here, but included in the onsite-search)

Mailing List - Entries of 2012

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

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

  • Subject: [QF-Test] Error when try to connect to a sql server database using Jython (executeSelectStatement procedure).
  • From: Gustau Mansanet Perez <GUSTAU.MANSANET.PEREZ@?.COM>
  • Date: Wed, 28 Mar 2012 18:58:47 +0200


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:


driver                                      com.microsoft.jdbc.sqlserver.SQLServerDriver

connectionString                    jdbc:microsoft:sqlserver://;DatabaseName=MyDatabase

dbUser                                   User

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.

Videos Downloads Documentation Buy Free Trial