| From: | kenchen077(at)yahoo(dot)com (kenchen077) |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | How do handle concurrent DML operations |
| Date: | 2004-04-15 19:23:37 |
| Message-ID: | e26660c1.0404151123.72e0ca5f@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Robinson | 2004-04-16 18:26:47 | Performance analysis of server-parsed PreparedStatements ... |
| Previous Message | Oliver Jowett | 2004-04-15 13:44:07 | Re: Under what circumstances does PreparedStatement use stored |