root cause: Invalid operation: result set closed
be...@cn.ibm.com
I have a problem with websphere.
when I using Tomcat5.5+DB2+Osworkflow 2.7 example,it worked, but when I using the webspere, I got a error message: "root cause: Invalid operation: result set closed."
I search it on line ,and I find the problem is that using two ResultSet nested, I just want to know how to set the webspere to make it worked as tomcat do. Below is the code cause the error:
public List findCurrentSteps(long entryId)
throws StoreException
{
Connection conn;
PreparedStatement stmt;
ResultSet rset;
PreparedStatement stmt2;
Exception exception;
conn = null;
stmt = null;
rset = null;
stmt2 = null;
ArrayList arraylist;
try
{
conn = getConnection();
String sql = "SELECT " + this.stepId + ", " + stepStepId + ", " + stepActionId + ", " + stepOwner + ", " + stepStartDate + ", " + stepDueDate + ", " + stepFinishDate + ", " + stepStatus + ", " + stepCaller + " FROM " + currentTable + " WHERE " + stepEntryId + " = ?";
String sql2 = "SELECT " + stepPreviousId + " FROM " + currentPrevTable + " WHERE " + this.stepId + " = ?";
if(log.isDebugEnabled())
log.debug("Executing SQL statement: " + sql);
stmt = conn.prepareStatement(sql,TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY);
if(log.isDebugEnabled())
log.debug("Executing SQL statement: " + sql2);
stmt2 = conn.prepareStatement(sql2,TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY);
stmt.setLong(1, entryId);
rset = stmt.executeQuery();
ArrayList currentSteps = new ArrayList();
SimpleStep step;
for(; rset.next(); currentSteps.add(step))
{
long id = rset.getLong(1);
int stepId = rset.getInt(2);
int actionId = rset.getInt(3);
String owner = rset.getString(4);
Date startDate = rset.getTimestamp(5);
Date dueDate = rset.getTimestamp(6);
Date finishDate = rset.getTimestamp(7);
String status = rset.getString(8);
String caller = rset.getString(9);
ArrayList prevIdsList = new ArrayList();
stmt2.setLong(1, id);
long prevId;
for(ResultSet rs = stmt2.executeQuery(); rs.next(); prevIdsList.add(new Long(prevId)))
prevId = rs.getLong(1);
long prevIds[] = new long[prevIdsList.size()];
int i = 0;
for(Iterator iterator = prevIdsList.iterator(); iterator.hasNext();)
{
Long aLong = (Long)iterator.next();
prevIds[i] = aLong.longValue();
i++;
}
step = new SimpleStep(id, entryId, stepId, actionId, owner, startDate, dueDate, finishDate, status, prevIds, caller);
}
arraylist = currentSteps;
}
catch(SQLException e)
{
throw new StoreException("Unable to locate current steps for workflow instance #" + entryId, e);
}
finally
{
JVM INSTR jsr 660;
}
return arraylist;
throw exception;
local;
cleanup(null, stmt2, null);
cleanup(conn, stmt, rset);
JVM INSTR ret 27;
}
Below is the log message:
[2/14/06 16:12:03:938 CST] 00000072 ApplicationMg A WSVR0217I: Stopping application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:03:953 CST] 00000072 ServletWrappe A SRVE0253I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/nav.jsp]: Destroy successful.
[2/14/06 16:12:03:969 CST] 00000072 ServletWrappe A SRVE0253I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/underway.jsp]: Destroy successful.
[2/14/06 16:12:03:985 CST] 00000072 ServletWrappe A SRVE0253I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/login.jsp]: Destroy successful.
[2/14/06 16:12:03:985 CST] 00000072 ServletWrappe A SRVE0253I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/default.jsp]: Destroy successful.
[2/14/06 16:12:04:000 CST] 00000072 ServletWrappe A SRVE0253I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/test.jsp]: Destroy successful.
[2/14/06 16:12:04:047 CST] 00000072 ApplicationMg A WSVR0220I: Application stopped: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:05:625 CST] 00000072 ApplicationMg A WSVR0200I: Starting application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:05:781 CST] 00000072 WebGroup A SRVE0169I: Loading Web Module: OSWorkflow Example App.
[2/14/06 16:12:05:844 CST] 00000072 VirtualHost I SRVE0250I: Web Module OSWorkflow Example App has been bound to default_host[*:9080,*:80,*:9443].
[2/14/06 16:12:05:860 CST] 00000072 ApplicationMg A WSVR0221I: Application started: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:05:906 CST] 00000072 FileRepositor A ADMR0009I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deltas/osworkflow-2_7_0-exampleEAR.ear/delta-1139904723188 is created.
[2/14/06 16:12:05:922 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/osworkflow-2_7_0-exampleEAR.ear is modified.
[2/14/06 16:12:05:938 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/deployment.xml is modified.
[2/14/06 16:12:05:938 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/osworkflow-2_7_0-example.war/META-INF/MANIFEST.MF is modified.
[2/14/06 16:12:05:953 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/osworkflow-2_7_0-example.war/WEB-INF/web.xml is modified.
[2/14/06 16:12:05:969 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/nodes/istcn02Node01/serverindex.xml is modified.
[2/14/06 16:12:05:985 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/META-INF/MANIFEST.MF is modified.
[2/14/06 16:12:06:000 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/META-INF/application.xml is modified.
[2/14/06 16:12:06:000 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/osworkflow-2_7_0-example.war/WEB-INF/ibm-web-ext.xmi is modified.
[2/14/06 16:12:06:016 CST] 00000072 FileRepositor A ADMR0010I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deployments/osworkflow-2_7_0-exampleEAR/osworkflow-2_7_0-example.war/WEB-INF/ibm-web-bnd.xmi is modified.
[2/14/06 16:12:06:031 CST] 00000072 FileRepositor A ADMR0011I: Document cells/istcn02Node01Cell/applications/osworkflow-2_7_0-exampleEAR.ear/deltas/osworkflow-2_7_0-exampleEAR.ear/delta-1139902977114 is deleted.
[2/14/06 16:12:06:438 CST] 0000003c ApplicationMg A WSVR0217I: Stopping application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:06:453 CST] 0000003c ApplicationMg A WSVR0220I: Application stopped: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:06:750 CST] 00000054 ApplicationMg A WSVR0200I: Starting application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:06:938 CST] 00000054 WebGroup A SRVE0169I: Loading Web Module: OSWorkflow Example App.
[2/14/06 16:12:07:016 CST] 00000054 VirtualHost I SRVE0250I: Web Module OSWorkflow Example App has been bound to default_host[*:9080,*:80,*:9443].
[2/14/06 16:12:07:031 CST] 00000054 ApplicationMg A WSVR0221I: Application started: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:16:828 CST] 00000054 ApplicationMg A WSVR0217I: Stopping application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:16:843 CST] 00000054 ApplicationMg A WSVR0220I: Application stopped: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:17:140 CST] 00000031 ApplicationMg A WSVR0200I: Starting application: osworkflow-2_7_0-exampleEAR
[2/14/06 16:12:17:343 CST] 00000031 WebGroup A SRVE0169I: Loading Web Module: OSWorkflow Example App.
[2/14/06 16:12:17:406 CST] 00000031 VirtualHost I SRVE0250I: Web Module OSWorkflow Example App has been bound to default_host[*:9080,*:80,*:9443].
[2/14/06 16:12:17:422 CST] 00000031 ApplicationMg A WSVR0221I: Application started: osworkflow-2_7_0-exampleEAR
[2/14/06 16:13:08:420 CST] 00000035 ServletWrappe A SRVE0242I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/default.jsp]: Initialization successful.
[2/14/06 16:13:14:810 CST] 00000038 ServletWrappe A SRVE0242I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/login.jsp]: Initialization successful.
[2/14/06 16:13:15:826 CST] 00000032 ServletWrappe A SRVE0242I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/nav.jsp]: Initialization successful.
[2/14/06 16:13:18:169 CST] 00000038 ServletWrappe A SRVE0242I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/underway.jsp]: Initialization successful.
[2/14/06 16:13:20:091 CST] 00000035 ServletWrappe A SRVE0242I: [osworkflow-2_7_0-exampleEAR] [/osworkflow-2_7_0-example] [/test.jsp]: Initialization successful.
[2/14/06 16:13:20:372 CST] 00000035 AbstractWorkf E com.opensymphony.workflow.AbstractWorkflow getAvailableActions Error checking available actions
com.opensymphony.workflow.StoreException: Unable to locate current steps for workflow instance #1: root cause: Invalid operation: result set closed
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:239)
at com.opensymphony.workflow.AbstractWorkflow.getAvailableActions(AbstractWorkflow.java:104)
at com.ibm._jsp._test._jspService(_test.java:108)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))
Root cause:
com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.rc.mb(rc.java:3422)
at com.ibm.db2.jcc.c.rc.c(rc.java:290)
at com.ibm.db2.jcc.c.rc.next(rc.java:277)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2419)
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:202)
at com.opensymphony.workflow.AbstractWorkflow.getAvailableActions(AbstractWorkflow.java:104)
at com.ibm._jsp._test._jspService(_test.java:108)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))
[2/14/06 16:13:20:419 CST] 00000035 AbstractWorkf E com.opensymphony.workflow.AbstractWorkflow getSecurityPermissions Error getting security permissions for instance #1
com.opensymphony.workflow.StoreException: Unable to locate current steps for workflow instance #1: root cause: Invalid operation: result set closed
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:239)
at com.opensymphony.workflow.AbstractWorkflow.getSecurityPermissions(AbstractWorkflow.java:267)
at com.ibm._jsp._test._jspService(_test.java:125)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))
Root cause:
com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.rc.mb(rc.java:3422)
at com.ibm.db2.jcc.c.rc.c(rc.java:290)
at com.ibm.db2.jcc.c.rc.next(rc.java:277)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2419)
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:202)
at com.opensymphony.workflow.AbstractWorkflow.getSecurityPermissions(AbstractWorkflow.java:267)
at com.ibm._jsp._test._jspService(_test.java:125)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))
[2/14/06 16:13:20:450 CST] 00000035 AbstractWorkf E com.opensymphony.workflow.AbstractWorkflow getCurrentSteps Error checking current steps for instance #1
com.opensymphony.workflow.StoreException: Unable to locate current steps for workflow instance #1: root cause: Invalid operation: result set closed
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:239)
at com.opensymphony.workflow.AbstractWorkflow.getCurrentSteps(AbstractWorkflow.java:186)
at com.ibm._jsp._test._jspService(_test.java:136)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))
Root cause:
com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.rc.mb(rc.java:3422)
at com.ibm.db2.jcc.c.rc.c(rc.java:290)
at com.ibm.db2.jcc.c.rc.next(rc.java:277)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:2419)
at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.findCurrentSteps(JDBCWorkflowStore.java:202)
at com.opensymphony.workflow.AbstractWorkflow.getCurrentSteps(AbstractWorkflow.java:186)
at com.ibm._jsp._test._jspService(_test.java:136)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:178)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:241)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2905)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1829)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:469)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:408)
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(Compiled Code))
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(Compiled Code))