Home » SQL & PL/SQL » SQL & PL/SQL » Issues Oracle Data Source (Windows XP)
Issues Oracle Data Source [message #437095] Thu, 31 December 2009 01:21 Go to next message
satyam.sumit
Messages: 7
Registered: October 2009
Location: INDIA
Junior Member
Hi All,

I configured oracle datasource in websphere application server 7.I also configured DB2 datasource in same server.(both are connection pool datasource)

Initially i am getting oracle connection from Oracle datasource in between i will get DB2 connection from DB2 Datasource while doing so i am getting the fallowing exception...

: [12/23/09 15:30:48:336 IST] 00000022 LocalTransact E J2CA0030E: Method enlist caught com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources
at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResources.java:863)
at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java:1688)
at com.ibm.ws.tx.jta.TranManagerSet.enlistOnePhase(TranManagerSet.java:578)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:587)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:2003)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2531)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:708)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:2589)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:2545)
at com.adp.pvs.ejb.PVSSessionBean.logUserEntryInDB(PVSSessionBean.java:1111)
at com.adp.pvs.ejb.PVSSessionBean.buildVoteBallotModel(PVSSessionBean.java:226)
at com.adp.pvs.ejb.EJSLocalStatelessPVSSession_6a7ec84f.buildVoteBallotModel(EJSLocalStatelessPVSSession_6a7ec84f.java:178)
at com.adp.pvsweb.helper.AgendaHelper.getVoteBallotModel(AgendaHelper.java:69)
at com.adp.pvsweb.action.AgendaAction.loadAgendaPage(AgendaAction.java:191)
at com.adp.pvsweb.action.AgendaAction.loadAgendaVote(AgendaAction.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.adp.core.action.Dispatcher.execute(Dispatcher.java:182)
at com.adp.pvsweb.action.PVSAction.execute(PVSAction.java:62)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1449)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3610)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:274)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:926)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
while trying to enlist resources from DataSource jdbc/uknomdb2 with the Transaction Manager for the current transaction, and threw a Exception.
[12/23/09 15:30:48:414 IST] 00000022 FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on C:\Program Files\IBM\SDP\runtimes\base_v7\profiles\was70profile1\logs\ffdc\server1_1d461d46_09.12.23_15.30.48.38319274.txt com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary 324
[12/23/09 15:30:48:430 IST] 00000022 FfdcProvider I


Please advice


Re: Issues Oracle Data Source [message #437112 is a reply to message #437095] Thu, 31 December 2009 02:13 Go to previous message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Same problem with different title and from different users ./fa/1581/0/

regards,
Delna
Previous Topic: Need for Materialized Views
Next Topic: column to rows
Goto Forum:
  


Current Time: Sun Dec 11 02:18:30 CST 2016

Total time taken to generate the page: 0.07963 seconds