Hi,
I have a problem with hibernate cache.
The best way to explain will be following example:
I have a query :
which return 0.
In other thread and other session i adding new User, so database User table contains 1 user record, although when i one more time make a query:

I got still 0 but i should got 1.

Is any way to clear query result, which was cached as I guess ?
By the way - If i call query only one time, then i got 1, but because I made this query earlier hibernate cached one and I got 0 again.

Thanks for any help.

Because nobody didn't ask for my question I would like to explain what the problem was.
So, this problem was caused not by hibernate cache, but by REPEATABLE READ isolation transaction level on database.
the first query see current data and every next query see the snapshot made by first query, not a current value (if the query is still in the same transaction).