ORA-00001: 违反唯一约束条件

[xihaijh]

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插入的时候,报错,但是提交以后,还是插进去了,为什么啊?请高手指教,多谢啊..在线等.

[Well]

什么意思？？把具体的代码给贴出来

[xihaijh]

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');

就是我在插入这些数据的时候,报的一个错,但最后,提交完,后数据也插进了库里,这是怎么回事.我查过了,没有主键相同的.

[sangxiao]

你在表上面建立什么Check或其他条件了？
把具体的“ESEAL.PK_SYSTEM_PURVIEW”贴出来看看

[Liubinglin]

表上一定有个叫ESEAL.PK_SYSTEM_PURVIEW的约束哈，你可以查查DBA_CONSTRAINTS
DBA_CONS_COLUMNS来找出关联的字段

[ksxyoo]

小弟，目前也遇到了这个问题，大哥，你解决了没？
我的insert 语句为：
insert into tb_module_info(module_id,module_name,module_point,module_type,parent_id,data_type,module_url,module_desc,state,remark) values('30407','住院救助情况统计','816','0100','304','01000','cxtj/zyjztj/index.jsp','','1','');

[hyrongg]

你的表里面有个字段是unique，不能重复的，但你插入
语句里面。这个对应字段的值在表里面已经存在，
所以报违反唯一约束错误

[ksxyoo]

我的邮箱 [e-mail] 麻烦发个邮件给我！！

[utpcb]

本来就已经有咯！ 所以插不进去呢

[TasteCoffee]

你们这个不算，我的查询都报


List<Opter> opterlist=this.findByHQL("from "+Opter.class.getName()+" as p where p.departmentCode='"+dept.getCode()+"'");


ORA-00001: 违反唯一约束条件 (SYSTEM.SYS_C004118)

[javaCoffee33]

table 的 ＳＱＬ

[csjinshan]

1 INSERT INTO SCOTT.DEPT(DNAME,LOC,DEPTNO)
2* VALUES('OFFICE','HONGKONG',50)
SQL> /
INSERT INTO SCOTT.DEPT(DNAME,LOC,DEPTNO)
*
第 1 行出现错误:
ORA-00001: 违反唯一约束条件 (SCOTT.PK_DEPT)

[huangdh12]

插入部分，然后应该commit了 只提交了部分吧？

[huangdh12]

重复的并没有插入进去，而是插入了你那些不重复的。

[yangyang0804]

那是因为你重新又执行同一个插入语句了。其实只要没错，第一次插入就ok啦。然后虽然重复执行，但是最后select时，还是能够显示提交的数据了。就是这样。