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]


Solutions on the web40

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
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]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 month ago
Syntax error or access violation, message from server: "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 '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 month ago
Syntax error or access violation, message from server: "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 ')) TYPE = innodb' at line 1" {stmnt 29477163 CREATE TABLE

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
Syntax error or access violation, message from server: "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 'OTHER)' at line 1" {stmnt 30301818: CREATE TABLE TestServiceKeyArray (keyArray BIGINT, parent VARCHAR(255), seqno OTHER)} [code=1064, state=42000]

Solution icon of oraclecommunity
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 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE

Solution icon of oraclecommunity
Syntax error or access violation, message from server: "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 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 month ago
Unknown column 'Infinity' in 'field list' {prepstmnt 10808772 INSERT INTO variablesimple (ACTIVITYID, DIMENSION, IDENTIFIER, JDOID, MAXVALUE, MINVALUE, NAME0, SUCCESSIVEVALUES_JDOID, VARIATIONMODE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=1054, state=42S22]

Solution icon of oraclecommunity
ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
ORA-02019: can't find the connection description {prepstmnt 10 INSERT INTO QUAKEGAO@TEST (JDOCLASS, JDOVERSION, NAME0, OID, PWD) VALUES (?, ?, ?, ?, ?)} [code=2019, state=]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
, TELEFONNR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(int) 1, (String) m.horstmann@yahoo.de , (String) 04941 183742, (int) 12761, (int) 1, (int) 1, (String) 0171 2846751, (String) Oldenburg, (int) 12760, (String) 26129, (int) 1, (null) null, (String) Ammerl__nder Heerstra__e 19, (String) 04941 183740] [reused=0]} [code=2291, state=23000]

Stack trace

  • 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(LoggingConnectionDecorator.java:124) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:728) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362) at kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1716) at kodo.jdbc.runtime.PreparedStatementManager.flushInternal(PreparedStatementManager.java:235) at kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:206) at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:220) at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:95) at kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:614) at kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:153) at kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:1159) at kodo.runtime.PersistenceManagerImpl.flushSafe(PersistenceManagerImpl.java:1042) at kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:969) at kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69) at kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:629) at reversetutorial.Finder.executeCreatQuery(Finder.java:108) at reversetutorial.Finder.main(Finder.java:44)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.