Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:


<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate</artifactId>
<version>3.2.6.ga</version>
</dependency>

<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-annotations</artifactId>
<version>3.3.0.ga</version>
</dependency>

<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>3.3.1.ga</version>
</dependency>

Mapping documents:
Done with JPA
Code between sessionFactory.openSession() and session.close():
Spring handled
Full stack trace of any exception that occurs:
NA
Name and version of the database you are using:
Mysl
The generated SQL (show_sql=true):
NA?
Debug level Hibernate log excerpt:
The problem are that my queries always miss even when they are identical(or I believe they are).


I've enable querycache and second level cache and are using ehcache, I've set the this criteria.setCacheable(true). I am using the criteria API. I have not configured ehcache.xml or similar (defaults should be okay right?)

First startup messages from hibernate:

Then the first hit (should all be misses)


Second hit should have some hits
[code]
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id5_0_, this_.version as version5_0_, this_.translatableName as translat3_5_0_ from ExerciseCategory this_; parameters: ; transformer: org.hibernate.transform.RootEntityResultTransformer@2be51c
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [ExerciseCategory]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for ExerciseCategory
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id3_0_, this_.version as version3_0_, this_.nameLatin as nameLatin3_0_, this_.nameTrivial as nameTriv4_3_0_, this_.translatableName as translat5_3_0_ from BodyPart this_; parameters: ; transformer: org.hibernate.transform.RootEntityResultTransformer@2be51c
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [BodyPart]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for BodyPart
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 1, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 2, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 3, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 4, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 5, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 6, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 7, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 8, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 9, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 10, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select count(*) as y0_ from Exercise this_ where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 11, true, ; transformer: org.hibernate.transform.PassThroughResultTransformer@294acb
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 1, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 2, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 3, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 4, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 5, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 6, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 7, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLatin3_0_, bodypart2_.nameTrivial as nameTriv4_3_0_, bodypart2_.translatableName as translat5_3_0_, person3_.id as id8_1_, person3_.version as version8_1_, person3_.address as address8_1_, person3_.alias as alias8_1_, person3_.birthDate as birthDate8_1_, person3_.browser as browser8_1_, person3_.defaultExerciseType as defaultE7_8_1_, person3_.email as email8_1_, person3_.gotNewMail as gotNewMail8_1_, person3_.height as height8_1_, person3_.joined as joined8_1_, person3_.lastLogin as lastLogin8_1_, person3_.loggedIn as loggedIn8_1_, person3_.logins as logins8_1_, person3_.name as name8_1_, person3_.password as password8_1_, person3_.payingUserUntilDate as payingU17_8_1_, person3_.picture as picture8_1_, person3_.sexType as sexType8_1_, person3_.userExpertiseType as userExp20_8_1_, person3_.userType as userType8_1_, person3_.validated as validated8_1_, person3_.wantsNewsMail as wantsNe23_8_1_, weightlist4_.person_id as person9_6_, weightlist4_.id as id6_, weightlist4_.id as id10_2_, weightlist4_.version as version10_2_, weightlist4_.caloriInTake as caloriIn3_10_2_, weightlist4_.date as date10_2_, weightlist4_.fatProcentage as fatProce5_10_2_, weightlist4_.person_id as person9_10_2_, weightlist4_.unit as unit10_2_, weightlist4_.weight as weight10_2_, weightlist4_.weightMorning as weightMo8_10_2_, exerciseca5_.id as id5_3_, exerciseca5_.version as version5_3_, exerciseca5_.translatableName as translat3_5_3_ from Exercise this_ left outer join BodyPart bodypart2_ on this_.bodyPart_id=bodypart2_.id left outer join PERSON person3_ on this_.creator_id=person3_.id left outer join Weight weightlist4_ on person3_.id=weightlist4_.person_id inner join ExerciseCategory exerciseca5_ on this_.category_id=exerciseca5_.id where this_.category_id=? and this_.bodyPart_id=? and this_.validated=?; parameters: zeuzgroup.core.exercise.ExerciseCategory has id 1, zeuzgroup.core.BodyPart has id 8, true, ; transformer: org.hibernate.transform.DistinctRootEntityResultTransformer@a35e48
DEBUG [btpool0-1] (StandardQueryCache.java:156) - Checking query spaces for up-to-dateness: [Exercise]
DEBUG [btpool0-1] (MemoryStore.java:138) - org.hibernate.cache.UpdateTimestampsCacheCache: org.hibernate.cache.UpdateTimestampsCacheMemoryStore miss for Exercise
DEBUG [btpool0-1] (Cache.java:661) - org.hibernate.cache.UpdateTimestampsCache cache - Miss
DEBUG [btpool0-1] (StandardQueryCache.java:117) - returning cached query results
DEBUG [btpool0-1] (StandardQueryCache.java:102) - checking cached query results in region: org.hibernate.cache.StandardQueryCache
DEBUG [btpool0-1] (MemoryStore.java:135) - org.hibernate.cache.StandardQueryCacheCache: org.hibernate.cache.StandardQueryCacheMemoryStore hit for sql: select this_.id as id6_4_, this_.version as version6_4_, this_.average as average6_4_, this_.uuid as uuid6_4_, this_.votes as votes6_4_, this_.bodyPart_id as bodyPart25_6_4_, this_.calorieConsumption as calorieC6_6_4_, this_.created as created6_4_, this_.creator_id as creator24_6_4_, this_.category_id as category26_6_4_, this_.exerciseType as exercise8_6_4_, this_.forceType as forceType6_4_, this_.front as front6_4_, this_.instructionComment as instruc11_6_4_, this_.instructionExecution as instruc12_6_4_, this_.instructionPreparation as instruc13_6_4_, this_.mechanicsType as mechani14_6_4_, this_.name as name6_4_, this_.referenceUrl as referen16_6_4_, this_.side as side6_4_, this_.translatableInstructionComment as transla18_6_4_, this_.translatableInstructionExecution as transla19_6_4_, this_.translatableInstructionPreparation as transla20_6_4_, this_.translatableName as transla21_6_4_, this_.utilityType as utility22_6_4_, this_.validated as validated6_4_, bodypart2_.id as id3_0_, bodypart2_.version as version3_0_, bodypart2_.nameLatin as nameLat

I decided to try out one of the spring modules for caching, and it worked out of the box..

And since I dont seem to get replies on this, i'll just continue to use the non intrusive spring approach.


https://springmodules.dev.java.net/docs ... troduction

Any news ? I'm experiencing the same problem

Could you post your HQL query?
Does it use entities as named parameters?
Is your issue similar to what I described in http://forum.hibernate.org/viewtopic.php?t=990520 ?

I you find my post helpful, please grant me some credits. Thanks

Hi Bertrand

Yes it seems similar, but in my scenario I actually did not run into different sessions. And first I used parameters (using criteria api), when it did'nt work I instead created the query manually as JPQL.


But its even stuff like this that fails:

public List<BodyPart> findBodyParts() {
Criteria criteria = getHibernateSession().createCriteria(BodyPart.class);
criteria.setCacheable(true);
return (List<BodyPart>) criteria.list();
}

Seems to be very basic stuff.. But as other times I find the criteria api to be very fragile, like when doing pagination how the distinct entities are sorted out afterwards..

hello

I got there as well.
It's because the entities you use as named parameters do not implement hashcode and equals using a business key.

Let me know if this solves your problem.

Ioannis Cherouvim

Does not seem to be true, bodypart extends baseentity which implements equals and hashcode:

public boolean equals(final Object o) {
if (this == o)
return true;
if (o == null || getClass() != o.getClass())
return false;

if (id == null)
return false;

final BaseEntity other = (BaseEntity) o;
if (!id.equals(other.id))
return false;

return true;
}

public int hashCode() {
HashCodeBuilder builder = new HashCodeBuilder();
builder.append(id);

return builder.toHashCode();

}


from org.apache.commons.lang.builder.HashCodeBuilder;