Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
It looks like you use an unsupported Java 19 version. It would recommend using Java 11 and not later!
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
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?
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:
Hope it helps.
Best regards
Sabrina