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

Apache Tomcat

This section provides the steps to enable Apache Tomcat for JNDI-based database operations. To create a JNDI connection in Apache Tomcat:

1. Install the Apache Tomcat application server and test the installation by using the following URL:

   http://localhost:8080/
   

2. Open the server.xml file present in the <TOMCAT_HOME>/conf/ directory.
3. Collect the following information required to define a data source:
   • JNDI Name

     The JNDI name used by RiskMinder.

     Important! 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 the Oracle driver, then URL will be:

     jdbc:oracle:thin:<server>:<database_port>:<sid>
     

4. Add the following entry to define the data source within the <GlobalNamingResources> tag:

   <Resource name="SampleDS"
           auth="Container"
           type="javax.sql.DataSource"
   	    factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
           username="<userid>"
           password="<password>"
           driverClassName="<JDBC driver class>"
           url="<jdbc-url>"
           maxWait="30000"
           maxActive="32"
           maxIdle="8"
           initialSize="4"
           timeBetweenEvictionRunsMillis="300000"
           minEvictableIdleTimeMillis="30000"/>
   

5. Open the context.xml file available in the <TOMCAT_HOME>\conf\ directory.
6. Add the following entry to define the datasource within the <Context> tag:

   <ResourceLink global="SampleDS" name="SampleDS" type="javax.sql.DataSource"/>
   

7. To enable database connection pooling, download the following files from the corresponding third-party source. Then, copy these files to the <TOMCAT_HOME>\common\lib\ folder (on Apache Tomcat 5.x) or the <TOMCAT_HOME>\lib\ directory (on Apache Tomcat 6.x and 7.x).
   • commons-dbcp-1.2.2.jar
   • ojdbc14-10.2.0.1.0.jar (for Oracle database)
   • sqljdbc.jar (Microsoft JDBC driver for MS SQL Server 2005 - version 1.2.2828)
   • mysql-connector-java-5.1.22-bin.jar (for MySQL database)