Hi!

I try to do the following:

1. Delete table 'category':
currentSession.createQuery("delete from Catalog").executeUpdate()

2. Re-insert Category data:
currentSession.save(new Catalog(pk));

I get this exception:



Obviously, Hibernate doesn't realize that I deleted all catalogs in step 1, and still has category instances in its cache.
I try to flush() after each step, evict() and refresh() the new catalog, whithout success. When I try to refresh() the new catalog to make Hibernate aware that it does not exist in the DB anmore, I get

All of this is executed in a single session in a single transaction, since it is a nightly DB import. I use hibernate-3.1.3.

Any solutions?

Ok, I have done some research and now I know that Hibernate does not delete entitites from its session when they are deleted with HQL mass deletes.

I am now doing the deletion with a ScrollableResults, deleting every entity one by one, which works but sucks.
The sessions evict() method only accepts single entitites, and the SessionFactories mass evict facilities only affect the 2nd level cache, so those methods are no solution.

Is there a workaround? I figure there must be one, since this is probably a common usecase...