[Proxool-developer] "get connection from pool on create statement" AND "return connection to pool when statement is closed"

[Mark <ma...@te...>]

hi proxool developers,

i am interested in using proxool as a solution to easily supporting =
database connection pooling without changes in our JSP application.  i =
need advice from you guys on a requirement because it seems that there =
is no way of doing it given the current proxool version after reading =
through the documents and mailing list archive.

we designed our JSP application 4 years ago such that it uses 1 =
connection object per user session.  now, we are having a problem =
because the JSP application is hitting the maximum connections our =
database can support.  this would not be a problem if each JSP gets a =
connection from the pool and closes it afterwards.  we now have more =
than 500 JSP pages.

now, im thinking that it would be nice if the connection is returned to =
the pool everytime a statement is closed.  and a connection is retrieved =
from the pool if a statement is created.  do you think this is a =
worthwhile addition to proxool ?  or is this already supported?  or are =
there alternatives?

i don't mind contributing code to proxool to achieve this.  i just want =
to know alternative solutions for our problem.  ill also appreciate if =
you can point me to another project offering this kind of feature.

thanks in advance,

mark