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
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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]

    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