Table locked using multiple session


Table locked using multiple session


I am trying the following scenario,

Two database sessions using jdbc. Trying to select the table in first database session, and comparing the retrieved values with a set of other info. Simulatneouly trying to apply the data to the same table in second session. Both the sessions are active at a time.

Table gets blocked when i run my program. (May be because select has a table level lock? )

What locking mechanism can i use so that i am able to select from table while adding data to it.