This is a list of handy datasource commands that can be issued using the datasource alias:
You can also operate on a datasource using operations on the data sources subsystem:
List the installed drivers:
/subsystem=datasources:installed-drivers-listAdd a datasource:
data-source add --jndi-name=java:/MySqlDS --name=MySQLPool --connection-url=jdbc:mysql://localhost:3306/MyDB --driver-name=mysql-connector-java-5.1.30-bin.jar --user-name=myuser --password=password --max-pool-size=30Add an XA datasource (using an operation):
xa-data-source add --name=MySQLPoolXA --jndi-name=java:/MySqlDSXA --driver-name=mysql-connector-java-5.1.30-bin.jar -xa-datasource-properties=[{ServerName=localhost}{PortNumber=3306}]Remove a datasource (using an operation):
/subsystem=datasources/data-source=testDS:remove