我想删除
delete from BATCH_JOB_EXECUTION where JOB_INSTANCE_ID=18380;
但是我收到以下错误。这是特定于春季批处理的
Error starting at line : 1 in command - delete from BATCH_JOB_EXECUTION where JOB_INSTANCE_ID=18380 Error report - ORA-02292: integrity constraint (XXX.JOB_EXEC_PARAMS_FK) violated - child record found
我也看
CREATE TABLE "XXX"."BATCH_JOB_EXECUTION"
( "JOB_EXECUTION_ID" NUMBER(19,0) NOT NULL ENABLE,
"VERSION" NUMBER(19,0),
"JOB_INSTANCE_ID" NUMBER(19,0) NOT NULL ENABLE,
"CREATE_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"START_TIME" TIMESTAMP (6) DEFAULT NULL,
"END_TIME" TIMESTAMP (6) DEFAULT NULL,
"STATUS" VARCHAR2(10 BYTE),
"EXIT_CODE" VARCHAR2(2500 BYTE),
"EXIT_MESSAGE" VARCHAR2(2500 BYTE),
"LAST_UPDATED" TIMESTAMP (6),
"JOB_CONFIGURATION_LOCATION" VARCHAR2(2500 BYTE),
CONSTRAINT "PK_BATCH_JOB_EXECUTION" PRIMARY KEY ("JOB_EXECUTION_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "XXX_STD_TBL" ENABLE,
SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,
SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
SUPPLEMENTAL LOG GROUP "GGS_766075" ("JOB_EXECUTION_ID") ALWAYS,
CONSTRAINT "JOB_INST_EXEC_FK" FOREIGN KEY ("JOB_INSTANCE_ID")
REFERENCES "XXX"."BATCH_JOB_INSTANCE" ("JOB_INSTANCE_ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "XXX_STD_TBL" ;
请参阅 https://docs.spring.io/spring-batch/3.0.x/reference/html/metaDataSchema.html，您将看到与子记录的链接。
只需删除相关的子记录 1st，然后您可以删除父记录。.