insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
*
ERROR 位于第 1 行:
ORA-00001: 违反唯一约束条件 (ESEAL.PK_SYSTEM_PURVIEW)
我在SQL*PLUS插入的时候,报错,但是提交以后,还是插进去了,为什么啊?请高手指教,多谢啊..在线等.
*
ERROR 位于第 1 行:
ORA-00001: 违反唯一约束条件 (ESEAL.PK_SYSTEM_PURVIEW)
我在SQL*PLUS插入的时候,报错,但是提交以后,还是插进去了,为什么啊?请高手指教,多谢啊..在线等.
insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('89502', '1', 'qz004001', '个人用户管理', null, null, '1', null, null, '0013002001', '0013002', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('89503', '1', 'qz004002', '单位用户管理', null, null, '1', null, null, '0013002002', '0013002', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('89505', '1', 'xt001', '系统管理', null, null, '1', null, null, '0013', '0', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('89504', '1', 'qz005', '管理员管理', null, null, '1', null, null, '0013003', '0013', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('895', '1', 'qz000', '印章管理', null, null, '1', null, null, '0014', '0', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('896', '1', 'qz001', '个人印章管理', null, null, '1', null, null, '0014001', '0014', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('897', '1', 'qz002', '单位公章管理', null, null, '1', null, null, '0014002', '0014', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('898', '1', 'qz003', '印章查询', null, null, '1', null, null, '0014003', '0014', '1');insert into SYSTEM_PURVIEW (SP_FLOWNO, SYSTEM_FLOWNO, SYSTEM_PURVIEW_CODE, SYSTEM_PURVIEW_NAME, SYSTEM_PURVIEW_DESCRIBE, SYSTEM_PURVIEW_URL, SYSTEM_PURVIEW_STATE, SP_DEFAULT1, SP_DEFAULT2, SYSTEM_PURVIEW_NUM, SYSTEM_PURVIEW_UPNUM, SYSTEM_PURVIEW_VIEW)
values ('88', '1', 'tc000', '退出', null, null, '1', null, null, '1000', '0', '1');就是我在插入这些数据的时候,报的一个错,但最后,提交完,后数据也插进了库里,这是怎么回事.我查过了,没有主键相同的.
把具体的“ESEAL.PK_SYSTEM_PURVIEW”贴出来看看
我的insert 语句为:
insert into tb_module_info(module_id,module_name,module_point,module_type,parent_id,data_type,module_url,module_desc,state,re) values('30407','住院救助情况统计','816','0100','304','01000','cxtj/zyjztj/index.jsp','','1','');
语句里面。这个对应字段的值在表里面已经存在,
所以报违反唯一约束错误
DBA_CONS_COLUMNS来找出关联的字段
List<Opter> opterlist=this.findByHQL("from "+Opter.class.getName()+" as p where p.departmentCode='"+dept.getCode()+"'");
ORA-00001: 违反唯一约束条件 (SYSTEM.SYS_C004118)
2* VALUES('OFFICE','HONGKONG',50)
SQL> /
INSERT INTO SCOTT.DEPT(DNAME,LOC,DEPTNO)
*
第 1 行出现错误:
ORA-00001: 违反唯一约束条件 (SCOTT.PK_DEPT)