This section explains how to create a new JNDI database
connection in Tomcat. These instructions are useful when you would like to use
the built-in Studio Database element, or create some custom code that accesses
database functionality through JNDI.
- In order enable
database access on your application server, a compatible JDBC driver must be
installed. These drivers, typically packaged as JAR files, should be placed in
a directory accessible to the application server classpath (on Tomcat, for
example, place in
||The database must exist for this connection to work. CVP
VXML Server will not create the database for you.
- Add a Tomcat Context
for the database connection so that the CVP VXML Server knows how to
communicate with your database.
Follow the instructions provided here.
- In Audium Builder
for CVP Studio, edit the configuration of the Database element in question.
Enter the string you entered
below in <LABEL_YOU_CHOOSE> from the Tomcat
Context into the JNDI Name property of the Settings tab of your Database
Here is an example that uses MySQL (edit
||You should not include the
jdbc/ portion here.
The default port number for MySQL is 3306. An example url for
the above Context would be
<Resource> can be configured in the
server.xml file under
<GlobalNamingResources>, and a
<ResourceLink> created in
4. Under heavy load conditions, enable Database Connection
A database connection pool creates and manages a pool of
connections to a database. Recycling and reusing already existing connections
to a database is more efficient than opening a new connection. For further
information on Tomcat Database Pooling