File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes constraint violation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "constraint violation" Watch "constraint violation" New topic

constraint violation

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
I am getting a constraint violation when inserting a record in a table.
So, I dropped the constraint in question since the intent is to be able to insert multiple records.

alter table table_name drop constraint constrain_Name

I look at the list of constraints for the table in question, the constraint has been dropped.

Still I cannot insert the record: same constraint violation comes up.

ANy ideas ?

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
dropping the corresponding index resolved the issue
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

There are SQL commands you can perform to insert with the constraint disabled and then re-enable it after the insert. It's not generally a good practice, though, and I only use for bulk restoring of a database, ergo restoring 20 tables with thousands of records in a single script.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: constraint violation
It's not a secret anymore!