I hope it helps.
My guess is that it is trying to autocommit the transaction on
doQuery(), but I have tried with and without setting the auto-comit to
true and false with no effect.

org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unrecognized
transaction
Reason: Unrecognized transaction
at
org.firebirdsql.jdbc.AbstractConnection.doQuery(AbstractConnection.java:1062)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getTables(FBDatabaseMetaData.java:2327)
at
com.metastores.test.bugreport.FirebirdGetTables.getAllTables(FirebirdGetTables.java:108)
at
com.metastores.test.bugreport.FirebirdGetTables.testGetAllTables(FirebirdGetTables.java:53)
at
com.metastores.test.bugreport.FirebirdGetTables.main(FirebirdGetTables.java:21)
at org.firebirdsql.jca.FBXAException: Unrecognized transaction
at
org.firebirdsql.jca.FBManagedConnection.internalEnd(FBManagedConnection.java:437)
at
org.firebirdsql.jca.FBLocalTransaction.internalCommit(FBLocalTransaction.java:150)
at
org.firebirdsql.jdbc.AbstractConnection.doQuery(AbstractConnection.java:1058)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getTables(FBDatabaseMetaData.java:2327)
at
com.metastores.test.bugreport.FirebirdGetTables.getAllTables(FirebirdGetTables.java:108)
at
com.metastores.test.bugreport.FirebirdGetTables.testGetAllTables(FirebirdGetTables.java:53)
at
com.metastores.test.bugreport.FirebirdGetTables.main(FirebirdGetTables.java:21)
Exception occured!


--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > The same piece of code running against 5 other databases causes no
> > error, but it keeps throwing:
> > org.firebirdsql.jdbc.FBSQLException: Resource Exception.
> > Unrecognized transaction
> > or returning null (depending on args)
>
> Can you post full stack trace?
>
> > Here is the sample code that I use:
>
> Works for me without any problems.
>
> Roman