- A Cloud Guru
Adding a Datasource to JBoss EAP
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.
Table of Contents
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 mariadb
Secure 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.
Access the MySQL CLI as the
rootuser, using the password you just provided:
mysql -u root -p
Create a new database,
users; create the user
jboss-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:
Add a Datasource
Access the JBoss EAP CLI:
cd /opt/jboss-eap sudo ./bin/jboss-cli.sh
Connect to the server:
Register the MySQL driver:
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
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.