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]

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

    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]

    Root Cause Analysis

    1. 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()
    2. com.solarmetric.jdbc
      LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:67)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:506)
      3 frames
    3. kodo.jdbc.schema
      SchemaTool.add
      1. kodo.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1042)
      2. kodo.jdbc.schema.SchemaTool.createTable(SchemaTool.java:803)
      3. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:334)
      4. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:186)
      4 frames
    4. kodo.jdbc.meta
      MappingTool.main
      1. kodo.jdbc.meta.MappingTool.record(MappingTool.java:364)
      2. kodo.jdbc.meta.MappingTool.run(MappingTool.java:832)
      3. kodo.jdbc.meta.MappingTool.main(MappingTool.java:729)
      3 frames