Subject Re: Connection Pools and Autocommit
Author Roman Rokytskyy
Hi,

> Just a quick question. If I have a connection pool (a seperate one
> to the inbuilt one) with 10 connections all in autocommit mode, does
> each connection keep an open transaction? ie will it effect the
> oldest aktiv transaction if only one of the connections is ever used?

If pool does not change transaction management (like
setAutocommit(false) and then execute some statement and it _does not_
commit tx), then everything should be ok.

Transaction is started only before the statement is executed, and is
committed when either commit() was called or statement is completed in
auto-commit mode.

Best regards,
Roman