ClassNotFound - OpenStudio Talend ESB - 7.2.1 - Runtime only

[root]

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?

[Anonymous]

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.

[nmodi]

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.

[nmodi]

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.