java.sql.SQLException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Oracle Community | 3004 | 2 decades ago
  1. 0

    Why does one SQL string work and the other doesn't?

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
  2. 0

    CLOB/BLOB

    Google Groups | 2 decades ago | Dung Nguyen
    java.sql.SQLException: ORA-01002: fetch out of sequence
  3. 0

    CLOB/BLOB

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-01002: fetch out of sequence
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Adding node using shared appl_top failed

    Oracle Community | 10 years ago | 576038
    java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []
  6. 0

    Problem in findByPrimaryKey while preparing or executing the statement

    Oracle Community | 1 decade ago | 843829
    java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []

    26 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-01841: (full) year must be between -4713 and +9999, and not be 0

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.fetch
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
      4. oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
      4 frames
    4. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
      2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
      3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
      4 frames
    5. catalog
      QueryEngine.StartQuery
      1. catalog.QueryDB.BuildQuery(QueryDB.java:167)
      2. catalog.QueryDB.<init>(QueryDB.java:32)
      3. catalog.QueryEngine.StartQuery(QueryEngine.java:35)
      3 frames
    6. Servlet
      TestQH.main
      1. Servlet.TestQH.CallQueryHandler(TestQH.java:55)
      2. Servlet.TestQH.<init>(TestQH.java:42)
      3. Servlet.TestQH.main(TestQH.java:46)
      3 frames