The JBoss Enterprise Application Platform provides extensive support for deploying and managing Java-based applications. These applications often need supporting backends, such as databases. In this hands-on lab, we use a provided MySQL module to create a MySQL datasource for our applications to use.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Install and Configure MariaDB
Install MariaDB:
sudo yum install mariadb-server
Ensure the MariaDB service has been started and set MariaDB to start at boot:
sudo systemctl start mariadb sudo systemctl enable mariadbSecure the installation; there is no default password for
root. Set a password, remove anonymous users, disallow remote root login, and remove the test database. Reload the privilege tables, following the prompt.sudo mysql_secure_installationAccess the MySQL CLI as the
rootuser, using the password you just provided:mysql -u root -pCreate a new database,
users; create the userjboss-eapand grant that user access to the database:create database users; grant all on users.* to 'jboss-eap' identified by 'pinehead';Log out of MySQL:
exit
- Add a Datasource
Access the JBoss EAP CLI:
cd /opt/jboss-eap sudo ./bin/jboss-cli.sh
Connect to the server:
connectRegister the MySQL driver:
/subsystem=datasources/jdbc-driver=mysql:add(driver-name=mysql,driver-module-name=com.mysql)Create the datasource:
data-source add --name=MySQLDS --jndi-name=java:/MySqlDS --driver-name=mysql --connection-url=jdbc:mysql://localhost:3306/users --user-name=jboss-eap --password=pinehead
- Test the Connection
We can test the connection from the CLI with
1/subsystem=datasources/data-source=MySQLDS:test-connection-in-pool.
