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

problem inserting more than 4000 charcters in oracle XMLTYPE column

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • 2.2.1, 2.4.3, 3.0.0
    • 3.1.0
    • None
    • None

    Description

      In attachement an eclipse project with a testcase showing the problem.

      my table is created with :

      CREATE TABLE Message (id NUMBER NOT NULL,
      created TIMESTAMP,
      message VARCHAR2(255),
      XML_CONTENT XMLTYPE,
      PRIMARY KEY (id));

      My jdbc4 driver version is 11.2.0.4 (ojdbc6.jar)

      I tried to follow instructions mentioned here with no success : https://issues.apache.org/jira/browse/OPENJPA-1691?focusedCommentId=13086429&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13086429

      Thx

      Attachments

        1. XMLTypeTester.zip
          7 kB
          Nezih BEN FREDJ

        Issue Links

          Activity

            struberg Mark Struberg added a comment -

            I'm in the process of setting up a docker profile to run Oracle based tests much easier.
            Would you mind sharing which Oracle server version you run?

            struberg Mark Struberg added a comment - I'm in the process of setting up a docker profile to run Oracle based tests much easier. Would you mind sharing which Oracle server version you run?

            Our oracle server version is : 12.2.0.1

            nezih Nezih BEN FREDJ added a comment - Our oracle server version is : 12.2.0.1

            Commit aae0a95f6c8f38e0df18e5f538761ee502d9eb08 in openjpa's branch refs/heads/master from Mark Struberg
            [ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=aae0a95 ]

            OPENJPA-2761 properly handle javax.sql.Types.SQLXML

            jira-bot ASF subversion and git services added a comment - Commit aae0a95f6c8f38e0df18e5f538761ee502d9eb08 in openjpa's branch refs/heads/master from Mark Struberg [ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=aae0a95 ] OPENJPA-2761 properly handle javax.sql.Types.SQLXML
            struberg Mark Struberg added a comment -

            Hi nezih I've fixed a missing handling of SQLXML types. Seems Oracle12 handles this a bit different than older versions. Now our internal tests cover this and do pass it.
            Could you please verify? This needs the latest openjpa-3.0.1-SNAPSHOT. I will deploy it to our ASF snapshot repo when back home. Or you just build it yourself

            $> mvn clean install -Dsurefire.excludes.locking=**/*
            
            struberg Mark Struberg added a comment - Hi nezih I've fixed a missing handling of SQLXML types. Seems Oracle12 handles this a bit different than older versions. Now our internal tests cover this and do pass it. Could you please verify? This needs the latest openjpa-3.0.1-SNAPSHOT. I will deploy it to our ASF snapshot repo when back home. Or you just build it yourself $> mvn clean install -Dsurefire.excludes.locking=**/*
            struberg Mark Struberg added a comment -

            Resolving. Please reopen if your problem seems not to be covered by our fix - txs!

            struberg Mark Struberg added a comment - Resolving. Please reopen if your problem seems not to be covered by our fix - txs!

            People

              struberg Mark Struberg
              nezih Nezih BEN FREDJ
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: