Is there a way to use hibernate to do a "quick delete"? The behavior I would like is to issue a delete query (and not have hibernate load up the object first, and then delete it), as well as have the option to rollback the deletes if something goes wrong.

The problem is, if there are many objects, or the objects are very large, issuing multiple delete() commands and storing them in the session cache until the transaction is committed may not be feasible. I just want to be able to delete the object and then get it out of memory. Any thoughts?

I've done some additional testing, and I'm not sure this is even possible... I think Hibernate is loading up the object to do dependency checking. Does this need to happen even if cascade = NONE? Any comments are welcome.

Use direct JDBC for deleting without loading first, this is not possible with Hibernate - this has also been discussed numerous times already in this forum.

Thanks for your reply.

I thought that might be the case. I did search the forums, but nothing relevent turned up. Thanks again.