Does the H2 Database support pessimistic locking?
If so, how does its use interact with H2’s MVCC implementation?
I'm not looking for advice on whether or not to use pessimistic locking. I have a specific need to emulate the behavior of another database that defaults to row-level pessimistic locking. I need to be able to test if a row is locked, and if not locked, lock it out from writes by any other database connection.