Re: confused about transactions and connection pools

On Mon, 30 Oct 2006, David Goodenough wrote:

> The we get to the second time through the servlet.  First thing - no BEGIN
> or ROLLBACK, but the code went through a call to connection.setAutoCommit(
> false).  Secondly this odd statement that I do not recognise id no longer
> there.
>

For each connection the statements BEGIN, ROLLBACK, and COMMIT are only
prepared once and after that they are executed again and again.  This can
be very confusing when looking at the logs which only show the preparation
step, but not execution.  So even though you can't see them, they're being
executed.  The 8.2 release will be the first release that can accurately
log this usage pattern.

Kris Jurka