Subject Re: [Firebird-Java] Re: Problem on reconnection
Author Lars George
Roman,

Is this related to the problem we currently experience that we sometimes get
an error which causes our pool to get stuck with the JayBird driver. It
can't rollback anymore, nor commit and reports "Local transaction still
active" or something similar? When this happens we cannot get rid of the
connection.

If so, how can I check if this problem is fixed in the near future? Do you
have a bug list and if so, what is the bug id of this problem?

Thanks,
Lars

----- Original Message -----
From: "Roman Rokytskyy" <rrokytskyy@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, November 22, 2002 4:26 AM
Subject: [Firebird-Java] Re: Problem on reconnection


> 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
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>