File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Lock table in database when doing write operation.
Joined: Jun 01, 2006
May 08, 2007 09:01:00
Based on my understanding, when we do write operation to a table in database (MYSQL) we lock the table from bein accessed by another processess. But not when we do read operation.
Is this true?
If yes, then is there a way I can turn of some settings so the write operation will not lock the table?
Is there any disadvantages in doing this?
Thanks in advance for the help.
I agree. Here's the link:
subject: Lock table in database when doing write operation.
Monkhouse DVD example: 2 levels of locking
Table-level locking, how?
Locking Suggestions and Help
a simple question of Locking mechanism
question on Lock
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015