为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
执行execute发生异常
[Message:] 违反列[codeid]非空约束
with nested exception:
违反列[codeid]非空约束
已经存在的表:CREATE TABLE
(
"CODEID" INT AUTO_INCREMENT NOT NULL,
"CODENAME" VARCHAR(100),
"LEVNUM" INT,
"ORDERNUMBER" INT,
"CATEGORYNUM" VARCHAR(50),
"DESCRIPTION" VARCHAR(200),
"ISFROMSOA" INT,
"I18NKEY" VARCHAR(200),
"BASEOUGUID" VARCHAR(50),
"APPGUID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("CODEID")) STORAGE(ON "YF1B_ZWFW_JCSL8_2_0", CLUSTERBTR) AUTO_INCREMENT = 1016144;
CREATE INDEX "IDX_CODE_MAIN_CODENAME" ON "YF1B_ZWFW_JCSL8_2_0"."CODE_MAIN"("CODENAME" ASC) STORAGE(ON "YF1B_ZWFW_JCSL8_2_0", CLUSTERBTR) ;
SET IDENTITY_INSERT CODE_MAIN on
CREATE TABLE "CODE_MAIN1"
(
"CODEID" INT identity(1,1) NOT NULL,
"CODENAME" VARCHAR(100),
"LEVNUM" INT,
"ORDERNUMBER" INT,
"CATEGORYNUM" VARCHAR(50),
"DESCRIPTION" VARCHAR(200),
"ISFROMSOA" INT,
"I18NKEY" VARCHAR(200),
"BASEOUGUID" VARCHAR(50),
"APPGUID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("CODEID"));
insert INTO "CODE_MAIN1"(CODENAME) values('2222');
commit;
2个解决办法:
1、insert语句要指定列
2、改用序列的方式