General Inquiries | Knowledge Base | Submit Trouble Ticket

Knowledge Base - FAQ

Question: How do I get an existing Tomcat Context to use MySQL pooling?

FAQ entry generously donated by Chris Beels.

This tutorial assumes you are already running a Tomcat context, and perhaps even have used JDBC to get connected to your MySQL. You're looking for a faster, more robust option, and you've come to the right place.

Tomcat provides an excellent example here but we've provided some kattare-specific pointers here as the connection section of the server.xml is significantly different.

When you signed up for Kattare, you received a MySQL account email that looked like this:

Database Server: SERVER_NAME
Database Login: LOGIN
Database Password: PASSWORD
Database Name: DB_NAME

Make the following changes to the Tomcat docs example
- change the username and password from "javauser/javapass" to your "LOGIN/PASSWORD"
- change the URL parameter to jdbc:mysql://SERVER_NAME:3306/DB_NAME?autoReconnect=true

Restart Tomcat with the new server.xml and web.xml changes from the docs, and you should be good to go.