"noclassdeffounderror: Javax/xml/bind/datatypeconverter" With Sql Server Jdbc

I recently switched to intellij but I'm finding it hard to connect to my localDB. The same code worked on eclipse fine. Also I have already added the sqljdbc42.jar as a module depe

Solution 1:

For Java 9+ compatibility, you need to use version 6.4.0 or higher for the Java version you use as identified by the jreXX version suffix. Use the highest version lower or equal to you Java version).

---

Previous answer

As noted by Microsoft on GitHub:

Currently none of our driver released Jars are compatible with JDK9.

You can either switch to using the Java 8 JDK, or you can incorporate Microsoft's development code from their 'JDBC4.3' branch into your project and use that with the Java 9 JDK.

Solution 2:

You can get this to work if you include the extra jvm parameter

--add-modules=java.se.ee

Which in your run configuration in Intellij would go here

This then includes several modules which in java 9 have been marked as deprecated for future removal so these could be removed in java 10 so it is only really a temporary solution until Microsoft release java 9 compatible jdbc drivers.

More on this can be found in the Java9 Migration guide

Solution 3:

If you have a maven build, add the following to your pom.xml

<dependency><groupId>javax.xml.bind</groupId><artifactId>jaxb-api</artifactId></dependency>