weblogic XA驱动的一个报错

àì夳堔傛蜴生んèń 2022-08-05 08:29 542阅读 0赞

\[ERROR\] 2015-08-27 11:49:23:206 org.hibernate.engine.jdbc.spi.SqlExceptionHelper (SqlExceptionHelper.java:144) -

Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER\_NOTA start() failed on resource 'xxx\_data\_source': XAER\_NOTA : The XID is not valid  oracle.jdbc.xa.OracleXAException

**解决方法：**找到**设置XA事务处理超时**选项打钩，**设置XA事务处理超时**设置为0，点击保存即可。

<table> 
 <tbody> 
  <tr> 
   <td align="left"><span style="text-align:right; padding:0px 6px 0px 0px; font-size:14px; font-weight:bold">Unexpected Exception while Enlisting XAConnection java.sql.SQLException:... 'The XID is not valid' (文档 ID 1389691.1)</span></td> 
   <td align="right"><a title="转到底部" href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=16m5qoluhy_9&amp;_afrLoop=253119820197844#" style="white-space:nowrap; color:blue; font-size:11px" rel="nofollow"><img title="转到底部" alt="转到底部" src="https://support.oracle.com/epmos/ui/images/quicklink_smlarrowdown_enabled.gif" style="border-bottom:medium none; border-left:medium none; display:inline; vertical-align:middle; border-top:medium none; border-right:medium none"><span style="color:rgb(0,50,134); margin-left:3px; text-decoration:none">转到底部</span></a></td> 
   <td><img alt="" src="/images/20220731/b91bbc036dd749288ea578e6e017370a.png" width="20" height="10"></td> 
  </tr> 
 </tbody> 
</table>

--------------------

![t.gif][]

<table style="table-layout:fixed; overflow:hidden"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top; overflow:hidden"> 
    <div style="overflow:auto"> 
     <div> 
      <span style="font-size:12px"></span> 
      <p style="margin-top:0px; margin-bottom:0px"><strong>In this Document</strong><br> </p> 
      <table> 
       <tbody> 
        <tr> 
         <td></td> 
         <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=16m5qoluhy_9&amp;_afrLoop=253119820197844#SYMPTOM" style="color:blue" rel="nofollow">Symptoms</a></td> 
        </tr> 
       </tbody> 
      </table> 
      <table> 
       <tbody> 
        <tr> 
         <td>&nbsp;</td> 
         <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=16m5qoluhy_9&amp;_afrLoop=253119820197844#CAUSE" style="color:blue" rel="nofollow">Cause</a></td> 
        </tr> 
       </tbody> 
      </table> 
      <table> 
       <tbody> 
        <tr> 
         <td>&nbsp;</td> 
         <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=16m5qoluhy_9&amp;_afrLoop=253119820197844#FIX" style="color:blue" rel="nofollow">Solution</a></td> 
        </tr> 
       </tbody> 
      </table> 
      <table> 
       <tbody> 
        <tr> 
         <td>&nbsp;</td> 
         <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=16m5qoluhy_9&amp;_afrLoop=253119820197844#REF" style="color:blue" rel="nofollow">References</a></td> 
        </tr> 
       </tbody> 
      </table> 
      <hr> 
      <p style="margin-top:0px; margin-bottom:0px"><br> </p> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> APPLIES TO:</h2> Oracle SOA Suite - Version 11.1.1.3.0 and later 
      <br> Information in this document applies to any platform. 
      <br> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>SYMPTOMS</h2> 
      <p style="margin-top:0px; margin-bottom:0px"><span title="SR 3-5066512621: Weblogic Datasource errors appearing in SOA server log" style="font-family:monospace; color:rgb(199,0,0); font-weight:bold">WebLogic Datasource errors appearing in SOA server log:</span><br> <br> java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SOADataSource_base_domain': XAER_NOTA : The XID is not valid<br> <br> <br> ERROR<br> -----------------------</p> 
      <div style="border-bottom:rgb(196,209,230) 1px solid; border-left:rgb(196,209,230) 1px solid; padding-bottom:0.5em; background-color:rgb(224,234,241); margin:5px 0px 0px; padding-left:0.5em; padding-right:0.5em; font-family:'Courier New',Courier,monospace; font-size:12px; overflow:auto; border-top:rgb(196,209,230) 1px solid; border-right:rgb(196,209,230) 1px solid; padding-top:0.5em">
        2011-12-16T00:01:33.791+10:30] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-4.thread-13] [userId: &lt;anonymous&gt;] [ecid: 0000JH1ufkSD4iP5Mf9Die1EuSQh0001xR,0:7:100000066] [APP: soa-infra] [dcid: 5f7dda500ef01573:-39ff5479:1344130a57d:-7ffc-0000000000000011] &lt;DispatchHelper::handleMessage&gt; failed to handle message[[ 
       <br> javax.ejb.TransactionRolledbackLocalException: Error committing transaction:; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException 
       <br> Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SOADataSource_base_domain': XAER_NOTA : The XID is not valid 
       <br> at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1532) 
       <br> Error Code: 0 
       <br> Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SOADataSource_base_domain': XAER_NOTA : The XID is not valid 
       <br> at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1532) 
       <br> Error Code: 0 
       <br> Caused by: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SOADataSource_base_domain': XAER_NOTA : The XID is not valid 
       <br> at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1532) 
       <br> javax.ejb.TransactionRolledbackLocalException: Error committing transaction:; nested exception is: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException 
       <br> Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA sta 
      </div> 
      <p style="margin-top:0px; margin-bottom:0px">&nbsp;</p> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>CAUSE</h2> 
      <p style="margin-top:0px; margin-bottom:0px">According to XA protocol it requires that all the SQL statements for one and the same transaction branch be issued between an xa_start() and an xa_end() call.<br> In case of a distributed transaction, every individual database represents one XAResource that will have one transaction branch in one distributed transaction. Now the WebLogic Server transaction manager considers every JDBC DataSource as a separate XAResource, which means it cannot evaluate if different connection pools or data sources point to the same database.<br> <br> This error can be seen when the transaction has timed out but the exception is not caught by the application.</p> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>SOLUTION</h2> 
      <p style="margin-top:0px; margin-bottom:0px">The solution is for the JDBC Connection Pools to set the XASetTransactionTimeout to true and XATransactionTimeout to zero (when this parameter is set to zero, the XAResource Session Timeout will be set to the global transaction timeout).</p> 
      <p style="margin-top:0px; margin-bottom:0px"><strong><span style="color:#ff0000">a. Log into WLS Administration Console<br> b. Click on Services -&gt; Data Sources and then click on data source in question<br> c. Click on Transaction Tab<br> d. Click on check box next to "Set XA Transaction Timeout"<br> e. Make sure that "XA Transaction Timeout" has a value of 0<br> f. Save the configuration.<br> g. Bounce SOA</span></strong></p> 
      <p style="margin-top:0px; margin-bottom:0px"><br> A general rule to follow is to make sure that WebLogic Server JTA timeout (either global, specific to an EJB or for individual&nbsp;</p> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

[t.gif]: /images/20220731/b91bbc036dd749288ea578e6e017370a.png