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.
aa82test
This section describes how to enable JBoss Application Server for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
Follow these steps
:- Navigate to the location where you have deployed the WAR files. For example:<JBOSS_HOME>/server/default/deploy
- Create a data source descriptor file named arcotdatabase-ds.xml.
- Collect the following information for defining a data source in the arcotdatabase-ds.xml file:
- JNDI NameThe JNDI name that is used by the Arcot components. This name must match with the AppServerConnectionPoolName.Nin arcotcommon.ini (without the java:comp/env/ prefix).
- User IDThe database user ID
- PasswordThe database password
- JDBC Driver ClassThe JDBC driver class name, for example, oracle.jdbc.driver.OracleDriver
- JDBC URLThe 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 ClassClass that implements the org.jboss.resource.adapter.jdbc.ExceptionSorter interface, which determines whether the exception indicates a connection error.Use this parameter for Oracle Databaseonly. Set it to org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter.
- Open the arcotdatabase-ds.xml in a text editor.
- 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>
- Save and close the file.