Postgres Pro
Downloads
Home   >   mailing lists

XA transaction -- Linux v Windows - Mailing list pgsql-jdbc

From Dennis Gesker
Subject XA transaction -- Linux v Windows
Date
Msg-id CADyGkNS2hm8eV_1YqcRYGp6u5nTLMiYWGdiswdHKf4i8L6BEPQ@mail.gmail.com
Whole thread Raw
Responses Re: XA transaction -- Linux v Windows  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
Tree view
Hello List:

I have an application running in Glassfish using the 9.3-1102 JDBC 41 driver against pgsql 9.3. The install on Linux (Ubuntu) is installed using the default configuration. Everything runs smoothly.

I installed pgsql 9.3 on my Windows 8.1 workstation (again default install) but I get errors similar to:

Warning:   JTS5031: Exception [java.lang.RuntimeException: org.postgresql.xa.PGXAException: Error preparing transaction] on Resource [prepare] operation.
Warning:   JTS5068: Unexpected error occurred in rollback
org.postgresql.xa.PGXAException: Error rolling back prepared transaction
    at org.postgresql.xa.PGXAConnection.rollback(PGXAConnection.java:418)
[snip]
Caused by: org.postgresql.util.PSQLException: ERROR: prepared transaction with identifier "4871251_BgAAAEfR84hkcmdXb3Jrc3RhdGlvbixzZXJ2ZXIsUDEwMA==_ZHJnV29ya3N0YXRpb24sc2VydmVyLFAxMDAsAQ==" does not exist
[snip]

Are there any configuration changes required on the Windows version or with the driver to allow XA transactions?

Thanks,
Dennis

pgsql-jdbc by date:

Previous
From: CG
Date:
Subject: Re: Upgrade to Scientific Linux 6.5 x86_64 breaks query
Next
From: John R Pierce
Date:
Subject: Re: XA transaction -- Linux v Windows