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]

Oracle Community | 3004 | 1 decade ago
  1. 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]
  2. 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]
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 0

    Parameters for POSTGRESQL kodo.jdbc.DBDictionary

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "(" {stmnt 16398807 CREATE TABLE public.WFMSGCONTAINER (jdoid int8(8) NOT NULL, PRIMARY KEY (jdoid))} [code=0, state=42601] [refresh]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

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

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingStatement.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)
      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: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:790)
      3. kodo.jdbc.meta.MappingTool.main(MappingTool.java:729)
      3 frames