Sites on WebSphere with DB2 throws SQLExceptions (Doc ID 1481887.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle WebCenter Sites - Version 7.5.0 and later
Information in this document applies to any platform.

Symptoms

We're using Oracle WebCenter Sites with WebSphere and DB2, and getting SQLExceptions in the logs:

[2012-08-01 19:19:43.514][CS.DB][ERROR] SQLException getting a column value column 4 in query: SELECT elementname,description,url,resdetails1,resdetails2 FROM ElementCatalog WHERE elementname = ?
com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.62.57] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:663)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:103)
at com.ibm.db2.jcc.am.nn.Db(nn.java:4528)
at com.ibm.db2.jcc.am.nn.r(nn.java:4485)
at com.ibm.db2.jcc.am.nn.e(nn.java:1134)
at com.ibm.db2.jcc.am.nn.getString(nn.java:1122)
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getString(WSJdbcResultSet.java:2439)
at COM.FutureTense.Servlet.G.B(y:2364)
at COM.FutureTense.Servlet.G.A(y:3580)
at COM.FutureTense.CatalogManager.C$_A.(y:289)
at COM.FutureTense.CatalogManager.C.A(y:2676)
at COM.FutureTense.CatalogManager.C.P(y:482)
at COM.FutureTense.Common.j.prepareElement(y:1155)

This also causes other exceptions:

[2012-08-01 19:19:43.705][CS.JSP][ERROR] Exception in doEndTag() in tag com.openmarket.xcelerate.jsp.render.Lookup in page 'myPage' in element 'myElement' errno: 0 errdetail: 0
java.lang.NumberFormatException: null
at java.lang.Long.parseLong(Long.java:386)
at java.lang.Long.parseLong(Long.java:479)
at com.openmarket.xcelerate.common.MapTableManager.readValues(y:2851)
at com.openmarket.xcelerate.common.MapTableManager.lookupKey(y:463)
at com.openmarket.xcelerate.asset.CSElementManager.lookupKey(y:3016)
at com.openmarket.xcelerate.jsp.render.Lookup.doEndTag(y:3545)
at com.openmarket.framework.jsp.Base.doEndTag(y:32)
at _ibmjsp.jsp.cs_5F_deployed._myElement._jspService(_myElement.java:455)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms