- remove the constraint on the primary key. Most likely a bad idea.
- do not try to add duplicate rows. Instead you can UPDATE the rows in question.
Primary key issue in insert a table into SQlServer database
2 次查看(过去 30 天)
显示 更早的评论
Don't know why but keep getting this error: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__ANLS_SCO__DDF02C0878DED853'. Cannot insert duplicate key in object '********'. The duplicate key value is (Mar 13 2017 12:00AM, Jun 1 2017 12:00AM).
I have no clue why this is happening because yesterday I used insert and fastinsert on another table without any problem.
Thanks for any help!
0 个评论
采纳的回答
Guillaume
2017-3-15
编辑:Guillaume
2017-3-15
I'm not sure what is not clear about the error. As it says, you're trying to add a row whose value for the primary key already exists in the table and you have a constraint on the table that the primary key must be unique.
In other words, you already have a row whose primary key value is (Mar 13 2017 12:00AM, Jun 1 2017 12:00AM). Your table schema forbids you to add another row with that same key.
Two possible solutions:
1 个评论
MEP
2022-1-26
Yes, but how can I set the clause if I want to update the row without overwriting the primary key?
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Migrate GUIDE Apps 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!