java.sql.SQLException: Invalid column index

Oracle Community | 879472 | 6 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    SDO_UTIL.FROM_KMLGEOMETRY and Java

    Oracle Community | 7 years ago | 793484
    java.sql.SQLException: Invalid column index
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Failed to load value at index 22 with java object of type java.lang.String

    Oracle Community | 5 years ago | user243722
    java.sql.SQLException: Invalid column index

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid column index

      at oracle.jdbc.driver.OracleResultSetImpl.getObject()
    2. Oracle jdbc
      OracleResultSetImpl.getObject
      1. oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:1042)
      1 frame
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1198)
      2. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1633)
      3. oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
      4. oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1101)
      5. oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3036)
      6. oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2913)
      7. oracle.jbo.server.QueryCollection.saveNextRowInResultSet(QueryCollection.java:3680)
      8. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:905)
      9. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      10. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
      11. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      11 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
      3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
      4. oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:2915)
      5. oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2086)
      6. oracle.jbo.server.ViewRowSetImpl.refreshRowSet(ViewRowSetImpl.java:4886)
      7. oracle.jbo.server.ViewRowSetIteratorImpl.notifyDetailRowSets(ViewRowSetIteratorImpl.java:3408)
      8. oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigationToRow(ViewRowSetIteratorImpl.java:3549)
      9. oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigation(ViewRowSetIteratorImpl.java:3509)
      10. oracle.jbo.server.ViewRowSetIteratorImpl.internalSetCurrentRow(ViewRowSetIteratorImpl.java:3293)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1481)
      12. oracle.jbo.server.ViewRowSetImpl.getMasterKeyValues(ViewRowSetImpl.java:4362)
      13. oracle.jbo.server.ViewRowSetImpl.getParameters(ViewRowSetImpl.java:4273)
      14. oracle.jbo.server.ViewRowSetImpl.getRowFilter(ViewRowSetImpl.java:378)
      15. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:718)
      16. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      17. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      18. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      19. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
      19 frames
    6. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      1 frame
    7. oracle.apps.irc
      VacancyAMImpl.displayVacancy
      1. oracle.apps.irc.vacancy.server.IrcEditVacancyVOImpl.runQuery(IrcEditVacancyVOImpl.java:157)
      2. oracle.apps.irc.vacancy.server.VacancyAMImpl.initializeVacancyVOs(VacancyAMImpl.java:629)
      3. oracle.apps.irc.vacancy.server.VacancyAMImpl.displayVacancy(VacancyAMImpl.java:2188)
      3 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    9. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
      3 frames
    10. oracle.apps.irc
      IrcVacancyViewCO.processRequest
      1. oracle.apps.irc.vacancy.webui.IrcVacancyViewCO.displayVacancy(IrcVacancyViewCO.java:396)
      2. oracle.apps.irc.vacancy.webui.IrcVacancyViewCO.processRequest(IrcVacancyViewCO.java:158)
      2 frames
    11. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      18 frames