kodo.util.GeneralException: 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 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE TABLE EXTERNALREFERENCE (AC VARCHAR(255), DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION INTEGER, PRIMARY KEY P_EXTERNALREFERENCE (JDOID)) TYPE = innodb} [code=1064, state=42000]

Oracle Community | 3004 | 1 decade ago
  1. 0

    MappingTool error with Mysql and class with member field called "database".

    Oracle Community | 1 decade ago | 3004
    kodo.util.GeneralException: 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 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE TABLE EXTERNALREFERENCE (AC VARCHAR(255), DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION INTEGER, PRIMARY KEY P_EXTERNALREFERENCE (JDOID)) TYPE = innodb} [code=1064, state=42000]
  2. 0

    mappingtool generates bad DDL for sybase (J2ee tutorial)

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: 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]
  3. 0

    requires-extent="false" problem

    Oracle Community | 1 decade ago | 3004
    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 ')) TYPE = innodb' at line 1" {stmnt 29477163 CREATE TABLE BANNERNUMBER (JDOCLASS VARCHAR(255), JDOVERSION INTEGER, CONSTRAINT P_BANNERNUMBER PRIMARY KEY ()) TYPE = innodb} [code=1064, state=42000] [mappingtool]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    3.0.0RC2 MappingTool producing bad SQL

    Oracle Community | 1 decade ago | 3004
    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]
  6. 0

    3.0.0RC2 MappingTool producing bad SQL

    Oracle Community | 1 decade ago | 3004
    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]

    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 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE TABLE EXTERNALREFERENCE (AC VARCHAR(255), DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION INTEGER, PRIMARY KEY P_EXTERNALREFERENCE (JDOID)) TYPE = innodb} [code=1064, state=42000]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingStatement.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$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:586)
      4. com.solarmetric.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:125)
      4 frames
    3. kodo.jdbc.schema
      SchemaTool.add
      1. kodo.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1179)
      2. kodo.jdbc.schema.SchemaTool.createTable(SchemaTool.java:926)
      3. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:425)
      4. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:256)
      4 frames
    4. kodo.jdbc.meta
      MappingTool.run
      1. kodo.jdbc.meta.MappingTool.record(MappingTool.java:458)
      2. kodo.jdbc.meta.MappingTool.run(MappingTool.java:944)
      2 frames
    5. kodo.jdbc.ant
      MappingToolTask.executeOn
      1. kodo.jdbc.ant.MappingToolTask.executeOn(MappingToolTask.java:192)
      1 frame
    6. com.solarmetric.ant
      TaskBase.execute
      1. com.solarmetric.ant.TaskBase.execute(TaskBase.java:105)
      1 frame
    7. Ant
      Main.main
      1. org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
      2. org.apache.tools.ant.Task.perform(Task.java:364)
      3. org.apache.tools.ant.Target.execute(Target.java:301)
      4. org.apache.tools.ant.Target.performTasks(Target.java:328)
      5. org.apache.tools.ant.Project.executeTarget(Project.java:1215)
      6. org.apache.tools.ant.Project.executeTargets(Project.java:1063)
      7. org.apache.tools.ant.Main.runBuild(Main.java:632)
      8. org.apache.tools.ant.Main.startAnt(Main.java:183)
      9. org.apache.tools.ant.Main.start(Main.java:147)
      10. org.apache.tools.ant.Main.main(Main.java:230)
      10 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    9. IDEA
      AntMain2.main
      1. com.intellij.rt.ant.execution.AntMain2.main(AntMain2.java:13)
      1 frame