How do handle concurrent DML operations - Mailing list pgsql-jdbc

From kenchen077@yahoo.com (kenchen077)
Subject How do handle concurrent DML operations
Date
Msg-id e26660c1.0404151123.72e0ca5f@posting.google.com
Whole thread Raw
Responses Re: How do handle concurrent DML operations  (Dave Cramer <pg@fastcrypt.com>)
List 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.

pgsql-jdbc by date:

Previous
From: ed@ednevitible.co.uk
Date:
Subject: Postgre not able to connect
Next
From: "Michael Nonemacher"
Date:
Subject: Re: Under what circumstances does PreparedStatement use stored