How can we solve the DataIntegrityViolationException in Spring Hibernate?

I am 开发者_如何学Cusing 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?

---

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?

---

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.

---

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.

---

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

---

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 .