[ 
https://issues.apache.org/jira/browse/DELTASPIKE-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15302449#comment-15302449
 ] 

Amita Mehta commented on DELTASPIKE-1157:
-----------------------------------------

Would prefer if this works. This way all the queries in the repository look the 
same.
 @Override
    @Query(hints = {@QueryHint(name = "javax.persistence.cache.retrieveMode",
        value = "BYPASS"), @QueryHint(name = "eclipselink.refresh",
            value = "TRUE")})
    public ENTITY findBy(PK primaryKey);

The second preference would be number 3

> Repository.findBy methods do not allow an override to add query hints.
> ----------------------------------------------------------------------
>
>                 Key: DELTASPIKE-1157
>                 URL: https://issues.apache.org/jira/browse/DELTASPIKE-1157
>             Project: DeltaSpike
>          Issue Type: New Feature
>          Components: Data-Module
>    Affects Versions: 1.5.3
>            Reporter: Amita Mehta
>            Assignee: John D. Ament
>
> We need a way to to add hints or a property override to the findBy methods 
> for the primary key to prevent reading stale data .
> We tried overriding the findBy with query hints but these are ignored by the 
> DelatSpike Data Module EntityRepositoryHandler .
> {code}
>     @Override
>     @Query(hints = {@QueryHint(name = "javax.persistence.cache.retrieveMode",
>         value = "BYPASS"), @QueryHint(name = "eclipselink.refresh",
>             value = "TRUE")})
>     public ENTITY findBy(PK primaryKey);
> {code}
> The only thing that works is creating a custom query in the repository that 
> uses override properties –
> {code}
>    public AgentDE findByPK(final String primaryKey) {
>         final Map<String, Object> properties = new HashMap<String, Object>();
>         properties.put("QueryHints.CACHE_USAGE", CacheUsage.DoNotCheckCache);
>         properties.put("eclipselink.refresh", "true");
>         
> entityManager().getEntityManagerFactory().getCache().evict(entityClass(), 
> primaryKey);
>         entityManager().clear();
>         return entityManager().find(entityClass(), primaryKey, properties);
>     }
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to