CA AuthMinder Windows Installation Guide › Configuring Application Server › Enabling Database Connection Pooling › JBoss

JBoss

This section provides the steps to enable JBoss for JNDI-based database operations.

1. Navigate to the location where you have deployed the WAR files. For example:

   <JBOSS_HOME>/server/default/deploy
   

2. Create a data source descriptor file named arcotdatabase-ds.xml.
3. Collect the following information that is required to define a data source in the arcotdatabase-ds.xml file:
   • JNDI Name

     The JNDI name used by the CA components. This name must match with the AppServerConnectionPoolName.N in arcotcommon.ini (without the java:comp/env/ prefix).

   • User ID

     The database user ID.

   • Password

     The database password.

   • JDBC Driver Class

     The JDBC driver class name. For example, oracle.jdbc.driver.OracleDriver.

   • JDBC URL

     The JDBC URL for the database server. For example, if you are using Oracle driver, then URL would be: jdbc:oracle:thin:<server>:<database_port>:<sid>.

   • Exception Sorter Class

     Class that implements the org.jboss.resource.adapter.jdbc.ExceptionSorter interface, which determines whether the exception indicates a connection error.

     Use this parameter for Oracle database only. Set it to org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter.

4. Open the arcotdatabase-ds.xml in a text editor.
5. Add the following content:

   <?xml version="1.0" encoding="UTF-8"?>
   <datasources>
   <local-tx-datasource>
   <jndi-name>SampleDS</jndi-name>
   <connection-url><jdbcurl></connection-url>
   <driver-class><JDBC Driver class></driver-class>
   <user-name><database_userid></user-name>
   <password><database_password></password>
   <exception-sorter-class-name><Exception Sorter Class></exception-sorter-class-name>
   </local-tx-datasource>
   </datasources>
   

6. Save and close the file.