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

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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    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-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

          Activity

            People

            • Assignee:
              bjreed Barrett Jay Reed
              Reporter:
              bjreed Barrett Jay Reed

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment