How can I create a JNDI database connection in Tomcat for use in voice applications?
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 class. • You can download it from mysql.com. • We highly recommend Version 3.1.11 (or higher) since 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 setup. • 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. • Expand the Host (hostname) branch and then the Context (/Audium) branch. • Click Data Sources and add the data source. • The data source must be named jdbc/ANY_NAME_YOU_CHOOSE. For example, you can ch