[JBoss] Can't register SQL Server driver in JBoss

We have just recently setup JBoss EAP 8.0.0 and need to register a SQL Server driver to connect to a SQL Server database from our deployed application. After running the CLI command to register it, I receive an error stating that I am missing dependencies.

I have created the module.xml file in the <server home>/modules/com/microsoft/sqlserver/main folder and have included the JAR file there as well. The only listed dependencies in the module.xml are the expected javax.transaction.api and javax.api modules. The interesting thing is that we have an Oracle driver we registered using the same dependencies and it is working fine. Even more interesting is that this works fine on our Windows machines but not on the Linux machine we really need it working on. Naturally I assume something is off on the Linux machine but I cannot seem to find anything. I did try changing the dependencies to jakarta but the javax ones are working for Oracle. Either way, we still get the same error: "WFLYJCA0115: Module for driver [com.microsoft.sqlserver] or one of it dependencies is missing: [com.microsoft.sqlserver]"

Below is my module.xml:

<?xml version="1.0" ?>

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

<resources>
<resource-root path="mssql-jdbc-13.2.0.jre11.jar"/>
</resources>

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


Here is the CLI command:

/subsystem=datasources/jdbc-driver=sqlserver:add(driver-name="sqlserver", driver-module-name="com.microsoft.sqlserver", driver-class-name="com.microsoft.sqlserver.jdbc.SQLServerDriver")

Continue reading...