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

["Marvin Toll (JIRA)" <ji...@apache.org>]

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

Marvin Toll commented on DELTASPIKE-1157:
-----------------------------------------

If this is not going to work:

 @Override
    @Query(hints = {@QueryHint(name = "javax.persistence.cache.retrieveMode",
        value = "BYPASS"), @QueryHint(name = "eclipselink.refresh",
            value = "TRUE")})
    public ENTITY findBy(PK primaryKey);

It would be helpful if a runtime exception were thrown indicating query hints are ignored; thus avoiding (in this case) stale data being delivered to the customer.

> 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)