I have following style of
Start Transaction
Update Row
End Transaction
and we are working with J2ee 1.2, Struts 1.1, WebSphere Application Server 4.0.7 and Oracle 9. In normal scenarios its running fine. But if more than one users access this code simaltaneously mean one has updated record and going to End Transaction and other comes and tries to Update the Same Row Record in the DB that First one updated. I got a lock in the DB. Is there any one who helps Me.
Thanks in Advance.
-
DB LOCK (1 messages)
- Posted by: karamat ali
- Posted on: April 01 2005 13:05 EST
Threaded Messages (1)
- DB LOCK by Stefan Zobel on April 05 2005 17:42 EDT
-
DB LOCK[ Go to top ]
- Posted by: Stefan Zobel
- Posted on: April 05 2005 17:42 EDT
- in response to karamat ali
Hhm, please care to explain what behavior (other than that)
you expected? What error message ("lock") are you getting?
Can't really follow you here (e.g. "select for update ..."
and two sessions approaching the same row, what should
the DB do?)
Kind regards,
Stefan