2PC datasource problem

[Suresh]

Hi,

 

We are using WSAD 4.1 IE. Our test database(DB2 UDB 7.1.1) is on OS / 390. So we have DB2 7.1 client on the system where we have WSAD . We are trying to connect to Host database using DB2Connect as gateway inbetween.

 

Our application requirement is to transfer data from one database to another database.

i.e from one datasource to another datasource.

 

So we are using 2 PC datasource (DB2XADataSource). But it is not working for us.

For some methods which has only select statements we are getting WorkRolledBackException.

And some times we are getting StaleConnectionException.

 

Pls check the exception below:

 

[7/23/03 14:07:45:293 EDT] 5a85e622 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState S1000, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E  Invalid statement handle or statement is closed. SQLSTATE=S1000

        at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throwClosedError(SQLExceptionGenerator.java:635)
        at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:310)
        at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:207)
        at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:458)
        at COM.ibm.db2.jdbc.app.DB2Statement.<init>(DB2Statement.java:362)
        at COM.ibm.db2.jdbc.app.DB2PreparedStatement.<init>(DB2PreparedStatement.java:557)
        at COM.ibm.db2.jdbc.app.DB2PreparedStatement.<init>(DB2PreparedStatement.java:676)
        at COM.ibm.db2.jdbc.app.DB2Connection.prepareStatement(DB2Connection.java:593)
        at com.ibm.ejs.cm.cache.StatementCache.reallyPrepareStatement(StatementCache.java:221)
        at com.ibm.ejs.cm.cache.StatementCache.prepareStatement(StatementCache.java:102)
        at com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java:2025)
        at com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java:2058)
        at com.ibm.ejs.cm.proxy.ConnectionProxy.prepareStatement(ConnectionProxy.java:514)
        at com.lm.wspr.dao.datatransfer.DataTransferDAOImpl.fTransferWUXUNITT(DataTransferDAOImpl.java:509)
        at com.lm.wspr.dao.datatransfer.DataTransferDAOImpl.fProcessTransfer(DataTransferDAOImpl.java:132)
        at com.lm.wspr.ejb.datatransfer.DataTransferBean.fProcessTransfer(DataTransferBean.java:113)
        at com.lm.wspr.ejb.datatransfer.EJSRemoteStatelessDataTransfer.fProcessTransfer(EJSRemoteStatelessDataTransfer.java:81)

        at com.lm.wspr.ejb.datatransfer._DataTransfer_Stub.fProcessTransfer(_DataTransfer_Stub.java:266)
        at com.lm.wspr.web.datatransfer.DataTransferDelegate.fProcessTransfer(DataTransferDelegate.java:92)
        at com.lm.wspr.web.struts.datatransfer.DataTransferAction.perform(DataTransferAction.java:158)
        at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
        at com.lm.wspr.web.struts.WSPRDTActionServlet.process(WSPRDTActionServlet.java:83)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
        at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
        at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
        at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
        at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:523)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:282)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:112)
        at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:91)
        at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:184)
        at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
        at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
        at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
        at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
        at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

[7/23/03 14:07:45:393 EDT] 5a85e622 SystemOut     U 14:07:45,393 [Servlet.Engine.Transports:9] ERROR com.lm.wspr.dao.datatransfer.DataTransferDAOImpl - fTransferWUXUNITT(): SQLException: com.ibm.websphere.ce.cm.StaleConnectionException: Connection is closed

 But the same thing is working when we tried to transer the databse from one database to another database using 2PC.

Note: But in this case environment is different. We have DB2 7.2 UDB on windows and DB2 7.2 client on th machine where WSAD is installed. (this is our development environment).

Has it got anything to do with DB2 Versions and JDBC drivers?

Can anyboby pls throw some light and help us in solving this issue?

Thanks

Suresh.P