You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Albert Lee (JIRA)" <ji...@apache.org> on 2013/01/18 18:04:13 UTC

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

     [ https://issues.apache.org/jira/browse/OPENJPA-2324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Albert Lee updated OPENJPA-2324:
--------------------------------

    Attachment: OPENJPA-2324.trunk.patch
                OPENJPA-2324.10x.patch
    
> Option to express literal in query string directly into generate SQL
> --------------------------------------------------------------------
>
>                 Key: OPENJPA-2324
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2324
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: kernel, sql
>    Affects Versions: 2.1.2, 2.3.0, 2.2.2
>            Reporter: Albert Lee
>            Assignee: Heath Thomann
>            Priority: Minor
>         Attachments: OPENJPA-2324.10x.patch, OPENJPA-2324.trunk.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira