Create the directory structure:
\modules\system\layers\base\com\microsoft\sqljdbc41\main
module.xml
<?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.3" name="com.microsoft.sqljdbc41"> <resources> <resource-root path="sqljdbc41.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module>
Then copy in the jar file sqljdbc41.jar
Create the directory structure:
\modules\system\layers\base\net\sourceforge\jtds\main
module.xml
<?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.3" name="net.sourceforge.jtds"> <resources> <resource-root path="jtds-1.3.1.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module>
Then copy in the jar file jtds-1.3.1.jar
run the cli and enter the following commands
connect
/subsystem=datasources/jdbc-driver=sqljdbc41:add(driver-name=sqljdbc41,driver-module-name=com.microsoft.sqljdbc41)
/subsystem=datasources/jdbc-driver=jtds:add(driver-name=jtds,driver-module-name=net.sourceforge.jtds)
quit