File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pooling" Watch "Connection pooling" New topic
Author

Connection pooling

Mike Southgate
Ranch Hand

Joined: Jul 18, 2003
Posts: 183
I'm writing a web app that will support an unknown number of concurrent users, so I need to establish some sort of database connection pooling. In another forum someone implied that JNDI provided some support in this respect. Could anyone here elaborate?
ms


ms<br />SCJP, SCJD
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
Hi Mike,
I had the same question yesterday and the answer I got back was that I don't particularly need to use a database connection pooling package since Tomcat (not sure what you are planning to use) will allow me to setup and JNDI datasource.
If you are using an app server they mostly (I think) have the connection pooling facility. With tomcat, if you follow the instructions here: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html, you can very easily setup the connection pooling, tomcat uses DBCP.
Ofcourse, another option is to use the DBCP package directly, you can get the package from Jakarta website.
I hope this helps.


The secret to creativity is knowing how to hide your sources.
javen fang
Greenhorn

Joined: Jun 29, 2003
Posts: 4
Resin also offer Connection Pool


I believe I can fly<br />...................<br /> Just do it !!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pooling