Forums Register Login

question about multi user work on record

+Pie Number of slices to send: Send
I have customer table. In that table, I want to update some field which are null or invalid.
for ex. in Customer table, I have 1000 record. In GUI, I have next, previous and update button.
If more than one user will work to update that record, How it will work.

Is it possible, if first user open 1st record then 2nd user open 2nd record and then again 1st user open 3rd record. means same record don't open with different user.

How it works?

If I write simple select and simple update then I know, update statement handling locking system. but in this scinerio more then one user can open same record with simple select.

Please, any body can guide me.
Thanks,
+Pie Number of slices to send: Send
There are two locking control mechanisms, called optimistic and pessimistic locking.
http://en.wikipedia.org/wiki/Concurrency_control
+Pie Number of slices to send: Send
Exactly how such a scenario plays out depends on the isolation level of the transaction. You can set various isolation levels, but only to values that are supported by your database engine (and JDBC driver).

Check out this page on using transactions for more details about the available isolation levels and how to set them.
Hot dog! An advertiser loves us THIS much:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1035 times.
Similar Threads
how to implement Concurrent access to records..Please help me URGENTLY
GUI display & booking questions
Record Locking in multi-user
Row locking using oracle database
HELP - JDBC Connection & locking
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:34:49.