[OPENJPA-2324] Option to express literal in query string directly into generate SQL

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.2, 2.2.2, 2.3.0
• Fix Version/s: 1.2.3, 2.0.2, 2.1.2, 2.2.2, 2.2.1.1, 2.3.0
• Component/s: kernel, sql
• Patch Info: Patch Available
• Assignee: Heath Thomann
• Reporter: Albert Lee
• Created: 18/Jan/13 16:57
• Updated: 21/Sep/16 14:37
• Resolved: 10/Apr/13 14:46

Description

Literals in query string is translated into parameters in generate SQL string. This has the advantage of query statement caching but in some use case performance will suffer.

This is a request to provide a query hints to by-pass setting it as parameter but generate the literal in-line into the generated SQL statement for better performance.

Issue Links

• relates to: OPENJPA-2534 A boolean is not converted correct when using the hint 'UseLiteralInSQL'.