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.

  • Error Extending the VO
    via by Bm,
  • Invalid column index: getValidColumnIndex
    via by user542731,
  • VO extension error invalid index error
    via by abcdxyz,
  • Error:  Invalid Column Index
    via by 193194,
  • Ap invoice notification issues
    via by 2708947,
  • OAF Personalization exception
    via by 2906075,
  • 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.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445) at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:538) at oracle.jbo.domain.Number$1facClass.createDatum(Number.java:103) at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1194) at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1633) at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221) at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1066) at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3014) at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2907) at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2272) at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2130) at oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504) at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3697) at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2818) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2674) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634) at oracle.jbo.server.ViewRowSetIteratorImpl.getRowCountInRange(ViewRowSetIteratorImpl.java:699) at oracle.jbo.server.ViewRowSetImpl.getRowCountInRange(ViewRowSetImpl.java:3195) at oracle.jbo.server.ViewObjectImpl.getRowCountInRange(ViewObjectImpl.java:7027) at oracle.apps.fnd.framework.server.OAViewObjectImpl.getRowCountInRange(OAViewObjectImpl.java:1981) at oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.adjustViewRange(OAWebBeanBaseTableHelper.java:226) at oracle.apps.fnd.framework.webui.OATableHelper.prepareNavigatorProperties(OATableHelper.java:1652) at oracle.apps.fnd.framework.webui.OATableHelper.prepareForRendering(OATableHelper.java:513) at oracle.apps.fnd.framework.webui.beans.table.OATableBean.prepareForRendering(OATableBean.java:1220) at oracle.apps.pon.award.creation.webui.AwardByQuoteCO.setAllColsFormat(AwardByQuoteCO.java:714) at oracle.apps.pon.award.creation.webui.AwardByQuoteCO.setTableLayout(AwardByQuoteCO.java:528) at oracle.apps.pon.award.creation.webui.AwardByQuoteCO.processRequest(AwardByQuoteCO.java:211) at xxifms.oracle.apps.pon.award.creation.webui.xxAwardByQuoteCO.processRequest(xxAwardByQuoteCO.java:52) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1191) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2582) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1913) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    81 more bugmates