8.6. Create an XA Datasource with the Management Interfaces

Procedure 8.4. Create an XA Datasource, Using Either the Management CLI or the Management Console

• • Management CLI

    1. Section 2.3.1, “Launch the Management CLI”.
    2. Run the following Management CLI command to create an XA datasource, configuring the variables as appropriate:

       Note

       The value for DRIVER_NAME depends on the number of classes listed in the /META-INF/services/java.sql.Driver file located in the JDBC driver JAR. If there is only one class, the value is the name of the JAR. If there are multiple classes, the value is the name of the JAR + driverClassName + "_" + majorVersion +"_" + minorVersion. Failure to do so will result in the following error being logged:

       JBAS014775:    New missing/unsatisfied dependencies

       For example, the DRIVER_NAME value required for the MySQL 5.1.31 driver, is mysql-connector-java-5.1.31-bin.jarcom.mysql.jdbc.Driver_5_1.

       xa-data-source add --name=XA_DATASOURCE_NAME --jndi-name=JNDI_NAME --driver-name=DRIVER_NAME --xa-datasource-class=XA_DATASOURCE_CLASS

    3. Configure the XA datasource properties

       1. Set the server name

          Run the following command to configure the server name for the host:

          /subsystem=datasources/xa-data-source=XA_DATASOURCE_NAME/xa-datasource-properties=ServerName:add(value=HOSTNAME)

       2. Set the database name

          Run the following command to configure the database name:

          /subsystem=datasources/xa-data-source=XA_DATASOURCE_NAME/xa-datasource-properties=DatabaseName:add(value=DATABASE_NAME)

    4. Enable the datasource:

       xa-data-source enable --name=XA_DATASOURCE_NAME

  • Management Console

    1. Section 2.2.2, “Log in to the Management Console”.

    2. Navigate to the Datasources panel in the Management Console

       1. Select the Configuration tab from the top of the console.
       2. For Domain mode only, select a profile from the drop-down box at the top left.
       3. Expand the Subsystems menu on the left of the console, then expand the Connector menu.
       4. Select Datasources.
    3. Select the XA Datasource tab.

    4. Create a new XA datasource

       1. Click Add.
       2. Enter the new XA datasource attributes in the Create XA Datasource wizard and click Next.
       3. Enter the JDBC driver details in the Create XA Datasource wizard and click Next.
       4. Enter the XA properties and click Next.
       5. Enter the connection settings in the Create XA Datasource wizard.
       6. Click the Test Connection button to test the connection to the XA datasource and verify the settings are correct.
       7. Click Done to finish