Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Driver JTDS

More
13 Oct 2016 15:52 - 13 Oct 2016 16:17 #1 by Florian H
Driver JTDS was created by Florian H
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 :)
Attachments:
Last edit: 13 Oct 2016 16:17 by Florian H.
More
13 Oct 2016 16:09 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Driver JTDS
Hi,

Please have a look at this KB entry:
www.stambia.org/kb/16-execution-issues/8...-executing-a-process
More
13 Oct 2016 16:15 - 13 Oct 2016 16:38 #3 by Florian H
Replied by Florian H on topic Driver JTDS
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 ?
Last edit: 13 Oct 2016 16:38 by Florian H.
More
13 Oct 2016 16:49 #4 by Thomas BLETON
Replied by Thomas BLETON on topic Driver JTDS
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.
More
13 Oct 2016 17:09 #5 by Florian H
Replied by Florian H on topic Driver JTDS
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.