You should read up on the general functionality of a Connection Pool. You are
not creating a new one each time, you are creating the pool once and accessing
it multiple times from your servlets. Check out:
www.javaexchange.com
for a (much) more detailed explanation of how to use a Connection Pool.
Sam Rose wrote:
> 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
