aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
Similar Threads
not sure which methods must be synchronized
[URLyBird] Synchronization issues and null terminated fields problems
My lock unlock mechanism
Concurrency Issue
data locking; competing actions