Home » SQL & PL/SQL » SQL & PL/SQL » Error multiple 1PC XAResources (Oracle 10.1)
Error multiple 1PC XAResources [message #441710] Tue, 02 February 2010 17:40 Go to next message
Messages: 1
Registered: February 2010
Junior Member
I am getting the below error while connecting to the Oracle system.

Any idea why this occurs?

[2/2/10 15:59:19:608 CST] 00000073 RegisteredRes E WTRN0062E: An illegal attempt to use multiple resources that have only one-phase capability has occurred within a global transaction.

[2/2/10 15:59:19:667 CST] 00000073 LocalTransact E J2CA0030E: Method enlist caught com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources

at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java(Compiled Code))
Re: Error multiple 1PC XAResources [message #441712 is a reply to message #441710] Tue, 02 February 2010 18:09 Go to previous messageGo to next message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
>Any idea why this occurs?

What you posted shows no actual Oracle error code or message.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Without additional details as specified in URL above, no solution can be provided.
Re: Error multiple 1PC XAResources [message #441879 is a reply to message #441710] Wed, 03 February 2010 10:38 Go to previous message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
There are many references on the web for this error, do a google for the error numbers.



Previous Topic: Selecting 0 instead of negative value
Next Topic: Database User Or Data User
Goto Forum:

Current Time: Wed Aug 16 21:04:36 CDT 2017

Total time taken to generate the page: 0.15080 seconds