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]

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 - 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]
  2. 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]

    Root Cause Analysis

    1. 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]

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