Hi,

Confirmed. If exception happens in commit() or rollback() transaction
is lost and is never ended. Because transaction is still active,
connection is not closed. This is a bug. We will try to find the
solution as soon as possible.

Best regards,
Roman Rokytskyy

--- In Firebird-Java@y..., "sp64_asaon" <stephan.asa@d...> wrote:
> Since I didn't get any response to this mail would like to ask
again
> if somebody with more knowledge of the internals of the
> communication between JayBird and Firebird and the management of
the
> resources like connection, statements and sockets could take care
of
> this problem.
> This bug prevents us from switching to JayBird (it works with
> InterClient, but fails with JayBird!).
>
> To reproduce the problem I uploaded a test program to the yahoo
file
> area:
> http://groups.yahoo.com/group/Firebird-Java/files/TestReconnect.java
>
> Version-Info:
> Firebird 1.0.0.821
> JayBird (latest cvs)
> InterClient/InterServer 2.01 (latest cvs)
> Windows XP Pro SP1
>
> Thanks
> Stephan