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

JBoss Application Server

This section walks you through the steps to enable JBoss Application Server for JNDI-based database operations. To create a data source for RiskMinder in JBoss Application Server:

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 called arcotdatabase-ds.xml.
3. Collect the following information required to define a data source in the arcotdatabase-ds.xml file:
   • JNDI Name: The JNDI name used by RiskMinder components. This name must match with the AppServerConnection PoolName.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 the URL will be: jdbc:oracle:thin:<server>:<database_port>:<sid>.

   • Exception Sorter Class: The class for implementing 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.