Atomikos Forum

Hi

We are using Postgres 8.3.3 and Atomikos Transactions Essentials 3.3.2 and with the latest JDBC driver (postgresql-8.3-603.jdbc).

I get the following error:
08-08-15 12:50:24,906 [main] resume for XID eiss_tm_0000100018eiss_tm_1 raised -3: the XA resource detected an internal error
org.postgresql.xa.PGXAException: Transaction interleaving not implemented

I check the JDBC driver's web page and they say they do not support transaction interleaving.

Is there any way to use Atomikos and Postgres successfully to perform a JTA/XA commit or rollback across two databases with this limitation? Do I need to find another JTA implementation?

Thanks very much
Aisling

No-one using Postgres successfully for JTA/XA?

See http://www.atomikos.com/Documentation/KnownProblems#Postgresql_Limited_XA_Support

Maybe you can convince the Postgres team that XA is valuable enough to make it better ;-)


Cheers