if connection 2: COMMIT TRAN is done initially (in code)

and some err in connection 1

then connection 2: cannot not be rolled back right ?