This has been fixed in a newer version of H2.
On 2014-09-12 04:39 AM, Gili wrote:
Hi,
I am getting "Commit or rollback is not allowed within a trigger" under H2
1.3.176 but I am not actually rolling
anything back. As far as I understand the following sequence of events occurs:
1. Java code invokes: delete from PARTICIPANT where PARTICIPANT.LAST_SEEN_TIME
< ?
2. A "after delete" trigger runs, invoking: delete from PERMISSION where ID = ?
(at CascadeToPermission.java:80)
3. This triggers a rollback (looking at the H2 source code, caused by a
deadlock)
4. H2 throws the following exception:
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
