com.ibm.websphere.ce.cm.StaleConnectionException when connecting with DB2

[subbukumararaja chandrasekaran]

Hi all,

I am using the JDBC connectivity to connect with DB2 database. My application is running on WebSphere 6.0

My code was working fine earlier. But suddenly it is not establishing the connections with DB2.

I am getting the error below and inside the Connection object i am having the error message as "com.ibm.websphere.ce.cm.StaleConnectionException".

Could somebody help me on this issue?

[9/25/10 0:36:27:769 GMT] 00000026 SystemErr     R                                                              25 Sep 00:36:27 UtilityService processSQLException - 
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R ********************************* stack trace for original SQLException ************************** 25 Sep 00:36:27 UtilityService processSQLException - 
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R com.ibm.db2.jcc.c.SqlException: DBRM OR PACKAGE NAME DBT5.CDBLACT6.DAS23.3441775056464977 NOT FOUND IN PLAN DISTSERV. REASON 04
	at com.ibm.db2.jcc.c.tf.d(tf.java:1396)
	at com.ibm.db2.jcc.b.jb.l(jb.java:367)
	at com.ibm.db2.jcc.b.jb.a(jb.java:64)
	at com.ibm.db2.jcc.b.w.a(w.java:48)
	at com.ibm.db2.jcc.b.dc.b(dc.java:302)
	at com.ibm.db2.jcc.c.uf.cb(uf.java:1719)
	at com.ibm.db2.jcc.c.uf.d(uf.java:2319)
	at com.ibm.db2.jcc.c.uf.Y(uf.java:540)
	at com.ibm.db2.jcc.c.uf.executeUpdate(uf.java:523)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:724)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:544)
	at com.ibm.db2.jcc.sqlj.g.executeRTQuery(g.java:625)
	at sqlj.runtime.ExecutionContext$StatementFrame.executeQuery(ExecutionContext.java:1258)
	at sqlj.runtime.ExecutionContext.executeQuery(ExecutionContext.java:796)
	at com.tuc.g2.services.persistence.DataAccessService.getCurrentTimestamp(DataAccessService.sqlj:54)
	at com.tuc.g2.apps.subjectsearch.SubjectSearchUtility.search(SubjectSearchUtility.java:107)
	at com.tuc.g2.apps.subjectsearch.SubjectSearchUtility.search(SubjectSearchUtility.java:92)
	at com.tuc.g2.apps.webapps.dataviewer.services.data.dao.impl.SubjectSearchDAOImpl.getSubjectByRequestType(SubjectSearchDAOImpl.java:39)
	at com.tuc.g2.apps.webapps.dataviewer.services.data.DataViewerDataServiceImpl.getSubjectByRequestType(DataViewerDataServiceImpl.java:28)
	at com.tuc.g2.apps.webapps.dataviewer.action.FindSubjectAction.processAction(FindSubjectAction.java:154)
	at com.tuc.g2.apps.webapps.arch.action.BaseAction.execute(BaseAction.java:54)
	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:763)
	at com.tuc.g2.apps.webapps.arch.servlet.FrontController.service(FrontController.java:53)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1793)
	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:886)
	at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3226)
	at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:253)
	at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:248)
	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1971)
	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:120)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:434)
	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:373)
	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
	at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)

[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.c.tf.d(tf.java:1396)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.b.jb.l(jb.java:367)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.b.jb.a(jb.java:64)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.b.w.a(w.java:48)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.b.dc.b(dc.java:302)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.c.uf.cb(uf.java:1719)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.c.uf.d(uf.java:2319)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.c.uf.Y(uf.java:540)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.c.uf.executeUpdate(uf.java:523)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:724)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:544)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.db2.jcc.sqlj.g.executeRTQuery(g.java:625)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at sqlj.runtime.ExecutionContext$StatementFrame.executeQuery(ExecutionContext.java:1258)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at sqlj.runtime.ExecutionContext.executeQuery(ExecutionContext.java:796)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.services.persistence.DataAccessService.getCurrentTimestamp(DataAccessService.sqlj:54)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.subjectsearch.SubjectSearchUtility.search(SubjectSearchUtility.java:107)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.subjectsearch.SubjectSearchUtility.search(SubjectSearchUtility.java:92)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.webapps.dataviewer.services.data.dao.impl.SubjectSearchDAOImpl.getSubjectByRequestType(SubjectSearchDAOImpl.java:39)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.webapps.dataviewer.services.data.DataViewerDataServiceImpl.getSubjectByRequestType(DataViewerDataServiceImpl.java:28)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.webapps.dataviewer.action.FindSubjectAction.processAction(FindSubjectAction.java:154)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.webapps.arch.action.BaseAction.execute(BaseAction.java:54)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.tuc.g2.apps.webapps.arch.servlet.FrontController.service(FrontController.java:53)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1793)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:886)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3226)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:253)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:248)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1971)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:120)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:434)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:373)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R 	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R ********************************* end of SQLException stack trace       ************************** 25 Sep 00:36:27 UtilityService processSQLException - 
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R                                                              25 Sep 00:36:27 UtilityService processSQLException - 
[9/25/10 0:36:27:785 GMT] 00000026 SystemErr     R                                                              25 Sep 00:36:27 G2SystemServices logException - 
[9/25/10 0:36:28:738 GMT] 00000026 SystemErr     R class com.tuc.g2.exceptions.G2SystemException Caught - in Object: 0 in Object type: unknown: 0, - Class: com.tuc.g2.services.persistence.UtilityService, Method: processSQLException, Line Number: 98, Detail Code: -805, Message:Unable to Retrieve Error Message - - DB2 error 25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R **** Exception contains class com.ibm.db2.jcc.c.SqlException DBRM OR PACKAGE NAME DBT5.CDBLACT6.USS3.4142415256464977 NOT FOUND IN PLAN DISTSERV. REASON 04 25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R ******* DB2 Error -- SQLCA Information ********************* 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R DB2 ERROR:   -805 IN RTN:Java
SQLCODE SQLERRMC
  -805  DBT5.CDBLACT6.USS3.4142415256464977;DISTSERV;04
  SQLERRD1     SQLERRD2     SQLERRD3     SQLERRD4     SQLERRD5     SQLERRD6
x'FFFFFF9C'  x'00000000'  x'00000000'  x'FFFFFFFF'  x'00000000'  x'00000000'  
SQLERRP SQLSTATE W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 WA
DSNXEPM    51002                    
************************************************************ 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R **** Exception contains class com.ibm.db2.jcc.c.SqlException DBRM OR PACKAGE NAME DBT5.CDBLACT6.DAS23.3441775056464977 NOT FOUND IN PLAN DISTSERV. REASON 04 25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R ******* DB2 Error -- SQLCA Information ********************* 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R DB2 ERROR:   -805 IN RTN:Java
SQLCODE SQLERRMC
  -805  DBT5.CDBLACT6.DAS23.3441775056464977;DISTSERV;04
  SQLERRD1     SQLERRD2     SQLERRD3     SQLERRD4     SQLERRD5     SQLERRD6
x'FFFFFF9C'  x'00000000'  x'00000000'  x'FFFFFFFF'  x'00000000'  x'00000000'  
SQLERRP SQLSTATE W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 WA
DSNXEPM    51002                    
************************************************************ 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R **** Exception contains class com.ibm.db2.jcc.c.SqlException DBRM OR PACKAGE NAME DBT5.CDBLACT6.USS3.4142415256464977 NOT FOUND IN PLAN DISTSERV. REASON 04 25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R ******* DB2 Error -- SQLCA Information ********************* 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:753 GMT] 00000026 SystemErr     R DB2 ERROR:   -805 IN RTN:Java
SQLCODE SQLERRMC
  -805  DBT5.CDBLACT6.USS3.4142415256464977;DISTSERV;04
  SQLERRD1     SQLERRD2     SQLERRD3     SQLERRD4     SQLERRD5     SQLERRD6
x'FFFFFF9C'  x'00000000'  x'00000000'  x'FFFFFFFF'  x'00000000'  x'00000000'  
SQLERRP SQLSTATE W0 W1 W2 W3 W4 W5 W6 W7 W8 W9 WA
DSNXEPM    51002                    
************************************************************ 25 Sep 00:36:28 G2SystemServices processSQLExceptions - 
[9/25/10 0:36:28:769 GMT] 00000026 SystemErr     R                                                              25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:769 GMT] 00000026 SystemErr     R class com.tuc.g2.exceptions.G2ProcessingException Caught - in Object: 0 in Object type: unknown: 0, - Class: com.tuc.g2.apps.webapps.dataviewer.services.data.dao.impl.SubjectSearchDAOImpl, Method: getSubjectByRequestType, Line Number: 43, Detail Code: -805, Message:DBRM OR PACKAGE NAME DBT5.CDBLACT6.USS3.4142415256464977 NOT FOUND IN PLAN DISTSERV. REASON 04DBRM OR PACKAGE NAME DBT5.CDBLACT6.DAS23.3441775056464977 NOT FOUND IN PLAN DISTSERV. REASON 04DBRM OR PACKAGE NAME DBT5.CDBLACT6.USS3.4142415256464977 NOT FOUND IN PLAN DISTSERV. REASON 04 25 Sep 00:36:28 G2SystemServices logException - 
[9/25/10 0:36:28:769 GMT] 00000026 SystemErr     R         

[Jan Cumps]

Welcome to JavaRanch, subbukumararaja.

I would go to the database administrator and ask what the error "REASON 04DBRM OR PACKAGE NAME DBT5.CDBLACT6.USS3.4142415256464977 NOT FOUND IN PLAN DISTSERV" means.
Here's a link to DB2's error explanation: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.codes/n805.htm