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.