Documentation
Kattare is dedicated to making your hosting experience as painless as possible.
That means making as much help and documentation available as possible.
If you have a question that you think would be helpful to have here, please
[Submit your Question].
|
|
| Category |
| MySQL |
|
Question
|
Last Modified: Feb 05, 2004
|
| How do I get an existing Tomcat Context to use MySQL pooling? |
| Answer |
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.
|
[FAQ Main]
[Submit a Question]
[Back to Category "MySQL"]
|
