OpenJPA
  1. OpenJPA
  2. OPENJPA-1691

Oracle XMLType column failed to insert/update when xml contains more than 4000 characters

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.2, 2.0.0, 2.0.1
    • Fix Version/s: 1.2.3, 1.3.0, 2.0.2, 2.1.0
    • Component/s: sql
    • Environment:
      Oracle 10g, JDBC driver (ojdbc14.jar) 10.2.0.4.0, OpenJPA 1.2.2

      Description

      Oracle throws the following exception when XML content is greater than 4000 characters:
      ORA-01461: can bind a LONG value only for insert into a LONG column

      1. OPENJPA-1691_2.0.x.patch
        12 kB
        Jeremy Bauer
      2. OPENJPA-1691.1.2.x.patch
        11 kB
        Jeremy Bauer

        Issue Links

          Activity

          Kelvin Law created issue -
          Milosz Tylenda made changes -
          Field Original Value New Value
          Assignee Milosz Tylenda [ milosz ]
          Milosz Tylenda made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Milosz Tylenda made changes -
          Affects Version/s 2.0.1 [ 12314532 ]
          Affects Version/s 2.0.0 [ 12314019 ]
          Component/s sql [ 12311310 ]
          Milosz Tylenda made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 2.1.0 [ 12314542 ]
          Resolution Fixed [ 1 ]
          Milosz Tylenda made changes -
          Link This issue is duplicated by OPENJPA-1839 [ OPENJPA-1839 ]
          Michael Dick made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jeremy Bauer made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Jeremy Bauer made changes -
          Attachment OPENJPA-1691.1.2.x.patch [ 12480131 ]
          Jeremy Bauer made changes -
          Attachment OPENJPA-1691_2.0.x.patch [ 12485482 ]
          Jeremy Bauer made changes -
          Attachment OPENJPA-1691.1.2.x.patch [ 12485487 ]
          Jeremy Bauer made changes -
          Attachment OPENJPA-1691.1.2.x.patch [ 12480131 ]
          Michael Dick made changes -
          Fix Version/s 1.2.3 [ 12314517 ]
          Fix Version/s 1.3.0 [ 12313326 ]
          Fix Version/s 2.0.2 [ 12315257 ]
          Michael Dick made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]

            People

            • Assignee:
              Milosz Tylenda
              Reporter:
              Kelvin Law
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development