Thanks for your response, but I am asking about the level of locking. If an entity bean instance holds a state of a particular record in the table, the whole record will be locked or just a field of a record being locked? For database, normally the whole record will be locked. For EJB, if the whole entity bean instance is being locked, others clients who want to access the bean state will have to wait.
Originally posted by Roger Chung-Wee:
This is safe because concurrency problems will be prevented by the DB row locking. This also means that it is the transaction isolation level that dictates the level of concurrency protection, not the EJB container.
I get the feeling that the default isolation level for many containers is TRANSACTION_READ_COMMITTED, can anyone confirm this.