> http://www.h2database.com/html/grammar.html?highlight=LOCK_MODE&searc...
>
> It sounds like you want dirty reads which is what you get with 'SET LOCK_MODE 
> 0'. You can also set it in your connection URL:
>
> "jdbc:h2:mem:test;LOCK_MODE=0"

"The value 3 means table level locking, but read locks are released
immediately (default; also known as READ_COMMITTED)."

Because read uncommitted is not really an option here, I suppose I
have to live with table level locking. Is there any plan for row-level
locking in the future?

Thanks,
   Istvan

--

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