Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to recognize integrity constraint from exception

 
Tanvi Narula
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

This topic was discussed long... back, where it was mentioned there is no way to recognize which integrity constraint occured when you get "MysqlIntegrityConstraintViolationException" in your code.

I am raising it again in the hope that some answer might be there now

I am using mysql with java and I have to generate custom messages when some DB exception occurs. While inserting or updating data , I need to generate separate message for duplicate key violation and foreign key violation on receiving
MysqlIntegrityConstraintViolationException
exception

Can anybody suggest the best way to do it ?

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC just reports what the database server tells it when something goes wrong. You will need to interpret the error code associated with the exception if there is one or worst case parse the message.

However, if this is because of an insert or update I would not expect the user to ever hit an integrity constraint violation exception. Should your busness and dao logic not be creating valid data for them?
 
Tanvi Narula
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Paul for the quick reply

I guess I will have to parse the exception ...

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic