Hello,

I would like to know how to reset/clear Hibernate QueryCache?

I've found the method clear() into QueryCache class, but I do not know how to call it from a Session or a SesssionFactory?

Thanks and regards

Samuel

In Hibernate, all important things are done on your instance of Session.
Maybe you'll find a there, too ;-)

Optionally, what about closing and opening a new one ?

Cheers, Tom.

Here is was is written on

http://www.hibernate.org/hib_docs/refer ... batch.html

"clear() the session regularly, to control the size of the first-level cache."

but what i would like is to clear the second level of cache (not the 1st level)

so how to do this?

regards

Samuel

This shud help.

http://forum.springframework.org/showthread.php?t=29691

Regards

Sam

Thanks for this tip

I've also written the following

public static void evictEntity(String schemaName, String entityName) {
getSessionFactory(schemaName).evictEntity(entityName);
}

public static void evictQueries(String schemaName) {
getSessionFactory(schemaName).evictQueries();
}

@SuppressWarnings("unchecked")
public static void evictAll(String schemaName) {
evictQueries(schemaName);
Map metadata = getSessionFactory(schemaName).getAllClassMetadata();
for (Iterator i = metadata.values().iterator(); i.hasNext(); ) {
ClassMetadata classMetadata = (ClassMetadata) i.next();
evictEntity(schemaName, classMetadata.getEntityName());
}
}