I don't know whose connection pool you are using but the normal way of
doing this is that the connection pool provider has a static pool of
connections.
Remember that this is how DriverManager works as well.
Becuase the pool is static (or has some static element) you are not
really creating multiple connection pools though you might be creating
multiple pointers to the pool manager, which is what this looks like.
Nic Ferrier
Tapsell-Ferrier Ltd
www.tapsellferrier.co.uk
>>> Sam Rose <[EMAIL PROTECTED]> 3/25/99 1:08:24 PM >>>
Database connection pools.
If I have the code in each of my servlets, i.e. the code that calls
the connection pool servlet and this code.
pool = new ConnectionPool(dba, user, passwd,
"oracle.jdbc.driver.OracleDriver", 2,1);
Is this not the same as making a new connection with each servlet.
How does this improve my connection timing?
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
