DatatypeConverter Error after upgrade to 7.7.3

Tom Penndorf

We’ve hit the same issue after upgrading to confluence 7.4.5. This renders the addon useless for us.

2020-11-23T10:42:23+00:00

H5 IT

We have the same issue after upgrading to Confluence version 7.8.1 using version 1.5 of this application.

500javax/xml/bind/DatatypeConverterjava.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4128)

The cause of this issue is the change from Java 8 to Java 11 in Confluence. the FIX for this is to change a few things.

In the database connector app config (from manage apps in confluence) you need to change the Microsoft SQL CDN URL and may want to pre-stage the driver locally.

The old value for the Microsoft SQL CDN is:

https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/6.1.0.jre8/mssql-jdbc-6.1.0.jre8.jar

The value to which you should set this to fix this issue is:

https://github.com/microsoft/mssql-jdbc/releases/download/v7.4.1/mssql-jdbc-7.4.1.jre11.jar

‌

You will need to add a folder in the c:\program Files\Atlassian\Confluence directory called “JdbcDrivers” (if you keep it all default).

Then pre-stage the MSSQL JDBC 7.4.1 driver JAR file there.

‌

We did attempt to use the newest version of the JDBC driver (8.4.1) but it still gave an error when we tried, but version 7.4.1 appears to be fully compatible.