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

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: