How can i add a QueryHint to a Hibernate Custom Query?

Asked Nov 18 '19 at 13:10

Active Nov 18 '19 at 13:22

Viewed 723 times

I'm trying to add the Oracle Query Hint /*+ GATHER_PLAN_STATISTICS PARALLEL(16) */ to my Custom Query which looks similar to this:

@Query("SELECT " +
      " FROM myTable tab " +
      " WHERE tab.create_date >= to_date(:dateFrom) " +
      " AND tab.create_date < to_date(:dateTo)")
List<MyModel> findEntriesByDate( @Param("dateFrom") String dateFrom, @Param("dateTo") String dateTo);

I cannot find any way to make this work. I tried various things, for example adding this on top of the method:

@QueryHints({
            @QueryHint(name = org.hibernate.annotations.QueryHints.COMMENT, value = "GATHER_PLAN_STATISTICS")
    })

@QueryHints({
            @QueryHint(name = GATHER_PLAN_STATISTIC, value = "GATHER_PLAN_STATISTICS")
    })

Is there a way to make this work or do I have to change my approach?

edited Nov 18 '19 at 13:22

asked Nov 18 '19 at 13:10

EyedPeas

@BobJarvis sorry, that was a mistake while coppying. – EyedPeas Nov 18 '19 at 13:22
De nada. Is there a reason you can't put the hint-comment into the SQL, as it looks like you're passing a complete query anyways? – Bob Jarvis - Слава Україні Nov 18 '19 at 13:26
Spring Boot throws an exception if I include the hint-comment in the sql.. – EyedPeas Nov 18 '19 at 13:38

How can i add a QueryHint to a Hibernate Custom Query?

0 Answers0