Filter löschen
Filter löschen

Primary key issue in insert a table into SQlServer database

15 Ansichten (letzte 30 Tage)
JFz
JFz am 15 Mär. 2017
Kommentiert: MEP am 26 Jan. 2022
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!

Akzeptierte Antwort

Guillaume
Guillaume am 15 Mär. 2017
Bearbeitet: Guillaume am 15 Mär. 2017
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 Kommentar
MEP
MEP am 26 Jan. 2022
Yes, but how can I set the clause if I want to update the row without overwriting the primary key?

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by