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