Hi,

I had a problem.
Lock_mode 1 or Lock_mode 2.

Two or more session on one database, test1 for example.

session_id 1:
select * from t1
session_id 2:
select * from t1

select * from information_schema.locks
then there are two read locks.

then I close session_id 2 without commit.
select * from information_schema.locks
then also there are two read locks,session_id 1 and session_id 2.
*So I can't do anything on table t1 anymore on lock_mode 1 or 2.*


Could you please tell me
How to solve the problem?

very emergency,thanks

Best Regards,
Jason.qi

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to