java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • OAF Personalization exception
    via by 2906075,
  • Error:  Invalid Column Index
    via by 193194,
  • Invalid column index: getValidColumnIndex
    via by user542731,
  • Error Extending the VO
    via by Bm,
  • VO extension error invalid index error
    via by abcdxyz,
  • Ap invoice notification issues
    via by 2708947,
  • In dcm4jboss-ejb\src\java\org\dcm4chex\archive\ejb\jdbc\QueryCmd.java, the getDataset() method fills the DICOM dataset with the results of a sql query. Then it calls addOtherPatientSeq which calls checkPatAttrs which then attempts to re-fetch the patient attributes blob from the JDBC result set. On Oracle, when fetching BLOBs as long var binary, that is not allowed. An exception is thrown similar to this one: 2008-02-04 11:52:30,680 ERROR XMT_SCU->T1000DEV9 (TCPServer-1-2) [AgfaQueryRetrieveScpService] Retrieve DB record failed: java.sql.SQLException: Stream has already been closed at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.LongRawAccessor.getBytes(LongRawAccessor.java:155) at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:708) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getBytes(WrappedResultSet.java:445) at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.getBytes(BaseReadCmd.java:80) at org.dcm4chex.archive.ejb.jdbc.QueryCmd.fillDataset(QueryCmd.java:656) at org.dcm4chex.archive.ejb.jdbc.QueryCmd.checkPatAttrs(QueryCmd.java:587) at org.dcm4chex.archive.ejb.jdbc.QueryCmd.addOtherPatientSeq(QueryCmd.java:570) at org.dcm4chex.archive.ejb.jdbc.QueryCmd.getDataset(QueryCmd.java:561) at org.dcm4chex.archive.dcm.qrscp.FindScp.getDataset(FindScp.java:262) at org.dcm4chex.archive.dcm.qrscp.FindScp$MultiCFindRsp.next(FindScp.java:334) at org.dcm4chex.archive.dcm.qrscp.FindScp.doMultiRsp(FindScp.java:278) at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:152) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:231) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:157) at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249) at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:279) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221) at java.lang.Thread.run(Thread.java:595)
    via by Bubba Ganoush,
  • All proceedings are pending in Oracle VM
    via by Diones Alves,
    • java.sql.SQLException: Invalid column index at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:656) at oracle.jbo.domain.Date$2facClass.createDatum(Date.java:158) at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1196) at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634) at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221) at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1073) at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3045) at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2917) at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2398) at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2256) at oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504) at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3705) at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2815) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2671) at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:2912) at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2094) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:782) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441) at oracle.apps.ap.oie.audit.server.AuditReportHeadersVOImpl.executeQuery(AuditReportHeadersVOImpl.java:206) at oracle.apps.ap.oie.audit.server.AuditReportHeadersVOImpl.initQuery(AuditReportHeadersVOImpl.java:96) at oracle.apps.ap.oie.audit.server.AuditAMImpl.initQuery(AuditAMImpl.java:304) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764) at oracle.apps.ap.oie.audit.webui.AuditPageCO.processRequest(AuditPageCO.java:163) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2681) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1963) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439) at _OA._jspService(_OA.java:213) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:308) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:407) at _OA._jspService(_OA.java:222) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:911) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619)
    No Bugmate found.