ROW locking.

[Ahmad Sakhi]

Hello everyone,

I have a parent--child table (AUTHOR--BOOK).
My application (J2EE) will list the authors in a table. The user can select a given author and it lists all the books for that particular author (by passing author ID (PK) to BOOK table.
Then the user can add (or update) a given record in BOOK table.

I am planning to use locking mechanism so no two users can update same record in BOOK table at the same time.

In my scenario, what type of locking is ideal? should I do an exclusive lock or shared? Any thing I need to consider when dealing with row locking?

Thanks.