Configure the JBoss Application Server for JNDI-Based Database Operations

This section describes how to enable JBoss Application Server for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
aa813test
This section describes how to enable JBoss Application Server for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
Follow these steps
:
  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 for defining a data source in the arcotdatabase-ds.xml file:
    • JNDI Name
      The JNDI name that is used by the Arcot 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.