The iterator holds a reference to a prepared statement and a result set, so the right way is to close the iterator first and then commit the transaction (which will close the connection).

This needs to be done in:

1. WorkflowMigrationManager
2. ProWorkflowMigrationManager