This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes row level lock issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "row level lock issue" Watch "row level lock issue" New topic
Author

row level lock issue

Nevin kumar
Ranch Hand

Joined: Mar 15, 2008
Posts: 93
1. autocomit set to true
2. transaction isloation level set to none
3. two statements executed . one does read on a row. the second one does update on the same row.
4. we donot close the connection.
5.Using a database client, we check using a select that the row was correctly updated.
6. do a update on the same query using the database client (such as toad)
7. the update query keeps running forever.

Looks like a lock on that row is being held but no idea who is holding and why? any clue?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

How have you managed to set transaction isolation level to none? This is only going to apply if you are using a database that does not support transactions. I can only think of two database (Access and MySQL's MyISAM database engine) that allow data access without transaction; are you using either of those?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: row level lock issue