java.sql.SQLException: Invalid column type

Oracle Community | 1761829 | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. Speed up your debug routine!

    Automated exception search integrated into your IDE

  2. 0

    oracle.jbo.SQLStmtException: JBO-27122

    Oracle Community | 7 years ago | 795088
    java.sql.SQLException: Invalid column type

    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 type

      at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setObjectAtName
      1. oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8516)
      2. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
      4. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
      5. oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:11907)
      6. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:815)
      6 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3966)
      2. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      3. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)
      4. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      5. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      6. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
      7. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      7 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.executeQueryForMasters(ViewRowSetImpl.java:892)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
      5 frames
    6. 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:2342)
      4. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1584)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:859)
      6. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      7. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1490)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:423)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      13. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      14. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2996)
      15. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1884)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)
      17 frames
    7. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    8. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    9. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    11. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    12. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    13. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    14. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    15. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    16. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    17. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    18. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame