Hi, guys,

I understand that Hibernates caches records that it already retrieved. Next time when it needs to retrieve a record, it looks for it in the cache first, if it's not in there, query the database.

How to force Hibernate to look for the record ONLY in the cache. If it's not in there, forget it, don't query the database.

My issue is that the record I query is not really existing. Even if Hibernate has cached all records, it still can't find it in the cache so it goes to query the database, which will degrade the performance.

Thanks.

George

Ah current Hibernate CVS keeps track of "failed loads", if thats what you are asking for.

Thanks for quick reply. My issue is that I don't know if a certain record is in the database so I do a find query. If that record is not really existing in the database, hibernate can never find it in the cache, so it goes to query the database. If I unfortunately has a loop of 100 times, hibernate can't find the record in the cache so it will query the database 100 times. Is there a way to force hibernate to query the cache only. If it's not in the cache, forget it, don't query the database, just return null.

Thanks.

A query? As in HQL?

I am using someting like
session.find("from Symbol as rst where id =?");

where ? equals say, 10. For some reason, for instance, I have a loop of 100 times on this but id#10 is not really in the database, so

for(int i = 0; i < 100; i++)
session.find("from Symbol as rst where id =?");

will query the database 100 times. Is that right?

ummm yeees. of course.

In 2.1, you *could* use the query cache. But that would be a workaround for what looks like just a bad application design.

I have a similar problem:
In a Web application i want to retrieve an object from the cache after a session reconnect.
I dont want to reload the object from the database, but I forgot the reference and want only to retrieve it from the id.
New with hibernate, may be I miss something !
Thanks

so, use the second-level (jcs) cache.