Table locked using multiple session

Database
Enthusiast

Table locked using multiple session

Hi

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.

Thanks