java.sql.SQLException: ORA-01790: expression must have same datatype as corresponding expression

Oracle Community | 666705 | 1 decade ago
  1. 0

    kodo.persistence.PersistenceException: expression must have same datatype

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-01790: expression must have same datatype as corresponding expression
  2. 0

    java.sql.SQLException: ORA-00942: table or view does not exist, getting in every third hit to database

    Stack Overflow | 4 months ago | Praveen Rawat
    java.sql.SQLException: ORA-00942: table or view does not exist exception. i want to understand why its happening and what would be the possible the reason? Please help me. Full Stacktrace: java.sql.SQLException: ORA-00942: table or view does not exist
  3. 0

    Openbravo won't run.

    openbravo | 10 years ago | kchopein
    java.sql.SQLException: ORA-00907: falta el paréntesis derecho
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to equeue to distributed cache topic (JMS)

    Oracle Community | 1 decade ago | 424530
    java.sql.SQLException: ORA-25228: timeout or end-of-fetch during message dequeue from DIFAS2AQUSER.TOPLINK_CACHESYNC ORA-06512: at "SYS.DBMS_AQIN", line 263 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
  6. 0

    Query bind parameter in Trees

    Oracle Community | 1 decade ago | 475070
    java.sql.SQLException: Parâmetro IN ou OUT ausente do índice:: 1

    12 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

      ORA-01790: expression must have same datatype as corresponding expression

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)
      11 frames
    3. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:347)
      2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeQuery(PoolConnection.java:343)
      3. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      5. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      6. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1094)
      7. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      7 frames
    4. kodo.jdbc.kernel
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1633)
      1 frame
    5. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:332)
      1 frame
    6. kodo.jdbc.sql
      Union.execute
      1. kodo.jdbc.sql.Union.execute(Union.java:425)
      2. kodo.jdbc.sql.Union.execute(Union.java:332)
      3. kodo.jdbc.sql.Union.execute(Union.java:313)
      4. kodo.jdbc.sql.SelectImpl.addEagerResults(SelectImpl.java:386)
      5. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:350)
      6. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:301)
      7. kodo.jdbc.sql.Union$UnionSelect.execute(Union.java:642)
      8. kodo.jdbc.sql.Union.execute(Union.java:326)
      9. kodo.jdbc.sql.Union.execute(Union.java:313)
      9 frames
    7. kodo.jdbc.kernel
      SelectResultObjectProvider.open
      1. kodo.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:98)
      1 frame