I am evaluating Alachisoft's Ncache as a 2nd level cache with NH 1.04.

I have noticed an unusual problem: When using the criteria API, the query results are being cached and are not refreshed from the database even when the criteria changes. When I set the "use_query_cache" to false, it works fine.

So is this a problem with Ncache or Nhibernate. Where should I look?


Thanks

It's quite easy to tell - try using a different provider (HashtableCacheProvider for example), and see what happens.

This could be related to the problem that I noticed last week where certain cache providers do not store the query cache in the same regions. The problem is mentioned here http://forum.hibernate.org/viewtopic.php?t=971664

Hi. I have the same problem but using query and SysCache. I have something like:


"...From Adi A Where A.Contract = :contract and A.Id = :id"


:contract is an object
:id is a long

Even changing the object contract I get the same result from the cache.

If I turn off the 2nd level cache it works.
If I use A.Contract.Id = :contractId it works.

Is this a bug in my code?

Thanks.