Hello. SELECT_FOR_UPDATE_MVCC was useless after other changes in H2.
The exception that you got describes the situation pretty clear: you can't use FOR UPDATE clause when you use aggregates (or distinct). Grouped queries don't return the original rows, FOR UPDATE is disallowed in such queries by many databases. You need to perform a regular query that selects and returns all rows that you want to lock. https://h2database.com/html/commands.html#select BTW, do you really need to lock all rows with specific report_id? -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
