aspose file tools*
The moose likes JDBC and the fly likes Delete Command failed: No Unique row for the Matching Condition Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Delete Command failed: No Unique row for the Matching Condition" Watch "Delete Command failed: No Unique row for the Matching Condition" New topic
Author

Delete Command failed: No Unique row for the Matching Condition

Rajahari Kannan
Greenhorn

Joined: Nov 14, 2013
Posts: 8
Hi Guys,

Yesterday i was creating a database in derby using netbeans ide. There was nearly 60 records in a table. By mistake after entering all data , i clicked the ok button 2-3 times and now there are nearly 180 records instead of 60 records. Is there any way to eliminate those unwanted records. i Cannot Delete Those Records which are unwanted.

Error Occurred : "Delete Command failed: No Unique row for the Matching Condition"

Please Help Me..

regards,
Rajahari Kannan
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 10360
    
    8

If it is your code which generates the records from scratch, I would say the easiest way is to delete the DB from the disk and start over again


[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
Rajahari Kannan
Greenhorn

Joined: Nov 14, 2013
Posts: 8
Hi Maneesh,

I was entering details manually using the netbeans ide. But its ok, i have started my work from first. Thanks for your help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Delete Command failed: No Unique row for the Matching Condition