Kariem Hussein created OPENJPA-2601: ---------------------------------------
Summary: 'hint' element in orm:xml is ignored Key: OPENJPA-2601 URL: https://issues.apache.org/jira/browse/OPENJPA-2601 Project: OpenJPA Issue Type: Bug Components: criteria Affects Versions: 2.4.0, 2.3.0 Reporter: Kariem Hussein 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: # Java only: {code:java} em.createQuery("Select e from MyEntity e where e.type = 'literal'") .setHint(QueryHints.HINT_USE_LITERAL_IN_SQL, true) .getResultList() {code} # Named query #- Define the query and the hint in orm.xml {code: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> {code} #- And then call the query without additional information {code:java} em.createNamedQuery("Query1") .getResultList() {code} However, (2) does not correctly take the query hint into account and thus literals are replaced with SQL positional parameters. -- This message was sent by Atlassian JIRA (v6.3.4#6332)