CODEWITHSUNDEEP
hibernatespring
Naresh
Naresh

Reputation: 243

How can we solve the DataIntegrityViolationException in Spring Hibernate?

I am using Spring Hibernate with HibernateSupportDao, when I try to send multiple rows of data to store in my db, it raises a DataIntegrityViolationException at a particular row. The same scenario has worked in remain in task on the same table. I do not get the problem even when I use the same code for the current task. Why was a DataIntegrityViolationException thrown and how can I rectify that?

Upvotes: 9

Views: 98971

Answers (5)

Grigory Kislin
Grigory Kislin

Reputation: 18000

I treat DataIntegrityViolationException in ExceptionInfoHandler, finding DB constraints occurrences in root cause message and convert it into i18n message via map. See code here: https://stackoverflow.com/a/42422568/548473

//  https://stackoverflow.com/a/65442410/548473
@NonNull
private static Throwable getRootCause(@NonNull Throwable t) {
  Throwable rootCause = NestedExceptionUtils.getRootCause(t);
  return rootCause != null ? rootCause : t;
}

Upvotes: 1

hvgotcodes
hvgotcodes

Reputation: 120198

Directly from the API:

Exception thrown when an attempt to insert or update data results in violation of an integrity constraint. Note that this is not purely a relational concept; unique primary keys are required by most database types.

Basically it means that Hibernate tried to do something, but the database raised an exception. Most common case might be that you are deleting a parent, but not deleting a child with a foreign key to that parent.

What are your transitive persistence (i.e. cascade) settings?

Upvotes: 11

Deep Shah
Deep Shah

Reputation: 198

if you import database from somewhere then you have to take data folder of server too , and change this data folder to your server's data folder .

Upvotes: 0

Thirdman
Thirdman

Reputation: 709

DataIntegrityViolationException can also be violating a unique constraint on the database (i.e. a alternate key). Check, if your inserted data rows contain duplicate data that is violating such a unique constraint.

Upvotes: 2

sampath
sampath

Reputation: 41

When you encounter this exception when selecting some fields from the table, then the reason could be the length of the one of the fields in the select statement. check for all the select field lengths and compare it with the table description. any field would have violated the field restriction.

Upvotes: 4

Related Questions