my dog learned polymorphism*
The moose likes Tomcat and the fly likes Connection Pooling on Tomcat Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Connection Pooling on Tomcat" Watch "Connection Pooling on Tomcat" New topic

Connection Pooling on Tomcat

Siamak Saarmann
Ranch Hand

Joined: Aug 21, 2004
Posts: 77

I am using direct JDBC connections in my web application. It seems to me that it opens too many connections to database and I need to do something.

Would somone please forward me to code snippet that shows how can I use Tomcat managed database connections?


PhD Candidate: Distributed and Parallel Systems, Simulation and Modeling
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 60810

Using the container-managed connection pooling should indeed solve your problem. I've moved this to the Tomcat forum where it should get better exposure to Tomcat users.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
The links below should get you started:

JNDI Resources HOW TO

JNDI Datasources HOW TO

Commons DBCP Overview
Siamak Saarmann
Ranch Hand

Joined: Aug 21, 2004
Posts: 77

Thank you for your help.

Regards, Mac
Don't get me started about those stupid light bulbs.
subject: Connection Pooling on Tomcat
Similar Threads
Ned to change servlet code to pure java
jdbc-servlets-connection pooling
Database Connections not to be retruned from Connection Pool
Connection Pooling in Tomcat
Connection Pooling in tomcat