Oracle主鍵異常處理

標籤：rate   date   cat   oracle主鍵   ror   stand   bsp   values   strategy   

Hibernate: insert into test1.WarnWeather (WAREA, wdate, WDAYS, WINFO, WTYPE, WNO) values (?, ?, ?, ?, ?, ?)
Hibernate: select weathers0_.WNO as WNO1_0_, weathers0_.WAREA as WAREA2_0_, weathers0_.wdate as wdate3_0_, weathers0_.WDAYS as WDAYS4_0_, weathers0_.WINFO as WINFO5_0_, weathers0_.WTYPE as WTYPE6_0_ from test1.WarnWeather weathers0_
Hibernate: insert into test1.WarnWeather (WAREA, wdate, WDAYS, WINFO, WTYPE, WNO) values (?, ?, ?, ?, ?, ?)
ERROR SqlExceptionHelper ORA-00001: 違反唯一約束條件 (TEST1.SYS_C0011549)

ERROR ExceptionMapperStandardImpl HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]

 

異常問題：

用戶端只能插入一條資料，當插入第二條資料時出現異常 ERROR SqlExceptionHelper ORA-00001: 違反唯一約束條件 (TEST1.SYS_C0011549)

 

原因：在實體類中沒有配置Oracle的id主鍵導致Oracle主鍵的衝突

 

解決方案：在實體類中添加註解的序列

//@GeneratedValue中generator裡面的值對應@SequenceGenerator中name裡面的值（可以隨便定義但一定要相同），
//sequenceName是建立的sequence名字（對應資料庫中建立的序列名），allocationSize表示序列自增長的大小為1
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="seq")
@SequenceGenerator(name="seq", sequenceName="SEQ_WEATHER",allocationSize = 1)

Oracle主鍵異常處理