In our application I am working on a module wherein we allow user to delete the records from the database. They can select records to delete or just delete everything. The number of records could be more than 500000.
Here is part of the attachment.hbm.xml
Here is the code in the dao.
1. Is it the right way to delete huge number of records?
2. I get the following exception when I execute the above code.
ERROR org.hibernate.util.JDBCExceptionReporter - The DELETE statement conflicted with the REFERENCE constraint "FK_assignment_attachment". The conflict occurred in database "mydb", table "dbo.assignment", column 'att_id'.
Could someone provide me insights for this?
It runs on an internal combustion engine. This ad does not:
the new thread boost feature brings a LOT of attention to your favorite threads