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)
Environment
- DB2 v9.7.0.3
- jcc.DB2Driver type 4 jcc driver
- JBoss Enterprise Application Platform (EAP)
- 5.0.0
NOTE: Usually this can happens with any Database and Any Jdbc Driver.
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
