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]


Solutions on the web38

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
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]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
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

Solution icon of oraclecommunity
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]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
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]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 month ago
BANNERNUMBER (JDOCLASS VARCHAR(255), JDOVERSION INTEGER, CONSTRAINT P_BANNERNUMBER PRIMARY KEY ()) TYPE = innodb} [code=1064, state=42000]

Solution icon of oraclecommunity
.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
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]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
, TELEFONNR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(int) 1, (String) m.horstmann@yahoo.de , (String) 04941 183742, (int) 12761, (int) 1, (int) 1, (String) 0171 2846751, (String) Oldenburg, (int) 12760, (String) 26129, (int) 1, (null) null, (String) Ammerl__nder Heerstra__e 19, (String) 04941 183740] [reused=0]} [code=2291, state=23000]

Solution icon of oraclecommunity
ORA-01407: cannot update ("CS2"."OBLIGATION"."CONTRACT_ID") to NULL {prepstmnt 12985263 UPDATE CS2.OBLIGATION SET CONTRACT_ID = ?, MODIFICATION_ID = ? WHERE CONTRACT_ID = ? AND MODIFICATION_ID = ? [params=(null) null, (null) null, (long) 130, (int) 2]} [code=1407, state=72000]

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
Missing IN or OUT parameter at index:: 2 {prepstmnt 31469867 DELETE FROM CATADMIN.PLATE_DATASETLISTX WHERE DATASETLISTX = ? AND JDOIDX = ? [params=(long) 9147124] [reused=1]} [code=17041, state=null]

Stack trace

  • 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 kodo.jdbc.meta.MappingTool.record(MappingTool.java:431) at kodo.jdbc.meta.MappingTool.run(MappingTool.java:790) at kodo.jdbc.meta.MappingTool.main(MappingTool.java:729)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.