Forgot to add, the trigger does work when I manually update the row via sqlplus
Sorry another update. This works fine in JBoss 3.2.3 but not in JBoss 3.2.5
Also does anyone know how I can edit my posts, as I dont want to keep posting replies for updates or corrections!
I think the reason why your example works fine in 3.2.3 is that in that version of JBoss the ejbstore of updated entityE EJB's is called in the middel of the transaction, while in newer versions (3.2.5) this is done only once at the end of the transaction