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 concurrent DML operation 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 "concurrent DML operation" Watch "concurrent DML operation" New topic
Author

concurrent DML operation

kang chen
Greenhorn

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: http://aspose.com/file-tools
 
subject: concurrent DML operation