It's not a secret anymore!*
The moose likes Tomcat and the fly likes Database Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Database Connection Pooling" Watch "Database Connection Pooling" New topic
Author

Database Connection Pooling

Steve Granton
Ranch Hand

Joined: Jan 13, 2002
Posts: 200
Hi,
Does Tomcat provide database connection pooling.
If so can someone post me a link to an example of how to set it up.
Does it use data sources and JNDI to obtain a reference to the connection pool?
Cheers,
Steve
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16019
    
  20

Tomcat doesn't provide database anything.
However, it's not such a big deal to setup connection pools using JDBC and do your own.
Struts DOES provide some basic (and extensible) support for connection pooling. It's one of the topics covered in the sample app for this article:
http://www.fawcette.com/javapro/2002_04/magazine/features/tholloway/
The sample app itself is running on a Tomcat server
at http://www.mousetech.com/strutsdemo/index.jsp and is annotated so you can see the components at work (hint: look at the struts-config.xml files and the "xxxxForm.java" files.


Customer surveys are for companies who didn't pay proper attention to begin with.
Michael Jaeger
Greenhorn

Joined: Apr 11, 2002
Posts: 5
Well, in fact, Tomcat does provide connection pooling.
See here http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Connection Pooling