com.solarmetric.jdbc.ReportingSQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 3.0.0RC2 MappingTool producing bad SQL
    via by 3004,
  • Kodo v4.0.0EA2 Bugs List
    via by 3004,
  • Webstart Issue
    via by 3004,
  • XA error
    via by 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] at kodo.jdbc.meta.MappingTool.record(MappingTool.java:431) at kodo.jdbc.meta.MappingTool.run(MappingTool.java:832) at kodo.jdbc.meta.MappingTool.main(MappingTool.java:729) Caused by: 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) ... 2 more
    No Bugmate found.