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
- 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
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
- In Audium
Builder for CVP Studio, edit the configuration of the Database element in
question. Enter the string you entered
in <LABEL_YOU_CHOOSE> from the Tomcat Context into the JNDI Name property
of the Settings tab of your Database element.
Here is an example that uses MySQL (edit
should not include the
jdbc/ portion here.
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 Pooling.
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