#2 Commit when a connection time-out occurs

open
nobody
Behaviour (3)
5
2006-07-24
2006-07-24
No

Hello,

I use proxool to connect to an Oracle database.

When a connection time-out occurs, a 'commit' is done
although 'autoCommit' is false.
I think that is not very good !

The problem comes from the JDBC driver for Oracle.
There is an implicit COMMIT when the connection is
closed (and an implicit ROLLBACK when the connection is
garbage-collected).

So I suppose that when a time-out occurs, proxool tries
to close the current connection whithout doing a
rollback if autoCommit is false. (I read the source
code of the class ConnectionResetter that seams to do
that code. But the connection is already closed when
the class ConnectionResetter tries to do a rollback (an
SQLException is thrown)... )

Thanks for your help.

Sébastien.

Discussion