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

        Issue Links

          Activity

          B.J. Reed created issue -
          B.J. Reed made changes -
          Field Original Value New Value
          Attachment OPENJPA-975.patch [ 12401967 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975.patch [ 12401968 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975.patch [ 12401967 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975b.patch [ 12402046 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975.patch [ 12401968 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975doc.patch [ 12402047 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975b.patch [ 12402048 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975b.patch [ 12402046 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975c.patch [ 12402403 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975b.patch [ 12402048 ]
          Jody Grassel made changes -
          Attachment OPENJPA-975c_1.0.x.patch [ 12402667 ]
          Michael Dick made changes -
          Fix Version/s 1.2.2 [ 12313681 ]
          Fix Version/s 1.2.0 [ 12313102 ]
          Michael Dick made changes -
          Attachment OPENJPA-975c_1.0.x.patch [ 12403839 ]
          Michael Dick made changes -
          Fix Version/s 1.0.4 [ 12313301 ]
          B.J. Reed made changes -
          Attachment OPENJPA-975-trunk.patch [ 12404163 ]
          Michael Dick made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Milosz Tylenda made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Michael Dick made changes -
          Assignee B.J. Reed [ bjreed ] Michael Dick [ mikedd ]
          Michael Dick made changes -
          Assignee Michael Dick [ mikedd ] B.J. Reed [ bjreed ]
          Milosz Tylenda made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Milosz Tylenda made changes -
          Link This issue is related to OPENJPA-976 [ OPENJPA-976 ]
          Donald Woods made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Milosz Tylenda made changes -
          Link This issue relates to OPENJPA-2282 [ OPENJPA-2282 ]

            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