Re: XA transactions and autocommit

On Sat, 7 Oct 2006, Allan Saddi wrote:

> I've been playing around with JTA using Apache Geronimo and the
> postgresql-8.1-407.jdbc3.jar driver. I've noticed a minor problem. The
> driver's XA code disables autocommit and assumes it will remain so
> indefinitely. tranql-connection (used by Geronimo for pooling) enables
> autocommit whenever the connection is returned to the pool. (Specifically in
> its ManagedXAConnection.cleanup method.) According to the J2EE Connector
> spec, this is apparently the correct thing to do.
>
> I've made a minor patch against 407 that does just this. XAResource.start
> disables autocommit, and autocommit is then re-enabled at the appropriate
> place within the prepare, commit, and rollback methods.
>

Patch applied, thanks.

Kris Jurka