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]

Oracle Community | 3004 | 1 decade ago
  1. 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]
  2. 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]
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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=]
  6. 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]

    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

      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]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:728)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
      4 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager.flush
      1. kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1716)
      2. kodo.jdbc.runtime.PreparedStatementManager.flushInternal(PreparedStatementManager.java:235)
      3. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:206)
      4. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:220)
      5. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:95)
      6. kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:614)
      6 frames
    4. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:153)
      2. kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:1159)
      3. kodo.runtime.PersistenceManagerImpl.flushSafe(PersistenceManagerImpl.java:1042)
      4. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:969)
      5. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      6. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:629)
      6 frames
    5. reversetutorial
      Finder.main
      1. reversetutorial.Finder.executeCreatQuery(Finder.java:108)
      2. reversetutorial.Finder.main(Finder.java:44)
      2 frames