ORA-00001: unique constraint (CONTRACT_MGR.PK_T_SUPPLIER) violated
来源:互联网 发布:mac向iphone传照片 编辑:程序博客网 时间:2024/05/21 01:47
开发的系统,今天客户反馈新增数据(插入到oracle)失败。检查日志,报错为:
ORA-00001: unique constraint (CONTRACT_MGR.PK_T_SUPPLIER) violated
就是新增数据的主键值与数据库里面的数据重复了。
程序使用的是hibernate框架,用hibernate中的save() 方法来直接往数据库中插入数据。
主键生成策略为:
<id name="supplierId" type="long"> <column name="supplierId" precision="22" scale="0" /> <generator class="sequence"> <param name="sequence">SEQ_T_SUPPLIER</param> </generator> </id>
检查之后,发现是前一天在数据库中直接insert大批数据,导致数据库中的sequence SEQ_T_SUPPLIER 没有相应更新。今天通过sequence来自动生成主键的时候,就生成了重复的主键值。修改数据库中的sequence起始值为当前的最大的主键id值+1即可。
如图:
阅读全文
0 0
- ORA-00001: unique constraint (CONTRACT_MGR.PK_T_SUPPLIER) violated
- ORA-00001: unique constraint (.......) violated
- ORA-00001 unique constraint (string.string) violated
- ORA-00001: unique constraint (XINNET20100422.PK_T_THEME_ORDER) violated
- ORA-00001: unique constraint (...) violated解决方案
- Statspack ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决
- ORA-00001 unique constraint violated错误的解决 (
- ORA-00001: unique constraint violated并不一定是主键冲突
- ORA-00001: unique constraint (...) violated并不一定是数据冲突
- ORA-00001: unique constraint (...) violated并不一定是数据冲突
- impdp ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
- ORA-00001: unique constraint (...) violated并不一定是数据冲突
- java.sql.BatchUpdateException: ORA-00001: unique constraint (IEVSP.PK_C_CSERVICES) violated
- ORA-00001 : Unique Constraint Violated Caused by DATE VS Timestamp(6)
- ORA-00001: unique constraint pk_****_key violated oracle imp 语句导入数据对oracle的数据字段操作顺序
- ORA-02292:integrity constraint(xx) violated
- ORA-02291: integrity constraint (INFORES_GZ_PJ2.FK_TC_DEV_PROPERTY_GRP_PROID) violated - parent key
- Swift reason: 'attempt to insert row 10 into section 0, but there are only 10 rows in section
- solr 4.9 suggest.txt词库默认应该是utf-8 无BOM文档
- Google Maps基础及实例解析
- DNS Query Code in C with linux sockets
- showModelessDialog新窗口跳转问题
- ORA-00001: unique constraint (CONTRACT_MGR.PK_T_SUPPLIER) violated
- spark的checkpoint
- java笔试题
- 使用ajaxfileupload.js实现ajax异步上传
- 02.java语言基础-引出变量
- 计算广告学习笔记 4.1竞价广告系统-位置拍卖理论
- java的DatagramSocket和DatagramPackage
- namenode启动报错:There appears to be a gap in the edit log. We expected txid 1, but got txid 16
- Kotlin的hello world