JBPM to SqlServer

[Steve B]

I've used oracle for some time, this is my first go with SQLServer.

Don't seem to be able to get past:

2025-11-26 17:32:29,763 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41) WFLYCTL0013: Operation ("add") failed - address: ([

    ("subsystem" => "datasources"),

    ("jdbc-driver" => "sqlserver")

]) - failure description: "WFLYJCA0041: Failed to load module for driver [com.microsoft.sqlserver]"

Running

- JBPM 7.74.1 (wildfly 23)

- Java 11

- SQLServer 2022

I have the appropriate jar in  $WILDFLY_HOME/modules/system/layers/base/com/microsoft/sqlserver/main/

And the module.xml looks good:

<?xml version="1.0" encoding="UTF-8"?>

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

    <resources>

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

    </resources>

    <dependencies>

        <module name="javax.api"/>

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

    </dependencies>

</module>

But can't get the driver in place...

         <subsystem xmlns="urn:jboss:domain:datasources:6.0">

            <datasources>

                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">

                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>

                    <driver>h2</driver>

                    <security>

                        <user-name>sa</user-name>

                        <password>sa</password>

                    </security>

                </datasource>

                <xa-datasource jndi-name="java:jboss/datasources/jBPMDS" pool-name="jBPMXADS" enabled="true">

                    <xa-datasource-property name="URL"> jdbc:h2:file:${jboss.server.data.dir}/jbpm-db;MVCC=TRUE

                    </xa-datasource-property>

                    <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                    <driver>h2</driver>

                    <security>

                        <user-name>sa</user-name>

                        <password>sa</password>

                    </security>

                </xa-datasource>

                <datasource jndi-name="java:/jbpmDS" pool-name="jbpmDS" enabled="true" use-java-context="true">

                    <connection-url>jdbc:sqlserver://[SERVER]:1433;databaseName=[name]</connection-url>

                    <driver>sqlserver</driver>

                    <security>

                        <user-name>XXX</user-name>

                        <password>XXX</password>

                    </security>

                </datasource>

                <drivers>

                    <driver name="h2" module="com.h2database.h2">

                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                    </driver>

                    <driver name="sqlserver" module="com.microsoft.sqlserver">

                        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                    </driver>

                </drivers>

            </datasources>

        </subsystem>

I've been arguing with Copilot for days... Any humans that can suggest anything?

Cheers,

Steve