This document describes how to create a new Java naming and directory
interface (JNDI) database connection in Tomcat. These instructions help utilize
the built-in database element or create custom code that accesses database
functionality through JNDI.
The information in this document is based on Cisco Unified Call
Services, Universal Edition, and Cisco Unified Call Studio, Universal
Technical Tips Conventions for more information on document
Symptoms: The developer wants to create a new JNDI
database connection in Tomcat.
Resolution: Follow these instructions to create a new
JNDI database connection in Tomcat:
Download and install the com.mysql.jdbc.Driver
You can download it from
Cisco recommends Version 3.1.11 (or higher) because Version
3.1.10 has compatibility problems.
The recommended location for the JAR file that includes this
class is TOMCAT/common/lib, but you can place the JAR file anywhere in your
classpath if this is not an appropriate location for your
Add a Data Source under the /Audium context in Tomcat. It is highly
recommended that the web-based interface be used for this since several text
fields need to be filled out, rather than an XML file.
Access the web interface at
Expand the Host (hostname) branch and then the Context (/Audium)
Click Data Sources and add the data
The data source must be named
jdbc/ANY_NAME_YOU_CHOOSE. For example, you can choose
Enter the URL of the database in Data Source URL
Enter the username and password of the database user that has the
rights to access the database listed in Step 4.
Click the Commit Changes button to save this new
data source after it has been added.
In the voice application, edit the configuration of the database
element in question.
Set the JNDI name to the ANY_NAME_YOU_CHOOSE
portion of the information you entered in the Tomcat settings.
For example, you can enter DBConnection.
Note: You must not include the jdbc/ portion