Mastering JBoss Enterprise Application Platform 7

Defining a new datasource

Let's start this step by creating a datasource, providing basic configuration settings such as:

• Its name
• The JNDI name - used by the application to reference it
• The connection URL to the database we want to connect to
• The credentials to access the database (username and password)
• The driver to use

Connect to the CLI and do as follows:

data-source add --name=MySQLDS --driver-name=mysql --user-name=root --password=root --connection-url="jdbc:mysql://192.168.59.104:3306/mysql?autoReconnect=true&useSSL=false" --jndi-name=java:jboss/MySQLDS

The preceding command should have added the datasource definition inside the standalone.xml file. Here it is for reference:

<datasource jndi-name="java:jboss/MySQLDS" pool-name="MySQLDS"> <connection-url>jdbc:mysql://192.168.59.104:3306/mysql?autoReconnect=true&amp;useSSL=false</connection-url> ...