- 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
9 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Akzeptierte Antwort
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:
1 Kommentar
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?
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!