On 20 Jul 2004 at 9:59, Alan McDonald wrote:

>Can someone tell me why this code leaves the database connected?

Among other reasons, you don't check return codes. If commit has
failed for any reason, the transaction is still active and you must
rollback it.

BTW, I'd like to find out a way to check whether all transactions
are finished inside a connection and if not - rollback them forcedly.
So far I don't see any way to do it. Any suggestion?

SY, Dimitry Sibiryakov.