Could it be that using the ORDER BY clause in queries disables caching for these queries completely?

I am experiencing relatively harmless queries like "FROM users ORDER BY name" missing any cache and accessing the DB every time.

I have configured ehcache for second level and switched on the query cache. Each class of my object model has got the "nonstrict-read-write" cache property set.

Regards,

Andreas

Are you really using query caching? Enabling the class level cache by default does not cache any query results at all - you must explicitly enable query caching.

I have enabled

<property name="cache.use_query_cache">true</property>

and have added

* @hibernate.cache usage="nonstrict-read-write"

to the XDoclet class level tags of every persistent class. EHCache is configured by default. Log messages reveal that both EHCache and Query Caches are being initialized.

Here is my statement:

FROM GameInvitation AS i
WHERE i.user = ?
AND i.game.status = 'forming'
ORDER BY game_id

I am executing it with the following code

List results = session.createQuery(hql).setCacheable(true).setParameter(0, user, Hibernate.entity(User.class)).list();

On consecutive invocations (in different Sessions, maybe thats the problem) with the same parameter (user), I always get the following SQL output:

Hibernate: select gameinvita0_.id as id, gameinvita0_.game_id as game_id, gameinvita0_.user_name as
user_name from game_invitations gameinvita0_, games game1_ where (gameinvita0_.user_name=? )AND(game
1_.status='forming' and gameinvita0_.game_id=game1_.id) order by game_id

Is there anything I have forgotten?

Regards,

Andreas

woops ... ignore this

Sometimes it takes a certain delay before the query cache can be utilized (due to the timestamping scheme)