[jira] [Updated] (DELTASPIKE-1157) Repository.findBy methods do not allow an override to add query hints.

["John D. Ament (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DELTASPIKE-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John D. Ament updated DELTASPIKE-1157:
--------------------------------------
    Fix Version/s: 1.6.2

> 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
>             Fix For: 1.6.2
>
>
> 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)