aspose file tools*
The moose likes JDBC and the fly likes how to recognize integrity constraint from exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to recognize integrity constraint from exception" Watch "how to recognize integrity constraint from exception" New topic
Author

how to recognize integrity constraint from exception

Tanvi Narula
Greenhorn

Joined: Sep 30, 2008
Posts: 9
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

Joined: Apr 14, 2004
Posts: 10336

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?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Tanvi Narula
Greenhorn

Joined: Sep 30, 2008
Posts: 9
Thanks Paul for the quick reply

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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to recognize integrity constraint from exception