[jboss-jira] [JBoss JIRA] (AS7-3257) Second Level Cache and Query Cache not working

[Zbyněk Roubalík (JIRA)]

    [ https://issues.jboss.org/browse/AS7-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655358#comment-12655358 ] 

Zbyněk Roubalík commented on AS7-3257:
--------------------------------------

Scott,

I made 2 types of this tests, first using EntityManager[1] and second Hibernate Session[2].
* Entity 2LC works on both, but when using Session it is necessary to read entity name, address, etc. to see cache hit/miss count in statistics. When using EntityManager, we don't have to do this step, cache statistics are updated correctly, weird.

* Issues with query cache (both types):
  1. If query cache is invalidated in a session, it is never restored again, - method  invalidateQuery()
  2. Eviction of query cache is not working, when calling method sessionFactory.getCache().evictQueryRegions() - method evictQueryCacheCheck()

Any suggestions? Thanks.

[1] https://github.com/zroubalik/jboss-as/commit/e84648ddb3ab2042cb58b4d49026aa5e2803c480
[2] https://github.com/zroubalik/jboss-as/commit/4602b686fe511c87118ad65cdafd828eca08ad96
                
> Second Level Cache and Query Cache not working 
> -----------------------------------------------
>
>                 Key: AS7-3257
>                 URL: https://issues.jboss.org/browse/AS7-3257
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: JPA / Hibernate
>    Affects Versions: 7.1.0.CR1
>            Reporter: Zbyněk Roubalík
>            Assignee: Zbyněk Roubalík
>             Fix For: 7.1.0.Final
>
>
> I've created tests for Hibernate Second Level Cache, at this moment they are failing, because Statistics don't give expected results (mostly hit and miss count).
> In these tests 2LC, Query cache and Hibernate statistics are enabled, cache region  has got correct name (putCount gives some numbers).
> I'm not sure if there is a bug in my tests (but they looks good to me) or bug in Hibernate Statistics or in 2LC cache.
> Tests are in my github repo in 2lcTests branch:
> Test case: [SecondLevelCacheTestCase.java|https://github.com/zroubalik/jboss-as/blob/0aebdd10c62c195cd92d57bc9c324e014b8aef22/testsuite/integration/basic/src/test/java/org/jboss/as/test/integration/jpa/secondlevelcache/SecondLevelCacheTestCase.java], which calls SFSB: [SFSB2LCSessionFactory.java|https://github.com/zroubalik/jboss-as/blob/0aebdd10c62c195cd92d57bc9c324e014b8aef22/testsuite/integration/basic/src/test/java/org/jboss/as/test/integration/jpa/secondlevelcache/SFSB2LCSessionFactory.java]

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira