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]

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 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]
  2. 0

    Mappingtool - sybase don't know about CMD_LINE

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: Can't specify a length or scale on type 'CMD_LINE'. [mappingtool] {stmnt 26357574: CREATE TABLE ORDER0 (JDOCLASS CMD_LINE(255) NULL , JDOID NUMERIC(38) NOT NULL, JDOVERSION INT NULL, ORDERDATE DATETIME NULL, ORDE RNO CMD_LINE(255) NULL, STATE INT NULL, SUBTOTAL FLOAT(32) NULL, UNQ_INDEX NUMER IC IDENTITY UNIQUE, CONSTRAINT P_ORDER PRIMARY KEY (JDOID))} [code=2716, state=Z ZZZZ] [mappingtool]

    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 ')) 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]

      at kodo.jdbc.meta.MappingTool.record()
    2. kodo.jdbc.meta
      MappingTool.run
      1. kodo.jdbc.meta.MappingTool.record(MappingTool.java:518)[mappingtool]
      2. kodo.jdbc.meta.MappingTool.run(MappingTool.java:912)
      2 frames