Recently we tested JayBird 2.0 Beta 2. In our database update
code we turn the auto commit mode on for DDL statements and
off for DML. It runs without problems but while closing the
connection the following exception is thrown:

java.lang.IllegalStateException: Can't destroy managed connection
with active transaction
at
org.firebirdsql.jca.FBManagedConnection.destroy(FBManagedConnection.java:488)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.connectionClosed(FBStandAloneConnectionManager.java:88)
at
org.firebirdsql.jca.FBManagedConnection$4.notify(FBManagedConnection.java:1077)
at
org.firebirdsql.jca.FBManagedConnection.notify(FBManagedConnection.java:1060)
at
org.firebirdsql.jca.FBManagedConnection.close(FBManagedConnection.java:987)
at
org.firebirdsql.jdbc.AbstractConnection.close(AbstractConnection.java:492)
at it.prodata.sql.jdbc.AutoCommitTest.run(AutoCommitTest.java:177)
at it.prodata.sql.jdbc.AutoCommitTest.main(AutoCommitTest.java:195)


I uploaded a test program (ActiveTransactionTest.java) in the
Files section to reproduce the problem.

Stephan Perktold