Uploaded image for project: '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. Text File
            OPENJPA-2324.10x.patch
            6 kB
            Albert Lee
          2. Text File
            OPENJPA-2324.trunk.patch
            9 kB
            Albert Lee

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. OPENJPA-2534 A boolean is not converted correct when using the hint 'UseLiteralInSQL'.

            • Critical - Crashes, loss of data, severe memory leak.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              mrupert 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
              mrupert 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
              Permalink
              curtisr7 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
              curtisr7 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.

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Development