One Star

Run time Problem for GeneralJDBC-SQLSERVER

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:
3 REPLIES
Community Manager

Re: Run time Problem for GeneralJDBC-SQLSERVER

Hi
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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Run time Problem for GeneralJDBC-SQLSERVER

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

Re: Run time Problem for GeneralJDBC-SQLSERVER

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
----------------------------------------------------------
Talend | Data Agility for Modern Business