Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql and db2 as the data bases using XA JDBC running java programs in EJB

postgresql and db2 as the data bases using XA JDBC running java programs in EJB

From
"Darr, Terry L"
Date:

Hello,

 

Has anyone run into the below  error – any suggestions would be greatly appreciated.

 

 

[7/2/12 17:19:32:120 EDT] 00000045 RegisteredRes E   WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.

[7/2/12 17:19:32:121 EDT] 00000045 RegisteredRes E   WTRN0086I: XAException encountered during prepare phase for transaction 00000138498FD22700000338000000407BBA9FD64ACC5F7720B62C6F0C558F0C0DF6EF6100000138498FD22700000338000000407BBA9FD64ACC5F7720B62C6F0C558F0C0DF6EF6100000001. Local resources follow.

[7/2/12 17:19:32:121 EDT] 00000045 JTAResourceBa I   WTRN0089I: LocalTransactionWrapper@:55cf55cf  localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@55e655e6  enlisted:trueHas Tran Rolled Back = false  registeredForSynctruemcWrapper.hashcode()1430934858: Vote: none.

[7/2/12 17:19:32:121 EDT] 00000045 JTAResourceBa I   WTRN0089I: XATransactionWrapper@ 4ce84ce8  XAResource: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@4ce44ce4  enlisted: trueHas Tran Rolled Back = false  mcWrapper.hashCode()1281576035: Vote: commit.

[7/2/12 17:19:32:122 EDT] 00000045 JTAResourceBa I   WTRN0089I: XATransactionWrapper@ 70087008  XAResource: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@701f701f  enlisted: trueHas Tran Rolled Back = false  mcWrapper.hashCode()1647993402: Vote: commit.

[7/2/12 17:19:32:122 EDT] 00000045 JTAResourceBa I   WTRN0089I: [com.ibm.ws.sib.ra.inbound.impl.SibRaRecoverableSiXaResource@1ff71ff7 <siXaResource=com.ibm.ws.sib.msgstore.transactions.MSDelegatingXAResource@1fff1fff> <meName=Terry-DarrNode03.server1-ShortBus> <meUuid=24622C8E8018E517> <busName=ShortBus> <xaRecoveryAlias=null> <userName=null> <password=null> <recoveryToken=4> <useServerSubject=false> <providerEndpoints=null>]: Vote: commit.

 

Terry Darr |  Senior Developer, Healthcare Technologies| NTT DATA, Inc. |  w. +1.904.279.2724  |  VoIP. 8.226.2724  |   |  terry.darr@nttdata.com

 


______________________________________________________________________
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding

Re: postgresql and db2 as the data bases using XA JDBC running java programs in EJB

From
Craig Ringer
Date:
On 07/04/2012 03:01 AM, Darr, Terry L wrote:

Hello,

 

Has anyone run into the below  error – any suggestions would be greatly appreciated.

That seems to be a random chunk of log output from your app. Please follow up with an appropriate level of detail.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

At minimum a description of your setup, the circumstances, the versions of the software involved, the PostgreSQL log file contents, etc would be required.

--
Craig Ringer

Re: postgresql and db2 as the data bases using XA JDBC running java programs in EJB

From
Simon Riggs
Date:
On 3 July 2012 20:01, Darr, Terry L <Terry.Darr@nttdata.com> wrote:

> [7/2/12 17:19:32:120 EDT] 00000045 RegisteredRes E   WTRN0063E: An illegal
> attempt to commit a one phase capable resource with existing two phase
> capable resources has occurred.

You issued COMMIT rather than COMMIT PREPARED, somehow.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services