CA AuthMinder UNIX Installation Guide › Configuring Application Server › Enabling Database Connection Pooling › Apache Tomcat

Apache Tomcat

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

Perform the following steps to create a JNDI connection in Apache Tomcat:

1. Install Apache Tomcat, and test the installation using the following URL:

   http://localhost:8080/

   The preceding URL must open the Apache Tomcat home page.

2. Open the server.xml file present in the <TOMCAT-HOME>/conf directory.
3. Collect the following information for defining a data source:
   • JNDI Name

     The JNDI name that is used by the product 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>.

4. Add the following entry to define the datasource 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 present 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. Copy the following database connection pooling (DBCP) dependencies to <TOMCAT-HOME>/common/lib directory.
   • commons-dbcp-1.2.2.jar
   • ojdbc14-10.2.0.1.0.jar (for Oracle Database)
   • sqljdbc.jar (Microsoft JDBC driver for Microsoft SQL Server 2005 - version 1.2.2828)
   • db2jcc-9.5.jar (for IBM DB2 UDB)
   • mysql-connector-java-5.1.22-bin.jar (for MySQL)

Configuration changes for Tomcat8 (apache-tomcat-8.0.24) and JDK8 (1.8.0_51)

1. Creating JNDI connection:

   There are few configuration attribute names that have been updated in tomcat 8. Couple of them are listed in the sample here. Verify your attribute names from tomcat 8 documentation if you are using any others which are not shown in the sample.

   <Resource name="< data source_name >" auth="Container"

   type="javax.sql.DataSource" username="USER_ID" password="PASSWORD"

   driverClassName="JDBC_Driver_Class " url="JDBC_url" maxWaitMillis="30000"

   maxTotal="32" maxIdle="4" initialSize="4"

   timeBetweenEvictionRunsMillis="600000"

   minEvictableIdleTimeMillis="600000"/>

   Note :

   The maxActive configuration option has been renamed to maxTotal

   The maxWait configuration option has been renamed to maxWaitMillis

2. Make sure you use the latest database jar.
   • For sql server - sqljdbc4.jar
   • For oracle ojdbc6.jar
3. Enabling SSLv3

   Java 8 disables SSLv3 by default. To enable it follow these steps:

   1. Go to “<JRE_HOME>\lib\security” folder used by tomcat.
   2. Open java.security file.
   3. Check if the property “jdk.tls.disabledAlgorithms” has SSLv3, if yes remove the SSLv3 value.