java.sql.SQLException: Invalid column index

Oracle Community | SUDHIR BHILAR | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MyBatis-Spring-jsf: Error setting null parameters

    Google Groups | 5 years ago | Davide Carrettin
    java.sql.SQLException: Tipo di colonna non valido: 1111
  2. 0

    mybatis-user - MyBatis-Spring-jsf: Error setting null parameters

    nabble.com | 8 months ago
    java.sql.SQLException: Tipo di colonna non valido: 1111
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    How to insert unicode to Oracle NVARCHAR using MyBatis with Spring integration

    Google Groups | 4 years ago | Tural Muradbeyli
    java.sql.SQLException: Invalid column index

    2 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.setNullCritical()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setNull
      1. oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:5190)
      2. oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:5159)
      3. oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1435)
      3 frames
    3. weblogic.jdbc.wrapper
      PreparedStatement.setNull
      1. weblogic.jdbc.wrapper.PreparedStatement.setNull(PreparedStatement.java:622)
      1 frame
    4. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1877)
      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
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      2. oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:743)
      3. oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2369)
      4. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1585)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:886)
      6. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
      7. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1491)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(Unknown Source)
      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.OABodyBean.processFormRequest(OABodyBean.java:363)
      14. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3169)
      15. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1924)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
      17 frames
    8. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:233)
      1 frame
    9. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    10. 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
    11. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    12. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    13. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    14. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    15. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    16. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    17. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    18. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    19. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    20. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    21. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      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
    22. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    23. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      1 frame
    24. 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
    25. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    26. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    27. 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
    28. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames