Search Interview Questions
| More than 3000 questions in repository.|
There are more than 900 unanswered questions.
Click here and help us by providing the answer.
Have a video suggestion.
Click Correct / Improve and please let us know.
|Database - Interview Questions and Answers for 'Sqlintegrityconstraintviolationexception' - 1 question(s) found - Order By Newest|
|Ans. Application is unable to insert a record as it violates a unique constraint. |
The exception states the constraint and Table can be located by the Entity mapping. So I will go to the DB and will first check to which all columns the unique constraint applies. And then I will go and check the code and logs to see how come the duplicate column values were attempted to be inserted when they were not supposed to be.
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve  ConstraintViolationException  SQLIntegrityConstraintViolationException|
|What's the benefit for specifying constraints like Not Null , Primary Key explicitly instead of specifying it against the column ?|
|How to know the constraints on a Table in Oracle ?|