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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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