OpenJPA
  1. OpenJPA
  2. OPENJPA-2324

Option to express literal in query string directly into generate SQL

    Details

    • Patch Info:
      Patch Available

      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.

      1. OPENJPA-2324.trunk.patch
        9 kB
        Albert Lee
      2. OPENJPA-2324.10x.patch
        6 kB
        Albert Lee

        Issue Links

          Activity

          Albert Lee created issue -
          Albert Lee made changes -
          Field Original Value New Value
          Attachment OPENJPA-2324.10x.patch [ 12565498 ]
          Attachment OPENJPA-2324.trunk.patch [ 12565499 ]
          Albert Lee made changes -
          Fix Version/s 1.0.5 [ 12313777 ]
          Fix Version/s 1.2.3 [ 12314517 ]
          Fix Version/s 2.0.3 [ 12317143 ]
          Fix Version/s 2.1.2 [ 12317142 ]
          Fix Version/s 2.3.0 [ 12319463 ]
          Fix Version/s 2.2.2 [ 12323356 ]
          Fix Version/s 2.2.1.1 [ 12323484 ]
          Albert Lee made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Albert Lee made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Hide
          Matthew Rupert added a comment -

          Why is version 2.2.0 not listed in Fix Versions? Is this still an issue in 2.2.0?

          Show
          Matthew Rupert added a comment - Why is version 2.2.0 not listed in Fix Versions? Is this still an issue in 2.2.0?
          Hide
          Rick Curtis added a comment -

          2.2.0 was already been released when this fix was added to the 2.2.x branch. You can get the fix in the 2.2.2 release.

          Show
          Rick Curtis added a comment - 2.2.0 was already been released when this fix was added to the 2.2.x branch. You can get the fix in the 2.2.2 release.
          Heath Thomann made changes -
          Link This issue relates to OPENJPA-2534 [ OPENJPA-2534 ]
          Heath Thomann made changes -
          Link This issue is related to OPENJPA-2534 [ OPENJPA-2534 ]
          Heath Thomann made changes -
          Link This issue is related to OPENJPA-2534 [ OPENJPA-2534 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          81d 21h 49m 1 Albert Lee 10/Apr/13 14:46
          Resolved Resolved Closed Closed
          5s 1 Albert Lee 10/Apr/13 14:46

            People

            • Assignee:
              Heath Thomann
              Reporter:
              Albert Lee
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development