Hi Guys,

I have an application that has a parent table and many child and grandchild tables. They are all related by keys.

When I clear all the contents of a collection ( which is the data of one child table and its associated children ) each row in the table, and child table is deleted individually, and this takes an absolute age as there can be 50-150,000 rows of data.



public boolean process_price(HSSFRow row, DATAImpl data, boolean clear, Hashtable messages, String currentSchema, Hashtable columnIndexes) throws Exception {
try {
// grab the list
List list = data.getPRICE();
if (clear) {
list.clear();
}
PRICE object = (PRICE) this.objectFactory.createPRICE();


Is there some clever way to clear the contents of a collection without doing individual deletes on all rows and then all related rows in child tables ?

e.g. one delete statement for each table, or a special cascade delete.

Thanks

Paul.

Not in Hibernate, I don't think no.


Maybe write a JDBC method to do that? >_>

Search the documentation, it's called "one shot delete for collections".

And of course it only works conceptually and in practice for collections of value types (strings, dates, components), not for a parent/child entity relationship.

Hi ,
The way out I can think of is like
Remove all the constraints at the DB level.At Hibernate level you can remove the cascade constraints.
The way out is manage them at the application level.

Ans you can have a scheduled script that removes the non refrenced rows in the child table .

Thanks guys, I will try these suggestions out.

I was looking a month for a solution for this problem. Search did not work because the terms are too usual.