topic Having trouble installing Microsoft JDBC driver in Installing and Upgrading

Having trouble installing Microsoft JDBC driver

MarkM1 — Fri, 15 Nov 2024 22:36:12 GMT

I am using TOS DI version 7.3

I am able to connect to SQL Server with jTDS, but I want to use the Microsoft driver. I downloaded the most recent Microsoft jdbc driver, and installed it by clicking the Jar button on the Talend dialog. But when I try Test Connection I get:

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)

at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.lang.Thread.run(Thread.java:829)

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)

at java.base/java.lang.Class.forName0(Native Method)

at java.base/java.lang.Class.forName(Class.java:398)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)

... 9 more

Re: Having trouble installing Microsoft JDBC driver

Ruchi_27 — Wed, 31 Aug 2022 23:00:41 GMT

Hello,

You need to download the Microsoft JDBC Driver for SQL Server on Microsoft Download Center, unpack the downloaded zip file, choose a jar in the unzipped folder based on your JRE version, rename the jar to mssql-jdbc.jar and install it manually.

If the above was correctly performed please try below:

> Uninstall the external module for MSSQL by deleting the following folder:

\studio\configuration\.m2\repository\org\talend\libraries\mssql-jdbc

-------------------------

>Once you delete this, the next time you login to Talend Studio, you can install the module externally.

> Use the tLibraryLoad component to import the jar "mssql-jdbc-X.X.Xjar"

I hope this helps!

Re: Having trouble installing Microsoft JDBC driver

Anonymous — Thu, 01 Sep 2022 10:03:26 GMT

It seems you don't use a right driver version that matches your JRE version, as @Ruchi Singh suggested, try to download the right driver version and install it again.

BTW, I installed the latest driver version mssql-jdbc-11.2.0.jre11.jar in TOS for DI 8.0.1 and it works.

Regards

Shong