Database connection pooling

We do not recommend using connection pooling in our environment since the connection establishment to the DB is lightweight process. Just close the DB connections when you're finished with them and reopen them when needed.

request scope is an excellent lifespan for a DB connection.

Be especially careful when reusing pooled connections since the RDBMS might be configured to timeout inactive connections and you might encounter:

java.sql.SQLException: No operations allowed after connection closed
  • Java, Tomcat, Database, Connection, Pooling, MySQL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Our Java environment

We run Tomcat application server on Oracle JVM. Tomcat is run behind Apache HTTPd front-end so we...

Which domains and subdomains can have Tomcat web apps

A domain or subdomain can have Tomcat web apps deployed if it: has hosting enabled is active,...

Before requesting deployment

It is important to test your Tomcat web apps locally before requesting their deployment. The...

Where should you upload your Tomcat web apps

Tomcat web apps should you placed directly in the DocumentRoot. For a subscription's main domain...

WAR files

WAR files must be extracted in order to be deployed. E.g. the contents of test.war should be...