CA Adapter Windows Installation Guide › Deploying and Configuring State Manager › Creating a JNDI Connection › Apache Tomcat

Apache Tomcat

To create a JNDI connection in Apache Tomcat:

1. Collect the following database-specific information:
   • JNDI Name

     The JNDI name used by the Arcot components.

     Note: The value you enter in the JNDI Name field must exactly match the "Primary JNDI Name" that you have configured in the AFM wizard.

   • User ID

     The database user ID.

   • Password

     The database password.

   • JDBC Driver Class

     The JDBC driver class name. Depending on the database you are using, this value would be one of the following:

     For MS SQL Server:

     com.microsoft.sqlserver.jdbc.SQLServerDriver

     For MySQL:

     com.mysql.jdbc.Driver

     For Oracle:

     oracle.jdbc.driver.OracleDriver

   • JDBC URL

     The JDBC URL for the database server. Depending on the database you are using, this URL would be one of the following:

     For MS SQL Server:

     jdbc:sqlserver://server:port_number;databaseName=database_name;selectMethod=cursor

     For MySQL:

     jdbc:mysql://host_name:port_number/database_name

     For Oracle:

     URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))

2. Take a backup of server.xml file present in the TOMCAT_HOME\conf directory.
3. Open the server.xml file present in the TOMCAT_HOME\conf directory.
4. Use the information that you collected in Step 1 to add an entry in the following format for defining the data source within the <GlobalNamingResources> tag:

   <Resource name="data source_name" auth="Container" type="javax.sql.DataSource" username="user_id" password="password" driverClassName="JDBC_driver_class" url="jdbc_url" maxWait="30000" maxActive="32" maxIdle="4" initialSize="4" timeBetweenEvictionRunsMillis="600000" minEvictableIdleTimeMillis="600000"/>
   

5. Save and close the server.xml file.
6. Take a backup of the context.xml file present in the TOMCAT_HOME\conf directory.
7. Open the context.xml file present in the TOMCAT_HOME\conf directory.
8. Use the information that you entered in Step 4 to add an entry in the following format for defining the data source within the <Context> tag. The data source name that you specify in this step must be the same as the data source name that you specify in Step 4.

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

9. Save and close the context.xml file.