Primary key issue in insert a table into SQlServer database

5 次查看(过去 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!

采纳的回答

Guillaume
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:
  • 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.
  1 个评论
MEP
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 CenterFile Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by