Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes concurrent DML operation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "concurrent DML operation" Watch "concurrent DML operation" New topic

concurrent DML operation

kang chen

Joined: Apr 15, 2004
Posts: 4
Hi all,
I am building web application by using Oracle data base.
Because different uders will manipulate the same data record at the same time.
Could someone please help me for the following questions:
1. How can I handel the concurrently DML (insert, update, delete) opertions on same data record by different users? Can I use synchronied method in update, insert, and delete opertionns? Or other better method ??
2. When user 1 select data from table , user 2 update or delete the date in the same table concurrently.
Do I need to set transaction isolation level to TRANSACTION_READ_COMMITED or refreshRow() to get the updated data?
thanks all.
I agree. Here's the link:
subject: concurrent DML operation
It's not a secret anymore!