Subject Problem in Jaybird
Author Nickolay Samofatov
Hello, All !

Sometimes (once a few millions transactions) I see following message in
logs of my system on production server. My application server safely handles
it (rolls back transaction and checks for connection validity), but I think
it may be a Jaybird problem.

I use CVS build that is ~2 months old.

----
java.lang.IllegalStateException: registerStatement called with no transaction
at org.firebirdsql.jca.FBManagedConnection.registerStatement(FBManagedConnection.java:840)
at org.firebirdsql.jdbc.FBConnection.registerStatement(FBConnection.java:1106)
at org.firebirdsql.jdbc.FBStatementFetcher.<init>(FBStatementFetcher.java:41)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:103)
at org.firebirdsql.jdbc.FBStatement.getResultSet(FBStatement.java:550)
at org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:113)
at com.bssys.server.Database.int_gen_id(Database.java:283)
at com.bssys.server.Database.gen_id(Database.java:300)
at com.bssys.server.DataObject.insert(DataObject.java:1671)
at com.bssys.server.docflow.DocumentObject.insert(DocumentObject.java:899)
...
----

possibly this is a bug in my server. It is massively multi-thread and
it uses its own statement caching (and it may try to use statements
across tranasactions), but Jaybird error message is pretty obscure.

--
Best regards,
Nickolay Samofatov mailto:skidder@...