How to set up Oracle XA? [message #217796] |
Mon, 05 February 2007 10:05 |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
Hello,
I have installed oracle 9.2.0.7 database on windows. We want to have XA support and I have granted the select permission on dba_pending_transactions to all schemas...still we keep getting XA related errors...jvm is installed properly ..what could be the problem? how to go about enabling xa support in oracle? the error I get is:
Quote: |
XAException occurred. Error code is: XAER_INVAL (-5). Exception is: <null>
[2/5/07 18:30:48:750 IST] 00000030 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/OracleDS, within transaction ID
|
With thanks,
Nirav
|
|
|