hi,

we use hibernate 2 with jboss datasources.
if there is a foreign-key conflict in the database while deleting some db-entries, jboss rolls back the transaction.
in our application i put session.delete(query) in a try and session.flush() in a finally block.

after rollback i get a StaleObjectStateException in session.flush().
can you help me to prevend this?

greetings from berlin, daniel.

The flush should not be in a finally block. flush() is what synchronizes the hibernate state with the db. After an exception, the session should no longer be used for anything other than closing it.