CA Adapter UNIX Installation Guide › Deploying and Configuring State Manager › Creating a JNDI Connection › Apache Tomcat (C7_CJNDI_TOMCAT)

Apache Tomcat (C7_CJNDI_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;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="datasource-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="datasource-name" name="datasource-name" type="javax.sql.DataSource"/>

9. Save and close the context.xml file.