Subject Re: [Firebird-Java] Transaction problem
Author Mark Rotteveel
On 3-3-2014 19:30, hugo.larson@... wrote:
> Sorry this is maybe a repost but I want to raise this issue.
> I'm using JBuilder DataExpress components together with JayBird 2.2.3.
> Sporadicly I get the following exceptions:
> GDS Exception. 335544363. no transaction for request
> at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(Unknown Source)
> GDS Exception. 335544332. invalid transaction handle (expecting explicit
> transaction start)
> at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(Unknown Source)
> at org.firebirdsql.jdbc.FBPreparedStatement.<init>(Unknown Source)
> All database interaction is trough DataExpress Database object.
> If I catch these exceptions, is it possible to explicitly to mend the
> connection?
> I'm thinking of a workaround for the problem.
> I tried to close the connection and open it again but it does not work.
> At close the exception is raised again.

I need deeper stacktraces to be sure where this is thrown. There are two
possibilities: either this is purely within Jaybird and then the problem
is that the underlying FBManagedConnection has been 'destroyed', but the
FBConnection/AbstractConnection somehow isn't aware of this, or this
occurs within Firebird, but then I don't know a cause and I would really
need a reproduction script.

For the first case there is no workaround except abandoning the
connection without closing.

As to the actual cause: what part of Jaybird do you use to create the

Mark Rotteveel