added commit and rollback to connection context management