[OOZIE-1436] Revert SLA_XML and few other varchar columns back to clob

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Assignee: Virag Kothari
• Reporter: Virag Kothari
• Created: 27/Jun/13 08:00
• Updated: 31/Aug/13 00:02
• Resolved: 28/Jun/13 22:23

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