java.sql.SQLException: Invalid column type

Oracle Community | 879472 | 5 years ago
  1. 0

    Extending PoDistributionMergeEO casuing errors

    Oracle Community | 5 years ago | 879472
    java.sql.SQLException: Invalid column type
  2. 0

    EO Extension Invalid Column error on Create

    Oracle Community | 9 years ago | 580701
    java.sql.SQLException: Invalid column type
  3. 0

    Spring JDBC lob insertion fails: Invalid column type

    Stack Overflow | 4 years ago | nsayer
    java.sql.SQLException: Invalid column type
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    groovy.sql.Sql error calling firstRow with Oracle 10g

    Stack Overflow | 4 years ago | sigint
    java.sql.SQLException: Invalid column type

    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 type

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.setObject
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
      4. oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9231)
      5. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8812)
      6. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9534)
      7. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9517)
      7 frames
    3. oracle.jbo.server
      EntityImpl.getAttributeInternal
      1. oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
      2. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3893)
      3. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      4. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13827)
      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:3723)
      8. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      9. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
      10. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1474)
      13. oracle.jbo.server.EntityRowSetIteratorImpl.first(EntityRowSetIteratorImpl.java:145)
      14. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2828)
      15. oracle.jbo.server.AssociationDefImpl.get(AssociationDefImpl.java:384)
      16. oracle.jbo.server.AssociationDefImpl.get(AssociationDefImpl.java:291)
      17. oracle.jbo.server.EntityImpl.getAttributeInternal(EntityImpl.java:2151)
      17 frames
    4. oracle.apps.fnd
      OAEntityImpl.getAttributeInternal
      1. oracle.apps.fnd.framework.server.OAEntityImpl.getAttribute(OAEntityImpl.java:1367)
      2. oracle.apps.fnd.framework.server.OAEntityImpl.getAttributeInternal(OAEntityImpl.java:1348)
      2 frames
    5. oracle.apps.po
      PoBaseAMImpl.executeServerCommand
      1. oracle.apps.po.schema.server.PoDistributionMergeEOImpl.getPoLineLocationMergeEO(PoDistributionMergeEOImpl.java:3287)
      2. oracle.apps.po.document.server.PoDistributionsMergeVORowImpl.getPoLineLocationMergeEO(PoDistributionsMergeVORowImpl.java:396)
      3. oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelForDestinationTypeRender(PoDistributionsRenderCmd.java:1063)
      4. oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelForDestinationType(PoDistributionsRenderCmd.java:1036)
      5. oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelAttributesForDistribution(PoDistributionsRenderCmd.java:878)
      6. oracle.apps.po.document.server.PoDistributionsRenderCmd.prepareSpelAttributesForRow(PoDistributionsRenderCmd.java:310)
      7. oracle.apps.po.common.server.PoTableBaseRenderCmd.prepareSpelAttributesForRange(PoTableBaseRenderCmd.java:171)
      8. oracle.apps.po.common.server.PoTableBaseRenderCmd.prepareSpelAttributes(PoTableBaseRenderCmd.java:99)
      9. oracle.apps.po.document.server.PoDistributionsRenderCmd.execute(PoDistributionsRenderCmd.java:261)
      10. oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
      10 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    7. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      2 frames
    8. oracle.apps.po
      OrderDistributionsCO.processRequest
      1. oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
      2. oracle.apps.po.document.order.webui.OrderDistributionsCO.processRequest(OrderDistributionsCO.java:97)
      2 frames
    9. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      8. oracle.apps.fnd.framework.webui.OASubTabLayoutHelper.processRequest(OASubTabLayoutHelper.java:433)
      9. oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processRequest(OASubTabLayoutBean.java:465)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      19. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      20. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      24. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      25. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      30. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      31. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2497)
      32. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1893)
      33. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:537)
      34. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:425)
      34 frames