Run time Problem for GeneralJDBC-SQLSERVER

[Anonymous]

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:

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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