topic Error when running built job that contains MSSQL components in Talend Studio

Error when running built job that contains MSSQL components

BCHENNOUF1701080652 — Fri, 15 Nov 2024 21:13:44 GMT

Hi,

i built a job that uses 2 Database components: tMSSqlInput and tMysqlOutput , the job works perfectly when i run it from inside TOS,but when i build it and run it from the bash file, i get this error:

any ideas ?

Re: Error when running built job that contains MSSQL components

Anonymous — Tue, 28 Nov 2023 01:51:17 GMT

Hello,

This error mainly appears when you use an incompatible version of Java, which leads to the wrong JAR file being used.

Please verify that your current Java version is compatible with your Talend environment.

Find your current Java version using the Windows > Preferences > Java > Installed JREs path.
Review the Compatible Java Environments section in the Talend Data Integration Installation Guide in the Talend Help Center to see the recommended Java version for your Talend environment.
Update your Java environment to match the recommended version.

Hope it helps.

Best regards

Sabrina

Re: Error when running built job that contains MSSQL components

BCHENNOUF1701080652 — Thu, 30 Nov 2023 09:34:38 GMT

hi @Xiaodi Shi

thanks for the reply,

i found another fix for that, in the DB connection, i changed the DB version from Microsoft to Open source JTDSthis solved the issue

Re: Error when running built job that contains MSSQL components

Anonymous — Fri, 01 Dec 2023 02:22:15 GMT

Hello,

Great it works and thanks for sharing your solution with us on Community.

Best regards

Sabrina