COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008

Oracle Community | 3004 | 1 decade ago
  1. 0

    Datetime field overflow in DB2 with Kodo 3.0.3

    Oracle Community | 1 decade ago | 3004
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008
  2. 0

    Can't start adminserver with error code 10

    Google Groups | 1 decade ago | Jeffrey
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
  3. 0

    Error SQLCODE "-811", SQLSTATE "21000"

    Google Groups | 1 decade ago | Richard
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0723N An error occurred in a triggered SQL statement in trigger "OLGCWEB.TBLPROPS_INS_TRG". Information returned for the error includes SQLCODE "-811", SQLSTATE "21000" and message tokens "". SQLSTATE=09000 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(CompiledCode)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(InlinedCompiled Code)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(CompiledCode)) at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java(CompiledCode))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Help in SQLException (SQLState = CLI0122E)

    Google Groups | 1 decade ago | yongsing
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0 122E Program type out of range. SQLSTATE=HY003
  6. 0

    SQL stored procedure on windows 2000

    Google Groups | 1 decade ago | Mazdak Mani
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1042C An unexpected system error occurred. SQLSTATE=58004

    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. COM.ibm.db2.jdbc.DB2Exception

      [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008

      at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException()
    2. COM.ibm.db2
      DB2PreparedStatement.executeUpdate
      1. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(UnknownSource)
      2. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(UnknownSource)
      3. COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(UnknownSource)
      4. COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
      5. COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown Source)
      5 frames
    3. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeUpdate(PoolConnection.java:374)
      3. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      5. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      6. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:645)
      7. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      7 frames
    4. kodo.jdbc.runtime
      JDBCStoreManager.flush
      1. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:164)
      2. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:92)
      3. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:357)
      4. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:154)
      5. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:72)
      6. kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:507)
      6 frames
    5. kodo.runtime
      DelegatingStoreManager.flush
      1. kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:158)
      1 frame
    6. kodo.datacache
      DataCacheStoreManager.flush
      1. kodo.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:412)
      1 frame
    7. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:794)
      2. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:650)
      3. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      4. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:422)
      4 frames