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

    • 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-975-trunk.patch
          12 kB
          Barrett Jay Reed
        2. OPENJPA-975doc.patch
          2 kB
          Barrett Jay Reed
        3. OPENJPA-975c.patch
          13 kB
          Barrett Jay Reed
        4. OPENJPA-975c_1.0.x.patch
          14 kB
          Jody Grassel
        5. OPENJPA-975c_1.0.x.patch
          13 kB
          Michael Dick

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment