Discussions

EJB programming & troubleshooting: Problem with XA dataSource in websphere 5.1 Application Server

  1. Hi,
         we are using Oracle XA datasourse in my session bean whith the transaction attribute as "Required" but we are getting some problem whcih i am not able to trace out. I am using oracle 8.1.6 database and ojdbc14.jar drivers for 9.2.0. please find the stack trace:

    8/9/05 10:09:01:826 IST] 3f42eb4c SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    [8/9/05 10:09:01:826 IST] 3f42eb4c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    [8/9/05 10:09:53:185 IST] 62c3ab4f SystemErr R java.sql.SQLException: DSRA9002E: ResourceException with error code null: javax.resource.ResourceException: enlist: caught Exception
    at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:703)
    at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    at org.apache.jsp._simple1._jspService(_simple1.java:82)
    at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    -------- chained exception -------
    javax.transaction.SystemException: Failed to start the transaction association.
    at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1917)
    at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
    at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
    at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    at org.apache.jsp._simple1._jspService(_simple1.java:82)
    at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1200)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:343)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at org.apache.jsp._simple1._jspService(_simple1.java:82)
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    [8/9/05 10:09:53:201 IST] 62c3ab4f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))


    [8/9/05 10:09:52:560 IST] 62c3ab4f WebGroup I SRVE0180I: [pfweb.war] [/pf] [Servlet.LOG]: /simple1.jsp: init
    [8/9/05 10:09:52:576 IST] 62c3ab4f SystemOut O AKC class com.polaris.hsbc.pf._PFChargesCalculator_Stub
       class com.polaris.hsbc.pf._PFChargesCalculatorHome_Stub
    [8/9/05 10:09:52:966 IST] 62c3ab4f SystemOut O Ashok Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@25c6eb7d
    [8/9/05 10:09:52:966 IST] 62c3ab4f WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
    [8/9/05 10:09:52:982 IST] 62c3ab4f WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_PROTO. Exception is: <null>
    [8/9/05 10:09:53:060 IST] 62c3ab4f XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource PayChgDataSource, within transaction ID {XID: formatId(57415344), gtrid_length(39), bqual_length(28), data(000000000000001e00000001eed49a9149b25293395971baf40dff22e4e7471a73657276657231eed49a9149b25293395971baf40dff22e4e7471a000000017dabdf25)}: javax.transaction.xa.XAException
    at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:250)
    at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927)
    at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267)
    at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164)
    at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:389)
    at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903)
    at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
    at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
    at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    at org.apache.jsp._simple1._jspService(_simple1.java:82)
    at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    .
    [8/9/05 10:09:53:138 IST] 62c3ab4f RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_PROTO. The exception stack trace follows: javax.transaction.xa.XAException
    at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:250)
    at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927)
    at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267)
    at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164)
    at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:389)
    at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903)
    at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
    at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
    at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    at org.apache.jsp._simple1._jspService(_simple1.java:82)
    at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

    [8/9/05 10:09:53:154 IST] 62c3ab4f XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: Failed to start the transaction association.
    at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1917)
    at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
    at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
    at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:719)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:698)
    at com.polaris.hsbc.pf.PFChargesCalculatorBean.postChargesPF(PFChargesCalculatorBean.java:146)
    at com.polaris.hsbc.pf.EJSRemoteStatelessPFChargesCalculator_ea9a2216.postChargesPF(Unknown Source)
    at com.polaris.hsbc.pf._PFChargesCalculator_Stub.postChargesPF(_PFChargesCalculator_Stub.java:257)
    at org.apache.jsp._simple1._jspService(_simple1.java:82)
    at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java(Compiled Code))
    at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
    at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
    at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
    at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
    at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
     while trying to enlist resources from datasource PayChgDataSource with the Transaction Manager for the current transaction, and threw a ResourceException.
    [8/9/05 10:09:53:201 IST] 62c3ab4f ConnectionFac I J2CA0122I: Resource reference PayChgDataSource could not be located, so default values of the following are used: [Resource-ref settings]

    res-auth: 1 (APPLICATION)
    res-isolation-level: 0 (TRANSACTION_NONE)
    res-sharing-scope: true (SHAREABLE)
    res-resolution-control: 999 (undefined)
    [Other attributes]

    isCMP1_x: false (not CMP1.x)
    isJMS: false (not JMS)
  2. We had several problems on a project with a similar setup.

    First, does your database support XA transactions? Oracle requires JServer (Java support) to be installed and running. Don't ask me why! We had some problems where JServer had to be patched and the patch didn't bite as well, so that is one alternative.

    Another possible cause is that you have old transactions that have not been committed in WebSphere. When the system starts it tries to resolve them and that may fail. You can get rid of them by deleting WebSpheres transaction logs when the system has been stopped. Keep the old ones! This typically happens in the development environment if it is killed. Not quite as likely given the trace.

    By the way, the first warning may indicate that the data source has not been referenced from the web.xml document, as the defaults are missing. At least that was what we were told when we had similar warnings for topics and queues. It shouldn't be critical, but warnings are never good.
  3. Thanks Erik,
    Our problem is solved.We changed our database now we are using Oracle9i and we started the JServer using initjvm.sql and then we have to give the grants to the users who are going to use XA using SQL command.
    that is
    GRANT JAVAUSERPRIV TO SCOTT

    now it is working fine.

    Thanks,
    Ashok.