'Lock Table with exclusive in H2 database

I am having trouble to convert Oracle syntax to H2 syntax:

For example (Oracle):

    LOCK TABLE CAR_CHIP_ID_LOCK IN EXCLUSIVE MODE

In H2 it results in a (syntax error)

How do I change the oracle grammar to h2? I have tried Lock_mode but it doesnt work and MVCC is true by default v1.4+

sqloracleh2portingtable-locking


Solution 1:[1]

What seems to work both in oracle and h2 was

select * from CAR_CHIP_ID_LOCK for update;

See also How to lock whole entity (table) in JPA entity manager

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 serv-inc

Related Questions