Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pooling

 
Mike Southgate
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Faisal Khan
Ranch Hand
Posts: 285
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
javen fang
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Resin also offer Connection Pool
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic