2007-09-26 08:14:31,033 INFO [STDOUT] 08:14:31,030 ERROR
[SimpleWorkflowManager] An exception occurred
org.ofbiz.core.entity.GenericTransactionException: Error occurred
while starting transaction. (Cannot change transaction isolation level in the middle of a transaction.)
caused by: org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction.
After much pain it appears that the datasource configuration had the following:
Which for some reason seems to be being run within the same transaction as the client code - "fixing" the isolation level.
I tried to raise a bug at jira.jboss.org or comment on this one (that was the only one I could find that seemed to be similar) but after a long and drawn out fight with the jboss.com registration system was unable to log in to it.
Status: has not been reproduced and tested internally but has fixed problem for two customers.
JIRA 3.8.1 Enterprise: compiled as an ear with plugins for SVN and SVN-commit
JBoss 4.0.5 GA installed with JEMS for EJB3
References: this forum post - this JBoss bug
Support Ref: JSP-14364