Question Driver JTDS

Hello !

I have some trouble with JTDS driver



I do not understant because my target (on sql server) is supposed to use this JTDS driver and the process fails on the load step whereas my source is based on Oracle database with jdbc driver.
If I try to consult data from Stambia, I have no any problem to consult my target and my source table then the connection configuration is fine

Moreover, I have check the drivers' library and I found the driver jtds.

I also checked the driver list where we can see a "Microsoft SQL Server with JTDS" which seems to be well configured :




There is also a driver jTDS whom I add the same drivers but nothing works !

If someone knows how to fix this problem I'd appreciate your help

Hi,

Please have a look at this KB entry:
www.stambia.org/kb/16-execution-issues/8...-executing-a-process

Hi Thomas,
I am sorry my post was uncompleted.

As it said in the last version of my post I have already checked the directory stambiaRuntime/lib/jdbc and it's look OK.
The driver used is the last version from sourceforge.net

Maybe is there something to add on the folder Stambia/plugins ?

Using SQL Server does not require any specific plugin.
Did you restart the Runtime after adding the jtds.jar file to lib/jdbc ?

By the way, why using the jTDS driver instead of the standard Microsoft SQL Server JDBC driver ? I personnaly tend to prefer vendor-edited drivers: they know their products.

I am wondering why the jTDS it used, most of the time I also work with the classic driver.
I am working remotely then I have nobody with me to explain why there is the jTDS driver.

I do not restart the runtime because the jtds.jar was already on the library and also because I have no way to do it !
I will contact my customer to ask for it and to clarify the jTDS driver instead of the vendor edited drivers.

thanks for your help.