Snippets for enabling JDBC drivers, deployed as modules, in JBoss / Wildfly using JBoss CLI

register-jdbc-drivers.cli

# PostgreSQL
if (outcome != success) of /subsystem=datasources/jdbc-driver=postgres:read-resource
    /subsystem=datasources/jdbc-driver=postgres:add(driver-name=postgres,jdbc-compliant=true,driver-module-name=org.postgres.jdbc,driver-class-name=org.postgresql.Driver,driver-datasource-class-name=org.postgresql.ds.PGPoolingDataSource,xa-datasource-class=org.postgresql.xa.PGXADataSource)
end-if

# SQL Server
if (outcome != success) of /subsystem=datasources/jdbc-driver=sqlserver:read-resource
    /subsystem=datasources/jdbc-driver=sqlserver:add(driver-name=sqlserver,jdbc-compliant=true,driver-module-name=org.jtds.jdbc,driver-class-name=net.sourceforge.jtds.jdbc.Driver,driver-datasource-class-name=net.sourceforge.jtds.jdbcx.JtdsDataSource,xa-datasource-class=net.sourceforge.jtds.jdbcx.JtdsDataSource)
end-if

# Oracle
if (outcome != success) of /subsystem=datasources/jdbc-driver=oracle:read-resource
    /subsystem=datasources/jdbc-driver=oracle:add(driver-name=oracle,jdbc-compliant=true,driver-module-name=com.oracle.jdbc,driver-class-name=oracle.jdbc.OracleDriver,driver-datasource-class-name=oracle.jdbc.pool.OracleDataSource,xa-datasource-class=oracle.jdbc.xa.OracleXADataSource)
end-if

# MySQL
if (outcome != success) of /subsystem=datasources/jdbc-driver=mysql:read-resource
    /subsystem=datasources/jdbc-driver=mysql:add(driver-name=mysql,jdbc-compliant=true,driver-module-name=com.mysql.jdbc,driver-class-name=com.mysql.jdbc.Driver,xa-datasource-class=com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource)
end-if