Hi all,


From application, I have a collection of objects where i am trying to delete object by object by checking some condition. Suppose there are more than 100 objects in loop, every time it has to go to DB server and delete each object, so a lot of trips. The problem is, application is getting stuck after deleting all, probably because of attempting all deletes in a single transaction, so the app can’t commit the transactions until it has too much to cope with. so finally it is rolling back.

DB server is : MS SQL server.

Please suggest.
thanking you in advance,

illi.

Basically you have 2 options, none of them too attractive.
The first is to manually write a native SQL query.
The second (preferable?) is to set your database to CASCADE DELETE, and configure your Hibernate mappings accordingly.

I wrote an article here discussing those 2 approaches in detail, with code examples.

Hi,

Thanks for your repl
I will explain more clearly now,

Objects obj[]=new Objects[100... more];
for(n=0;n<obj.length;n++){
session.delete(obj[n]); // object has children.
}

My code is like above. here object has too many children. of course session.delete will cascade all its children. Actually i tried to use a native query to delete all of them, but it wont do cascading part it seems. it was simply throwing error as it has children undeleted. Can' I delete complete array in a single call.

I mean, anything that works like session.delete(collection/array);

or is flush usefule here?

Thanks again,
illi