Add support for clearing connection from active and uncached statements

1 files changed, 13 insertions, 0 deletions

diff --git a/odb/sqlite/transaction-impl.cxx b/odb/sqlite/transaction-impl.cxx
index 3730100..36d6c2b 100644
--- a/odb/sqlite/transaction-impl.cxx
+++ b/odb/sqlite/transaction-impl.cxx
@@ -28,6 +28,13 @@ namespace odb
     void transaction_impl::
     commit ()
     {
+      // Reset active and finilize uncached statements. Active statements
+      // will prevent COMMIT from completing (write statements) or releasing
+      // the locks (read statements). Finilization of uncached statements is
+      // needed to release the connection.
+      //
+      connection_->clear ();
+
       connection_->statement_cache ().commit_statement ().execute ();
 
       // Release the connection.
@@ -38,6 +45,12 @@ namespace odb
     void transaction_impl::
     rollback ()
     {
+      // Reset active and finilize uncached statements. Active statements
+      // will prevent ROLLBACK from completing. Finilization of uncached
+      // statements is needed to release the connection.
+      //
+      connection_->clear ();
+
       connection_->statement_cache ().rollback_statement ().execute ();
 
       // Release the connection.