Sorry I forgot to add that I use this,
try {
if (pool == null) {
try {
pool = new ConnectionPool(db_address, user, passwd,
"oracle.jdbc.driver.OracleDriver", 2,1);
}
catch (Exception e) {
throw new UnavailableException(this, "Couldn't create
ConnectionPool");
}
}
//gets connection
con = pool.getConnection();
Is this what you mean, or am I still misusing the connection pool.
I have read Hunters book, and try his idea of using the connection
pool in the init. method, but as I have different users logging in, I
am unable to get their user ID and password, as the variables have not
yet been initialised.
Any ideas or suggestions?
-----Original Message-----
From: Thomas Moore [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 25, 1999 1:22 PM
To: [EMAIL PROTECTED]
Subject: Re: Can anyone explain this to me.
> 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?
Ummm... It doesn't, but that's because you're mis-applying
the
pattern. The idea is to have N Connections in the ConnectionPool,
and
then call dbConn = pool.getConnection(); The pool object keeps an
internal counter, and keeps track of how many of its connections are
in
use. The pool should generally be implemented as a singleton.
I'd recommend reading Grand's book "Patterns in Java", if you
haven't
yet...
--
Within C++ is a smaller, cleaner language
struggling to get out.
It's called Java.
Thomas Moore
[EMAIL PROTECTED] Home Account
Software.Engineer [EMAIL PROTECTED]
phone://732.462.1880:268 NJ Patterns Group Home Page
employer://Celwave, RF http://members.home.net/twmoore/cjpg
_______________________________________________________________________
____
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
