DB Connection Problem - Open Talend 8.0

[mwindsch]

Hi,

I installed the newest Version of Talend Open Studio ( 8.0.120211109_1610) on an Windows 11 machine.

And zulu19.30.11-ca-jdk19.0.1-win_x64

Wenn I want to make a DB Connection, it doesn't work.

It is a Microsoft SQL Server connection: jdbc:sqlserver://SRSVERPDB7:1433;DatabaseName=APplusProd7;

Wenn I press the button Test connection, a new Popup comes:

I tried different mssql-jdbc Data:

sqljdbc_6.0 (jre7: sqljdbc41.jar or jre8: sqljdbc42.jar)

sqljdbc_11.2 (mssql-jdbc-11.2.1.jre8.jar, mssql-jdbc-11.2.1.jre17.jar, mssql-jdbc-11.2.1.jre17.jar)

Nothing works.

Here the message:

Verbindung fehlgeschlagen. Sie müssen die Datenbankeinstellungen ändern.

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

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

 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

 Caused by: java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter

   ... 22 more

Here is the path of the jdbc Data in Open Studio:

C:\Program Files (x86)\TOS_DI-8.0.1\studio\configuration\.m2\repository\org\talend\libraries\mssql-jdbc\6.0.0

Here the installed JRE:

I don't know, what I have to do that the DB connection works.

Has anyone an idea?

[jlolling]

It looks like you use an unsupported Java 19 version. It would recommend using Java 11 and not later!

[Anonymous]

Hello,

Please have a look at talend official documentation about:

TalendHelpCenter: Compatible Java Environments

In the documentation we provide a list of java environments that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) java environments will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.

Best regards

Sabrina

[mwindsch]

I installed this Zulu Version: zulu11.60.19-ca-jdk11.0.17-win_x64.msi

 

 

I also installed the Open Studio once again.

Then want to make a new DB connection:

 

which mssql-jdbc Version (Data) should I download an use?Do I have to put the mssql-jdbc Data in a special location of the Open Studio program or doesn't matter?

I downloaded sqljdbc_6.0 (jre7, jr8). Both don't work.

What's my mistake?

[Anonymous]

Hello,

You can also install external modules manually. Download the required jars from talend jar repository or from internet, and then install the jars manually.

Here is online documentation about:

https://help.talend.com/r/en-US/8.0/open-studio-user-guide/installing-external-modules-manually-usin...

Hope it helps.

Best regards

Sabrina