[OPENJPA-2601] 'hint' element in orm:xml is ignored

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.0, 2.4.0
• Fix Version/s: 2.4.1
• Component/s: criteria
• Assignee: Mark Struberg
• Reporter: Kariem Hussein
• Created: 20/Jul/15 18:20
• Updated: 10/Apr/21 19:27
• Resolved: 21/Jul/15 11:26

Description

It should be possible to set query hints in Java code, or in orm.xml, but it seems the orm:hint element is ignored.

The following two options should result in the same query:

1. Java only:

   em.createQuery("Select e from MyEntity e where e.type = 'literal'")
     .setHint(QueryHints.HINT_USE_LITERAL_IN_SQL, true)
     .getResultList()
   

2. Named query
   • Define the query and the hint in orm.xml

     <named-query name="Query1">
         <query>Select e from MyEntity e where e.type = 'literal'</query>   
         <hint name="openjpa.hint.UseLiteralInSQL" value="true" />
     </named-query>
     

   • And then call the query without additional information

     em.createNamedQuery("Query1")
       .getResultList()
     

However, (2) does not correctly take the query hint into account and thus literals are replaced with SQL positional parameters.

Issue Links

• links to: GitHub Pull Request #2
• links to: PR2: Correct element name for query hint in orm.xml parser