I can't connect to SQL Server

[EVives1698242095]

Hi everyone,

The issue happens from Talend Open Studio for Data Integration

Once I created the connection against my local box sql server 2019, when cliking Test Connection button I am getting a "Connect failure. You must change the Database Settings".

Primary plaftorm; Windows 10 Pro

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter

   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:1170)

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

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

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

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.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.NoClassDefFoundError: javax/xml/bind/DatatypeConverter

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4098)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3160)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123)

   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)

   at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)

   at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)

   at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

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

   ... 9 more

looks like an issue with the JDBC configuration in my laptop. Just checked and got the sqljdbc42.jar file in C:\Program Files\sqljdbc_6.0.8112.200_enu\sqljdbc_6.0\enu\jre8

What am I missing here?

Thanks in advance,

[Anonymous]

Hello,

This error is commonly caused because the driver is not supported with Java 11.

What JDK version are you using? One recommendation is to use Open source JTDS

Here is online documentation for V 8.0 about:

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

Best regards

Sabrina

[EVives1698242095]

Thanks for your reply Sabrina.

I just downloaded jTDS - SQL Server and Sybase JDBC driver package 'jtds-1.3.1-dist' but once donwload still have the same error:

How can I point to the new driver?

[Anonymous]

Hello,

Usually, Modules view grab the MVN URI from the right jar and override the old JAR-s MVN URI.

For more information, please have a look at those documentations:

https://help.talend.com/r/en-US/8.0/studio-user-guide/upgrading-database-jdbc-driver-by-customizing-...

https://community.talend.com/s/article/Resolving-class-and-JAR-related-issues

Best regards

Sabrina

[EVives1698242095]

supposedly I just changed in every source/target connections the method addressing directly "Open Source JTDS" on JDBC provider dropdown but it is all the same, does not work, it is frustrating indeed:

[EVives1698242095 · Accepted solution]

Sabrina it is already solved -everything"-; I was not defining from the scratch in the first window-connection-creation the correct method...

Sorry for the pain