How do handle concurrent DML operations

Поиск
Список
Период
Сортировка
От kenchen077@yahoo.com (kenchen077)
Тема How do handle concurrent DML operations
Дата
Msg-id e26660c1.0404151123.72e0ca5f@posting.google.com
обсуждение исходный текст
Ответы Re: How do handle concurrent DML operations
Список 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 по дате отправления:

Предыдущее
От: ed@ednevitible.co.uk
Дата:
Сообщение: Postgre not able to connect
Следующее
От: "Michael Nonemacher"
Дата:
Сообщение: Re: Under what circumstances does PreparedStatement use stored