On 5/8/2024 6:31 PM, Bruce Visscher wrote:
On stack overflow, Thomas Mueller
<https://stackoverflow.com/users/382763/thomas-muelle> wrote:
The Oracle lock table statement doesn't work in H2. The suggested select...for update
<https://stackoverflow.com/a/71210443/3604905> alternative doesn't accomplish the same thing. Specifically, if the
table is empty it will not prevent other processes or threads from performing queries and inserting rows into the table.
We do not ly have an equivalent of that, the only alternative we have is putting the whole db into exclusive mode
temporarily
https://h2database.com/html/commands.html#set_exclusive
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/19a5a591-f3ce-4818-ac6a-0b3ee9ee464a%40gmail.com.
