SQLServerDriver cannot be found

[patrickkahle]

hey everyone,

i have created a simple rest api in Talend that load some informations from a mssql database. 

If i run this Job in Studio, it works for me:

But when i'm export the Job to the cloud and deploy the task and test it in the api tester, i get the error message "com.microsoft.sqlserver.jdbc.SQLServerDriver cannot be found by c360.Systems_0.1.0"

Where is my mistake?

Thanks and best regards

Patrick

[dmtgrp]

Hello,

It’s the same for me; it works very well in the studio, but when publishing in the cloud and deploying on the TMC, I get the following error:

java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/microsoft/sqlserver/jdbc/SQLServerDriver

Thank you for addressing this issue.

Walid

[Dave_Simo]

Hello,

In Karaf try installing the pax-jdbc-mssql feature and redeploy your interface.

Best Regards

[dmtgrp]

Hello,

Thanks for your answer.

I had the same error even though I installed the pax-jdbc-mssql_1.4.0.jar and I redeployed my web service.

[Dave_Simo]

Hello @dmtgrp ,

Try installing this other feature tesb-datasource-sqlserver and restart karaf.

Best Regards

[dmtgrp]

Hello,

Thanks for your feedback.
Here is the list of ESB features installed on my Karaf:

cordially,

[Dave_Simo]

Hello,

Humm strange though I see that you are on version 8 of Talend, are you using java 17 ? Because it is this version of the jdk which is recommended for version 8.

https://help.qlik.com/talend/en-US/installation-guide-windows/Cloud/compatible-java-environments

Best Regards

[dmtgrp]

Hello,

yes, I am using Java 17.

Best regards,

[AChardon]

Not sure, but i think you have to create a datasource in your runtime.

[Nic_D4t4]

Hey @patrickkahle,

I had the same error and what worked out for my end were to follow this:

1. Completely close the Talend Studio application.

2. Navigate to the plugins subfolder in the installation directory of Talend Studio.

3. Look for the file named org.talend.repository_X.X.X.AAAMMDD_XXXX.jar (the version number and date may vary depending on your installation).

4. Open the .jar file as an archive (e.g., using 7-Zip) and locate the file resources/osgi-exclude.properties.

5. Edit the file located at studio\esb\osgi-exclude.properties.

6. Comment out the line that corresponds to the required driver by adding a # at the beginning of the line. -For example, if you're dealing with the MSSQL-JDBC driver, comment out the relevant line.

7. Save the changes and close the file.

8. Restart Talend Studio. Now, during the build or publishing of a job, the required driver should be included, and the issue should be resolved.