topic Re: Run time Problem for GeneralJDBC-SQLSERVER in Talend Studio

Run time Problem for GeneralJDBC-SQLSERVER

Anonymous — Sat, 16 Nov 2024 12:56:35 GMT

Hi,
I have connected the MS-SQL server using General JDBC type. While run the job, got the following exception.
connected
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at config.sqljdbc_0_1.SQLJDBC.tJDBCInput_1Process(SQLJDBC.java:597)
at config.sqljdbc_0_1.SQLJDBC.runJobInTOS(SQLJDBC.java:1055)
at config.sqljdbc_0_1.SQLJDBC.main(SQLJDBC.java:871)
disconnected
Note: I have properly configured the 3 required jar files path. But exporting the job, the lib folder contains msbase.jar only.
Screenshot are below:

Re: Run time Problem for GeneralJDBC-SQLSERVER

Anonymous — Thu, 05 May 2011 06:14:16 GMT

But exporting the job, the lib folder contains msbase.jar only.

Yes, we can see it is missing the driver jar from error message, does the job work fine in the studio?
Best regards
Shong

Re: Run time Problem for GeneralJDBC-SQLSERVER

Anonymous — Thu, 05 May 2011 06:50:29 GMT

No it's not working in studio. Even the error messages were posted from studio.

Re: Run time Problem for GeneralJDBC-SQLSERVER

Anonymous — Thu, 05 May 2011 10:48:54 GMT

Hi
It requires the jtds-1.2.5.jar, you can find this jar in folder <TOS/TIS studio installation directory>\plugins\org.talend.designer.components.localprovider_xxx_xxx\components\tMSSqlInput
Best regards
Shong