Can somebody please quickly tell me if tables/rows are automatically locked during a transaction?
If so, are they locked until the transaction is either committed or rolled-back?
What happens if somebody tries to access the locked row/table from another Connection? Is an exception thrown immediately or does the Connection attempt to wait for the locked table/rows to become available again and then throw an exception after some timeout period?
I have read a little bit about transaction isolation levels but have limited understanding of them.
Thanks,
bunton