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

Hello,

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://12.84.66.134;DatabaseName=MyDatabase

dbUser                                   User

dbPass                                   Pwd

statement                               Select * from tb_biblio

resultGroupName                  resultGroup


Which is what I am doing wrong?

Thanks in advance.

 



AVISO DE CONFIDENCIALIDAD.
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.

CONFIDENTIALITY WARNING.
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.