java.sql.SQLException: Invalid column index

Oracle Community | 2725480 | 2 years ago
  1. 0

    Spring JdbcTemplate and oracle arrayofnumber

    Stack Overflow | 3 years ago | user2078222
    java.sql.SQLException: Invalid column type
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Using the Oracle Driver for the Engine DataSource

    Oracle Community | 8 years ago | 525476
    fuego.transaction.DatabaseException: An error occurred while accesing the database. Detail:SQL statement: 'SELECT WKTDKEY, DUETIME, ID, PROCESSID FROM PWKTODO WHERE WKTDKEY = ?'

    8 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.OraclePreparedStatement.setNUMBERInternal()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setObject
      1. oracle.jdbc.driver.OraclePreparedStatement.setNUMBERInternal(OraclePreparedStatement.java:8141)
      2. oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:10791)
      3. oracle.jdbc.driver.OraclePreparedStatement.setCustomDatumInternal(OraclePreparedStatement.java:10401)
      4. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11655)
      5. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11631)
      6. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:253)
      6 frames
    3. weblogic.jdbc.wrapper
      PreparedStatement.setObject
      1. weblogic.jdbc.wrapper.PreparedStatement.setObject(PreparedStatement.java:357)
      1 frame
    4. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
      2. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3940)
      3. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      4. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)
      5. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      6. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      7. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
      8. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      8 frames
    5. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4591)
      1 frame
    6. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
      5 frames
    7. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      1 frame
    8. oracle.apps.xxfe
      ASNOpptyQryAMExImpl.initOpptyQuery
      1. oracle.apps.xxfe.f486.asn.opportunity.server.ASNOpptyQryAMExImpl.initOpptyQuery(ASNOpptyQryAMExImpl.java:514)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    10. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:733)
      2 frames
    11. oracle.apps.asn
      ASNOpptyLstCO.executeOpptyQuery
      1. oracle.apps.asn.opportunity.webui.ASNOpptyLstCO.executeOpptyQuery(Unknown Source)
      1 frame
    12. oracle.apps.xxfe
      ASNOpptyLstCOEx.executeOpptyQuery
      1. oracle.apps.xxfe.f486.asn.opportunity.webui.ASNOpptyLstCOEx.executeOpptyQuery(ASNOpptyLstCOEx.java:335)
      1 frame
    13. oracle.apps.asn
      ASNOpptyLstCO.processFormRequest
      1. oracle.apps.asn.opportunity.webui.ASNOpptyLstCO.processFormRequest(Unknown Source)
      1 frame
    14. oracle.apps.xxfe
      ASNOpptyLstCOEx.processFormRequest
      1. oracle.apps.xxfe.f486.asn.opportunity.webui.ASNOpptyLstCOEx.processFormRequest(ASNOpptyLstCOEx.java:134)
      1 frame
    15. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
      2. oracle.apps.fnd.framework.webui.OATableHelper.processFormRequest(OATableHelper.java:460)
      3. oracle.apps.fnd.framework.webui.beans.table.OATableBean.processFormRequest(OATableBean.java:1058)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(OAHeaderBean.java:410)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      18. oracle.apps.fnd.framework.webui.OAQueryHelper.processFormRequest(OAQueryHelper.java:1035)
      19. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      23. oracle.apps.fnd.framework.webui.beans.OAFlexibleContentBean.processFormRequest(OAFlexibleContentBean.java:372)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      27. oracle.apps.fnd.framework.webui.beans.layout.OAFlexibleLayoutBean.processFormRequest(OAFlexibleLayoutBean.java:376)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      29. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      31. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      32. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
      33. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      34. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      36. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      37. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1319)
      38. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      39. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      40. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      41. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      42. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      43. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
      44. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
      45. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
      46. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
      47. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      48. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      49. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3172)
      50. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1927)
      51. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
      52. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
      52 frames
    16. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:233)
      1 frame
    17. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    18. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      5 frames
    19. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    20. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    21. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    22. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    23. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    24. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    25. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    26. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    27. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    28. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    29. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    30. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    31. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
      1 frame
    32. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
      3 frames
    33. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    34. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    35. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
      3 frames
    36. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames