On Mon, 5 May 2003, John Kunchandy wrote:
> 4) The Control Servlet now makes a call to the ConnectionManager to Free the
> Connection .(but since the Result Set still has values Connection is not
> freed).
That sounds to me like a problem with your pooling. Your pooling code
should return a pooled connection to a properly usable state when
Connection.close() is called, regardless of the current state of the
connection. If it can't do so, it should do a "real" close of the
connection.
Pooling code is very difficult to write. I suggest that unless you are a
real expert, you just use someone else's. Or, if it's a low-volume site,
you can get by without any pooling at all.
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC