Hi all,
I can't find a proper way to check if a record on db has be deleted.

I have a simple mapped class, with no parent, childs, collections.. just simple properties.
I want simply have a method that check if a particular entity is still on db or not (a row can be deleted from another application or from the db administrator, for example).

I'm using this code:



The code always retrieve the row even if it's deleted from db..
I tried to work with the cache, using clear(), or to evict the zipFile and to load() or get() the entity with the previously retrieved id.. always the entity is retrieved.

What i'm doin wrong?
Thanks in advance.

Hi,

the query will returns null if no row(s ) exist,check whether you have committed modifications (deleting a row in db),then changes of db will reflects to your application.

Hi,

the problem is that it doesn't return null, even if the row in the db doesn't exist anymore (yep the transaction is committed).
Seems that hibernate is using its cache, and I can't figure out how to force a reload from the db.

Thanks.

Use OpenSession() instead of getSession().

Don't forget to commit ur Transaction and use explicit transaction object.

Truncate ur DB.

Use evict(),flush() & close() methods on session and also use evict() method on SessionFactory.

**) Do u delete record of ur ZipFile from Hibernate or SQL? if u delete record from hibernate, commit ur transaction.