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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
