com.solarmetric.jdbc.ReportingSQLException: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 {prepstmnt 17678065 INSERT INTO COR.T_PROJECTCOST (AMOUNT_F, APPROVALINFO_VC, BILLABLE_B, DATE_DT, DESCRIPTION_VC, ID_I, NAME_VC, PROJECTCOSTTYPE_ID_I, PROJECT_ID_I, ROWVERSION_I) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=-99999, state=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.solarmetric.jdbc.ReportingSQLException: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 {prepstmnt 17678065 INSERT INTO COR.T_PROJECTCOST (AMOUNT_F, APPROVALINFO_VC, BILLABLE_B, DATE_DT, DESCRIPTION_VC, ID_I, NAME_VC, PROJECTCOSTTYPE_ID_I, PROJECT_ID_I, ROWVERSION_I) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=-99999, state=22008]
  2. 0

    Update failed when trying to update a nested object

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF.
  3. 0

    XA error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-02019: can't find the connection description {prepstmnt 10 INSERT INTO QUAKEGAO@TEST (JDOCLASS, JDOVERSION, NAME0, OID, PWD) VALUES (?, ?, ?, ?, ?)} [code=2019, state=]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    oracle clob problem

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-00600: internal error code, arguments: [kokleva], [], [], [], [], [], [], [] {prepstmnt 1173845 INSERT INTO EPSCHEDULE.SC_TMEMO (CONTENT, JDOVERSION, MCODE, MODIFYTIME, RCODE, RFLAG, TITLE, USERID, USERNAME, WDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=600, state=60000]
  6. 0

    cannot write to the database

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, value) VALUES ('test', '50')' at line 1 {prepstmnt 849515 INSERT INTO ns_config (key, value) VALUES (?, ?) [reused=0]} [code=1064, state=42000]

    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.solarmetric.jdbc.ReportingSQLException

      [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 {prepstmnt 17678065 INSERT INTO COR.T_PROJECTCOST (AMOUNT_F, APPROVALINFO_VC, BILLABLE_B, DATE_DT, DESCRIPTION_VC, ID_I, NAME_VC, PROJECTCOSTTYPE_ID_I, PROJECT_ID_I, ROWVERSION_I) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=-99999, state=22008]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:67)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:649)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      4 frames
    3. 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
    4. kodo.runtime
      DelegatingStoreManager.flush
      1. kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:158)
      1 frame
    5. kodo.datacache
      DataCacheStoreManager.flush
      1. kodo.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:412)
      1 frame
    6. 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