MS SQL jdbc driver 6 and Wildfly 8.2

[nitin.shukla]

Hello,

I am looking to upgrade the MS SQL jdbc driver that we are using currently with WildFly 8.2 from 4.2 to the latest Microsoft JDBC driver 6.0. When starting the application I am getting below error in the logs.

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.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322)

  ... 66 more

Caused by: java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter from [Module "com.microsoft.sqlserver.jdbc:main" from local module loader @736e9adb (finder: local module finder @6d21714c (roots: C:\Warloc\Branches\trunk\rmpmjboss\modules,C:\Warloc\Branches\trunk\rmpmjboss\modules\system\layers\base))]

  at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)

  at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)

  at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)

  ... 78 more

My JBoss module configuration for sql server jdbc looks as below:

<module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver.jdbc">

  <resources>

    <resource-root path="sqljdbc42.jar"/>

  </resources>

  <dependencies>

    <module name="javax.api"/>

    <module name="javax.transaction.api"/>

  </dependencies>

</module>

I haven't changed this and this was working well with Microsoft JDBC driver 4.2.

Is there I need to change the module configuration now? Has anyone tried working Wildfly with Microsoft Microsoft JDBC driver 6.0? Any pointers to resolve the issue I am facing is appreciated.

Regards,

Nitin

[nitin.shukla]

I added another below dependency and that resolved the issue.

<module name="javax.xml.bind.api"/>

Thanks.

[felipenunes]

This solution also works in wildfly-10.1.0.Final.

[bigbubu007]

Thank you verry much, the solution also works with Wildfly16