Added tests for explicit transaction management