topic Re: I can't connect to SQL Server in Talend Studio

I can't connect to SQL Server

EVives1698242095 — Wed, 25 Oct 2023 14:04:07 GMT

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,

Re: I can't connect to SQL Server

Anonymous — Fri, 27 Oct 2023 02:35:41 GMT

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

Re: I can't connect to SQL Server

EVives1698242095 — Fri, 27 Oct 2023 07:15:09 GMT

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?

Re: I can't connect to SQL Server

Anonymous — Fri, 27 Oct 2023 07:33:41 GMT

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-mvn-uri

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

Best regards

Sabrina

Re: I can't connect to SQL Server

EVives1698242095 — Fri, 27 Oct 2023 09:08:18 GMT

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:

Re: I can't connect to SQL Server

EVives1698242095 — Fri, 27 Oct 2023 09:25:00 GMT

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