ResultSet is Closed error

Issue

• While running some Jdbc Queries as part of an Application which uses IBM Jdbc Driver it throws following kind of errors like following:

    2011-02-01 12:08:43,085 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/kosh].[jsp]] (http-0.0.0.0-8080-4) Servlet.service() for servlet jsp threw exception
    com.ibm.db2.jcc.am.SqlException: [jcc][10234][10927][4.8.87] SQL passed with no tokens. ERRORCODE=-4462, SQLSTATE=null
         at com.ibm.db2.jcc.am.gd.a(gd.java:660)
         at com.ibm.db2.jcc.am.gd.a(gd.java:60)
         at com.ibm.db2.jcc.am.gd.a(gd.java:120)
         at com.ibm.db2.jcc.am.wm.h(wm.java:3363)
         at com.ibm.db2.jcc.am.wm.a(wm.java:2754)
         at com.ibm.db2.jcc.am.wm.a(wm.java:659)

    2011-02-01 12:46:56,092 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/kosh].[jsp]] (http-0.0.0.0-8080-5) Servlet.service() for servlet jsp threw exception
    com.ibm.db2.jcc.am.SqlException: [jcc][t4][1090][10899][4.8.87] Invalid operation to read at current cursor position. ERRORCODE=-4476, SQLSTATE=02501
         at com.ibm.db2.jcc.am.gd.a(gd.java:679)
         at com.ibm.db2.jcc.am.gd.a(gd.java:60)
         at com.ibm.db2.jcc.am.gd.a(gd.java:120)
         at com.ibm.db2.jcc.am.km.Eb(km.java:4395)
         at com.ibm.db2.jcc.am.km.s(km.java:4347)
         at com.ibm.db2.jcc.am.km.b(km.java:772)
         at com.ibm.db2.jcc.am.km.getInt(km.java:765)
         at com.ibm.db2.jcc.am.km.getInt(km.java:1525)

    2011-02-01 15:04:27,208 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/kosh].[jsp]] (http-0.0.0.0-8080-2) Servlet.service() for servlet jsp threw exception
    com.ibm.db2.jcc.am.vo: DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815, SQLERRMC=2;SYSIBM.COALESCE, DRIVER=4.8.87
         at com.ibm.db2.jcc.am.gd.a(gd.java:676)
         at com.ibm.db2.jcc.am.gd.a(gd.java:60)
         at com.ibm.db2.jcc.am.gd.a(gd.java:127)
         at com.ibm.db2.jcc.am.wm.c(wm.java:2510)
         at com.ibm.db2.jcc.am.wm.d(wm.java:2498)
         at com.ibm.db2.jcc.am.wm.a(wm.java:1978)
         at com.ibm.db2.jcc.t4.fb.g(fb.java:140)
         at com.ibm.db2.jcc.t4.fb.a(fb.java:40)
         at com.ibm.db2.jcc.t4.t.a(t.java:32)
         at com.ibm.db2.jcc.t4.ub.i(ub.java:135)
         at com.ibm.db2.jcc.am.wm.hb(wm.java:1949)
         at com.ibm.db2.jcc.am.wm.a(wm.java:2968)
         at com.ibm.db2.jcc.am.wm.a(wm.java:659)
         at com.ibm.db2.jcc.am.wm.executeQuery(wm.java:643)