Subject | Re: Connection Pools and Autocommit |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-06-13T12:53:26Z |
Hi,
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
> Just a quick question. If I have a connection pool (a seperate oneIf pool does not change transaction management (like
> 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?
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