OpenJPA
  1. OpenJPA
  2. OPENJPA-975

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.0, 1.3.0, 2.0.0-M2
    • Fix Version/s: 1.0.4, 1.2.2, 1.3.0, 2.0.0-M2
    • Component/s: jdbc
    • Labels:
      None
    • Environment:
      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.

      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
        B.J. Reed
      4. OPENJPA-975doc.patch
        2 kB
        B.J. Reed
      5. OPENJPA-975-trunk.patch
        12 kB
        B.J. Reed

        Issue Links

          Activity

            People

            • Assignee:
              B.J. Reed
              Reporter:
              B.J. Reed
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development