This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 17166
    
  27

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.


An IDE is no substitute for an Intelligent Developer.
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
 
It's not a secret anymore!