DB Connection Problem - Open Talend 8.0

mwindsch — Fri, 15 Nov 2024 22:15:39 GMT

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?

Re: DB Connection Problem - Open Talend 8.0

jlolling — Tue, 20 Dec 2022 19:34:09 GMT

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

Re: DB Connection Problem - Open Talend 8.0

Anonymous — Wed, 21 Dec 2022 05:53:32 GMT

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

Re: DB Connection Problem - Open Talend 8.0

mwindsch — Thu, 22 Dec 2022 12:43:13 GMT

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?

Re: DB Connection Problem - Open Talend 8.0

Anonymous — Fri, 23 Dec 2022 08:53:46 GMT

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-using-modules-view

Hope it helps.

Best regards

Sabrina

topic Re: DB Connection Problem - Open Talend 8.0 in Installing and Upgrading

DB Connection Problem - Open Talend 8.0

Re: DB Connection Problem - Open Talend 8.0

Re: DB Connection Problem - Open Talend 8.0

Re: DB Connection Problem - Open Talend 8.0

Re: DB Connection Problem - Open Talend 8.0