topic Re: SQLServerDriver cannot be found in Talend Studio

SQLServerDriver cannot be found

patrickkahle — Fri, 10 Jan 2025 15:01:17 GMT

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

Re: SQLServerDriver cannot be found

dmtgrp — Mon, 20 Jan 2025 16:08:05 GMT

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

Re: SQLServerDriver cannot be found

Dave_Simo — Mon, 20 Jan 2025 18:35:10 GMT

Hello,

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

Best Regards

Re: SQLServerDriver cannot be found

dmtgrp — Mon, 20 Jan 2025 19:48:32 GMT

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.

Re: SQLServerDriver cannot be found

Dave_Simo — Mon, 20 Jan 2025 20:41:00 GMT

Hello @dmtgrp ,

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

Best Regards

Re: SQLServerDriver cannot be found

dmtgrp — Tue, 21 Jan 2025 13:39:31 GMT

Hello,

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

cordially,

Re: SQLServerDriver cannot be found

Dave_Simo — Tue, 21 Jan 2025 13:54:02 GMT

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

Re: SQLServerDriver cannot be found

dmtgrp — Tue, 21 Jan 2025 14:36:27 GMT

Hello,

yes, I am using Java 17.

Best regards,

Re: SQLServerDriver cannot be found

AChardon — Tue, 21 Jan 2025 16:23:14 GMT

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

Re: SQLServerDriver cannot be found

Nic_D4t4 — Fri, 24 Jan 2025 08:44:05 GMT

Hey @patrickkahle,

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

Completely close the Talend Studio application.
Navigate to the plugins subfolder in the installation directory of Talend Studio.
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).
Open the .jar file as an archive (e.g., using 7-Zip) and locate the file resources/osgi-exclude.properties.
Edit the file located at studio\esb\osgi-exclude.properties.
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.
Save the changes and close the file.
Restart Talend Studio. Now, during the build or publishing of a job, the required driver should be included, and the issue should be resolved.

Re: SQLServerDriver cannot be found

patrickkahle — Tue, 28 Jan 2025 09:23:14 GMT

Hello,

I have found a simpler solution for myself. I have placed the file mssql-jdbc-12.8.1.jre11.jar in the lib folder of my Talend Runtime. Since then it works without problems.

Re: SQLServerDriver cannot be found

dmtgrp — Tue, 28 Jan 2025 09:56:56 GMT

Hello @Nic_D4t4,

Thank you for taking the time to respond to me.

I followed your procedure, and indeed, I no longer encounter the previous error when deploying my web service on the TMC. However, this time, I encountered the following error, as shown below:

Re: SQLServerDriver cannot be found

dmtgrp — Wed, 29 Jan 2025 16:21:50 GMT

Bonjour @Nic_D4t4,

En suivant votre procédure, et les actions que j'ai trouvé dans le tutoriel suivant :

https://cogito-ergo-dev.fr/blog/775/talend-et-authentification-windows-pour-acceder-a-sql-server/

j'ai pu résoudre mon problème.

Merci à vous tous pour votre contribution à ce sujet.