updated the test to share transaction over multiple connections but not with multiple users