JAva.sql.S c u l i n t e g r i t y C o nstraintViolationException:ORA-00001:一意制約違反(BIM.PK_METERUSER_ID)nrn##

956 ワード

エラーメッセージ:
Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001:          (BIM.PK_METERUSER_ID)
\r
### The error may exist in com/bim/dao/UnityMeterUserManageMapper.java (best guess)\r
### The error may involve com.bim.dao.UnityMeterUserManageMapper.insert-Inline\r
### The error occurred while setting parameters\r
### SQL: INSERT INTO METER_USER_INFO ( METER_USER_ID, METER_USER_NAME, COMPANY_NAME, USE_POSITION, CONTACTER, CONTACT_PHONE, BUILDING_UID, FLOOR_UID, USE_AREA ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )\r
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: (BIM.PK_METERUSER_ID)

; ORA-00001: (BIM.PK_METERUSER_ID)
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: (BIM.PK_METERUSER_ID)
"

なぜなら、プライマリ・キー・データが重複し、
解決策:データベースとは異なるデータの追加を設定する