Subject Re: [Firebird-Java] DataExpress problem JayBird 3 Beta
Author
Hi Mark,

I have struggling for many years JBuilder DataExpress (DX) library together with JayBird. The following exceptions messages are sporadically thrown:

no transaction for request
invalid transaction handle
This connection is closed and cannot be used now
You cannot getAutomcommit on an unassociated closed connection

I have been playing around with DX Database object properties.

Now thought to try the Jaybird 3 Beta with a lot of optimism! Unfortunately after some calls I get this exception all the time:

java.sql.SQLNonTransientException: No transaction or transaction not ACTIVE
    at org.firebirdsql.gds.ng.TransactionHelper.checkTransactionActive(TransactionHelper.java:49)
    at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:57)
    at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:1399)
    at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1229)
    at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:147)
    at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:49)
    at org.firebirdsql.jdbc.FBDatabaseMetaData.getStatement(FBDatabaseMetaData.java:5035)
    at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:5061)
    at org.firebirdsql.jdbc.FBResultSetMetaData.getExtendedFieldInfo(FBResultSetMetaData.java:506)
    at org.firebirdsql.jdbc.AbstractFieldMetaData.getExtFieldInfo(AbstractFieldMetaData.java:342)
    at org.firebirdsql.jdbc.AbstractFieldMetaData.getPrecisionInternal(AbstractFieldMetaData.java:280)
    at org.firebirdsql.jdbc.FBResultSetMetaData.getPrecision(FBResultSetMetaData.java:281)
    at com.borland.dx.sql.dataset.RuntimeMetaData.a(Unknown Source)
    at com.borland.dx.sql.dataset.JdbcProvider.b(Unknown Source)
    at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
    at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
    at com.borland.dx.dataset.DataSet.a(Unknown Source)
    at com.borland.dx.dataset.DataSet.open(Unknown Source)

BR,
Hugo