topic Re: ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only in Talend Studio

ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only

root — Sat, 16 Nov 2024 03:24:06 GMT

I am having a weird issue with OpenStudio TESB 7.2.1.

I migrated my service (using tRestRequest) from TESB 6.3.1 to TESB 7.2.1.

I created its "build", it gave NO error.

I deployed it on the Runtime container of 7.2.1... and now I see errors saying unable to find the "OpenSource JDTS" diver for MSSQL.
(java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver cannot be found by sql.sql_0.1.0 )

When I run the service from the Studio (via the Run button), it is able to connect to the SqlServer DB without issues.

What can I check/ troubleshoot here?

Re: ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only

Anonymous — Fri, 31 Jan 2020 20:37:22 GMT

I *think* I have seen this, but cannot be entirely sure. The fix to this for me was to download the JTDS driver fro here (https://mvnrepository.com/artifact/net.sourceforge.jtds/jtds/1.3.1) and drop it into the Container's deploy folder. That *should* fix this if my memory serves me correctly.

Re: ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only

nmodi — Mon, 23 Mar 2020 16:36:24 GMT

I am having same issue with runtime job,

net.sourceforge.jtds.jdbc.Driver cannot be found by <job>

java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver cannot be found by <job>

is that the permanent resolution to put jtds driver in deploy folder & that should fix for all?

I saw in previous version , jtds driver was being bundled as part of every job under lib folder, we dont have to install it separatly.

Re: ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only

nmodi — Mon, 23 Mar 2020 21:39:24 GMT

I got an update from talend support that I should use ms sql jdbc instead open source jtds & it worked for me.

however that require us to change all of our ESB jobs to use ms sql jdbc driver & that is tedious job as part of this migration. looking for other recommendation that doesn't require us to change the job.