How to set up the JBoss JDBC connections?

1. Copy the JDBC driver(Microsoft SQL Server JDBC driver: sqljdbc.jar or jTDS JDBC driver: jtds-1.2.jar) to the Jboss folder.
%JBOSS_HOME%\server\instance\lib (%JBOSS_HOME% indicates the JBoss installation path)

Here we take SQL Server as an example, for more information about your specific driver type, please refer to APB Help|Appeon Server Configuration Guide for J2EE|Database Connection Setup|JDBC driver preparation|Copying drivers to Appeon Server.

2. Configure the JBoss datasource.
Copy the [jboss_root_directory]/docs/examples/jca/ mssql-ds.xml,  you can modify the contents red below. And then copied to the [jboss_root_directory]/server/default/deploy directory.

This is the Microsoft SQL Server JDBC driver datsource xml file.

<datasources>

  <local-tx-datasource>

    <jndi-name>MSSQLDS</jndi-name>

    <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase;SelectMethod=cursor</connection-url>

    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

    <user-name>sa</user-name>

    <password>appeon</password>

        <!-- sql to call when connection is created

        <new-connection-sql>some arbitrary sql</new-connection-sql>

        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool

        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>

        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <metadata>

         <type-mapping>MS SQLSERVER</type-mapping>

      </metadata>

  </local-tx-datasource>

</datasources>

3. Restart the JBoss.

4. Go to the AEM Console > Application Properties > Transaction Objects > [your application name] to setup the Transaction Object.