Two Laptop Bag*
The moose likes JDBC and the fly likes exception related to data constraint Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "exception related to data constraint" Watch "exception related to data constraint" New topic

exception related to data constraint

Raj Ohadi
Ranch Hand

Joined: Jun 30, 2006
Posts: 316
For a table that has "unique index" constraint --- for example the table has 10 columns. One of them is PK, I add another constraint that the combination of 5 columns has to be unique. Then when I use JDBC to insert a row, if it violates this constraint, what kind exception will be thrown ? will it be a regular SQL Exception or what ?

how do I know it is caused by this particular problem when an exception is thrown ?
I agree. Here's the link:
subject: exception related to data constraint
Similar Threads
trigger to check if a row can be inserted or not
Pimary keys in entity beans
OJB and Unique Keys
Hibernate: How to delete mapping table
JDO issue