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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

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]
via Oracle Community by 3004, 1 year ago
Can't specify a length or scale on type 'IndexName'. {stmnt 7576378: CREATE TABLE CAR (COLOR IndexName(255) NULL, JDOCLASS IndexName(255) NULL, JDOID NUMERIC(38) NOT NULL, JDOVERSION INT NULL, MAKE IndexName(255) NULL, MODEL IndexName(255) NULL, YEAR0 IndexName(255) NULL, UNQ_INDEX NUMERIC I DENTITY UNIQUE, CONSTRAINT P_CAR PRIMARY KEY (JDOID))} [code=2716, state=ZZZZZ]
via Oracle Community by 3004, 1 year ago
Can't specify a length or scale on type 'CMD_LINE'. [mappingtool] {stmnt 26357574: CREATE TABLE ORDER0 (JDOCLASS CMD_LINE(255) NULL , JDOID NUMERIC(38) NOT NULL, JDOVERSION INT NULL, ORDERDATE DATETIME NULL, ORDE RNO CMD_LINE(255) NULL, STATE INT
via Oracle Community by 3004, 1 year ago
ERROR: syntax error at or near "(" {stmnt 16398807 CREATE TABLE public.WFMSGCONTAINER (jdoid int8(8) NOT NULL, PRIMARY KEY (jdoid))} [code=0, state=42601] [refresh]
via Oracle Community by 3004, 4 months 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
via Oracle Community by 3004, 4 months 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 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE
com.solarmetric.jdbc.ReportingSQLException: 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]
at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:67)
at com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19)
at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:506)
at kodo.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1042)
at kodo.jdbc.schema.SchemaTool.createTable(SchemaTool.java:803)
at kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:334)
at kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:186)
at kodo.jdbc.meta.MappingTool.record(MappingTool.java:364)
at kodo.jdbc.meta.MappingTool.run(MappingTool.java:832)
at kodo.jdbc.meta.MappingTool.main(MappingTool.java:729)

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.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.