Red Hat JBoss Enterprise Application Platform Administration I

Instructions

1. Start the standalone instance of JBoss EAP by running the following command, which uses /home/student/AD248/labs/datasources-xa/standalone as the base directory:

   [student@workstation ~]$ cd /opt/jboss-eap-7.4/bin
   [student@workstation bin]$ ./standalone.sh \
   -Djboss.server.base.dir=/home/student/AD248/labs/datasources-xa/standalone

2. Configure the XA JDBC driver.

   1. Open a new terminal window, and run the following commands to connect to JBoss EAP by using the management CLI:

      [student@workstation ~]$ cd /opt/jboss-eap-7.4/bin
      [student@workstation bin]$ ./jboss-cli.sh --connect

   2. Use the management to create the datasource with the following configuration:

      • Datasource name: MariaDBXADS

      • JNDI name: java:jboss/datasources/MariaDBXADS

      • driver name: mariadb

      • username: developer

      • password: redhat123

      • XA datasource property: Url=jdbc:mariadb://localhost:3306/lab_db

        Run the following management CLI command to create the datasource:

      [standalone@localhost:9990] xa-data-source add --name=MariaDBXADS \
      --jndi-name=java:jboss/MariaDBXADS --driver-name=mariadb \
      --user-name=developer --password=redhat123 \
      --xa-datasource-properties={"Url"=>"jdbc:mariadb://localhost:3306/lab_db"}

      Note that this course uses the version 3.2 for the MariaDB JDBC driver which requires the Url datasource XA property.

3. Test the data source.

   1. Navigate to http://localhost:9990 to access the management console page, using admin as username and redhat123 as the password.

   2. Click Configuration to open the configuration page.

   3. Navigate to Subsystems > Datasources & Drivers > Datasources. Click MariaDBXADS and open the drop-down menu to click Test Connection.

      

      JBoss EAP validates the datasource connection to the lab_db database and the management console shows a success message.

      

4. Clean up.

   1. Exit the management CLI:

      [standalone@localhost:9990] exit

   2. Stop the JBoss EAP instance by pressing Ctrl+C in the terminal window that runs it.