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

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.3
• Fix Version/s: 1.7.0
• Component/s: Data-Module
• Assignee: John D. Ament
• Reporter: Amita Mehta
• Created: 26/May/16 16:40
• Updated: 19/Jun/16 23:09
• Resolved: 01/Jun/16 22:40

Description

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 .

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

The only thing that works is creating a custom query in the repository that uses override properties –

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

    }