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

Oracle Community | 3004 | 2 decades ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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], [], [], [], [], [], []

  1. rp 1 times, last 4 months ago
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