java.sql.SQLException: 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 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    cannot write to the database

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: 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 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
  2. 0

    Hibernate-Mapping of one object type in two sets is not working

    Stack Overflow | 4 years ago | Sören
    org.hibernate.exception.GenericJDBCException: could not execute statement
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    how to map Many to Many with composite key

    Stack Overflow | 1 year ago | user2529173
    org.hibernate.exception.LockTimeoutException: could not execute statement
  5. 0

    Migration From 6.2 GA2 7.0 GA2 - Forums | Liferay

    liferay.com | 10 months ago
    com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Incorrect string value: '\xEC\x84\xB8\xEA\xB3\x84...' for column 'name' at row 3
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

    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 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)

    at com.mysql.jdbc.MysqlIO.sendCommand()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
    2. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
    3. com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
    5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159)
    7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
    8 frames
  3. com.solarmetric.jdbc
    DelegatingPreparedStatement.executeUpdate
    1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
    2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeUpdate(PoolConnection.java:358)
    3. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
    4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
    5. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
    6. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:724)
    7. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
    7 frames
  4. 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
  5. 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
  6. reversetutorial
    Finder.main
    1. reversetutorial.Finder.executeCreatQuery(Finder.java:108)
    2. reversetutorial.Finder.main(Finder.java:44)
    2 frames