AW: [OFF-TOPIC]Yoav --> RE: Some pretty basic Tomcat ConnectionPooling Questions????

[SH Solutions <sh...@gmx.net>]

Hi

Sorry, I haven't read the whole treads, but:

> Before I made this change I didn't have a conn.close() statement or a
finally clause anywhere either (I DID have resultset.close and
statement.close()).

Never never do that.
If you do not call connection.close(), the connection is NOT returned to the
pool. So ALWAYS close().
(Maybe you are lucky and there are some special precautions of the pool
driver, that make this work, but most drivers do not.)

Regards,
  Steffen


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org