How can I determine why JPA/eclipselink/J2EE is issuing a ROLLBACK to the DB?

I am chasing a problem where I see SQL statements run in my database log in a transaction, then see that transaction rolledback.

This happens on both Oracle and Postgres, but only on some installations. The application itself is a pretty standard J2EE application using JPA and Eclipselink.

I am not seeing any exceptions, nor is the code explicitly giving up and rolling back.

The best I have been able to do so far is find this log statement:

    [#|2011-09-26T11:30:56.052-0700|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/opt/glassfish/domains/domain1/applications/j2ee-apps/myapp/myapp-ejb_jar/_myapp-ejbPU.transaction|_ThreadID=18;_ThreadName=httpSSLWorkerThread-8888-2;ClassName=null;MethodName=null;_RequestID=e78196
09-bf2e-4026-8cbb-87fdd047c5eb;|begin unit of work flush|#]

It occurs at the exact same time as the ROLLBACK in the postgres log:

appuser @ dbname: 102012/7/67486 2011-09-26 18:30:56.052 UTC - LOG:  execute S_3: ROLLBACK

Note that the DB is on UTC while the application is on Pacific.

The relevant code is being called using a webservice with @TransactionAttribut开发者_如何转开发e(TransactionAttributeType.SUPPORTS)

I am working with both logging levels and the debugger to see if I can find an exception being thrown and swallowed that might cause this.

How can I find out what code is causing the rollback?

You can enable logging on finest with EclipseLink to debug the issue. Any exception that occurred within EclipseLink will be logged.

See, http://wiki.eclipse.org/EclipseLink/Examples/JPA/Logging

Also ensure you are not throwing an error to cause your SessionBean to rollback.