I need to add a simple bulk delete to an existing Hibernate-enabled app.

If I use SQLQueryImpl.executeUpdate() to do this, I assume that it is completely out of the context of an existing session, and has no effect on an existing session.

Is that correct?

Assuming auto-commit is on in my DB, I should see the DELETE committed immediately, correct?

Thanks,
Wes

P. S. If there's some "cool" Hibernate way to delete multiple records with one delete statement via the API, I couldn't find it. If such a method exists, please enlighten me.

As fas as I know, SQLQueryImpl won't let you execute updates or deletes of mapped entities.
For those, an HQL like "delete from MyClass" will do.

use HQL batch deletes as shown.


that said native SQL queries also supports doing deletes/updates if you want.

....but do remeber if your sesssion has objects that you delete/modify with these bulk QL statements will be out of sync and cascading will not be applied..hence the best thing is to do this as the first thing when using the session before you load anything.