Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-975

Oracle needs ability to not have an escape character for search strings.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.2.0, 1.3.0, 2.0.0-M2
    • 1.0.4, 1.2.2, 1.3.0, 2.0.0-M2
    • jdbc
    • None
    • Oracle

    Description

      Oracle application has a JPQL query that attempts to set a parameter to '\'. '\' is not a reserved character with Oracle and the query will work if you execute it "normally" with JDBC.

      OpenJPA automatically adds ESCAPE ('\') to every search SQL query. As a result the \ is interpreted as an escape indicator and the SQL will not execute as expected.

      Attachments

        1. OPENJPA-975c_1.0.x.patch
          13 kB
          Michael Dick
        2. OPENJPA-975c_1.0.x.patch
          14 kB
          Jody Grassel
        3. OPENJPA-975c.patch
          13 kB
          Barrett Jay Reed
        4. OPENJPA-975doc.patch
          2 kB
          Barrett Jay Reed
        5. OPENJPA-975-trunk.patch
          12 kB
          Barrett Jay Reed

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. OPENJPA-976 Research the need for escape charaters for LIKE in various DB's

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. OPENJPA-2282 ESCAPE '\' is appended to the like clause unexpectedly

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bjreed Barrett Jay Reed
              bjreed Barrett Jay Reed
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: