Subject | Re: [Firebird-Java] DataExpress problem JayBird 3 Beta |
---|---|
Author | |
Post date | 2016-12-08T09:46:21Z |
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
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