2 Replies Latest reply on Mar 14, 2017 11:27 AM by Felipe Nunes

    MS SQL jdbc driver 6 and Wildfly 8.2

    Nitin Shukla Newbie

      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