check www.servletguru.com for a chapter 9 from his book Java Servlets Developer's Guiden. (JDBC and connection pooling)
-----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 4:22 PM To: Tomcat Users List Subject: Tomcat and connection pooling Hi, I am using tomcat 4.0.4 and developing a web application for as400 database, now IBM has provided with a set of libraries to connect with AS400 database, there is a class called AS400JDBCConnectionPool which creates a connection pool, there are methods to get the connection and return the connection back to pool So the question is, if i create say 30 connections and keep them in the pool in a servlet which is called when i start the application, how can i get access to this pool (handle of the object created in the first servlet) in other servlets running in the application.. I dont want to keep it in session, or should i keep the scope of the object at application level?? is there any connection pooling example available Ashish __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
