Derby - SQLException

General Discussion
1

Hello,

I get the following message at the end of executing a liquibase script:

“Error closing database: java.sql.SQLException: Cannot close a connection while a transaction is still active”

The script however executes and all the database changes are carried out.
I am using Derby v10.6.1.0 and Liquibase v1.9.5

Can anyone suggest how to resolve this issue.

Thanks.

2

(sorry for the slow response.  I was on vacation and have since been very far behind)

I have not seen that error with my derby testing.  Each changeSet should run in its own transaction which is committed at the end of each transaction.  Are you doing any transactions of your owns in changeSets?  Do you get the error even if there are no changeSets executed?

Nathan