Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-1436

Revert SLA_XML and few other varchar columns back to clob

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      None

      Description

      OOZIE-1398 converts few columns from clobs to varchar(4000). But there seems to be problem where (@lenght=4000) annotation is not working and trying to insert more than 1000 chars throws ORA-24816 with Oracle. Though it seems a oracle problem from the error code, it is actually not as trying to do a direct insert with more than 1000 chars in Oracle works. Also openjpa does map to varchar2(4000) when creating schema. But somehow openjpa only accepts upto 1000 chars and nothing more when trying to insert.
      Have posted on openjpa user list with no reply yet. Thread at http://openjpa.208410.n2.nabble.com/ORA-24816-column-ordering-during-inserts-td7584233.html
      This jira will revert sla_xml and data varchar columns back to clob

        Attachments

        1. OOZIE-1436.patch
          16 kB
          Virag Kothari

          Activity

            People

            • Assignee:
              virag Virag Kothari
              Reporter:
              virag Virag Kothari
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: