Cannot connect to Microsoft SQL Server - NoClassDefFoundError: javax/xml/bind/DatatypeConverter

[HSHalvorsen]

Hi,

My connection details should be correct, as my teammates was able to connect to the database with the same Db connection. In my case, I get this message when I try to press "Test connection":

I have installed both mssql driver and java environment 8 from zulu.

Do anyone know whats wrong?

[prg · Accepted solution]

Hello @Håkon Halvorsen​ ,

> You can replace the database version with the latest SQL jar by following the step;

- Please close all the open sessions of Talend.

- Delete the jar present in the below location? (take a back up of it and store it outside this location)

Example if you are using MS SQL Server:

C:\Talend\7.3.1\studio\configuration\.m2\repository\org\talend\libraries\mssql-jdbc\6.0.0 (file:///C:/Talend/7.3.1/studio/configuration/.m2/repository/org/talend/libraries/mssql-jdbc/6.0.0) (file:///C:/Talend/7.3.1/studio/configuration/.m2/repository/org/talend/libraries/mssql-jdbc/6.0.0)

- Save the downloaded compatible jar on your system.

- Reopen the studio and start a job with any SQL components like (tmSSqlInput with JDBC provider as Microsoft). It will pop you to download and install the jar.

- Select the jar from your local system location and check.

> Also try to change the DB Version of the MSSQL Database Connection from 'Microsoft' to 'Open source JTDS'.

Regards,

Vaishnavi

[HSHalvorsen]

Thanks! This helped.

Sincerely,

Håkon