[OPENJPA-1691] Oracle XMLType column failed to insert/update when xml contains more than 4000 characters

• Type: Bug
• Status: Closed
• Priority: 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
• Labels: openjpa oracle xmltype
• Environment: Oracle 10g, JDBC driver (ojdbc14.jar) 10.2.0.4.0, OpenJPA 1.2.2
• Assignee: Milosz Tylenda
• Reporter: Kelvin Law
• Created: 10/Jun/10 17:31
• Updated: 07/Dec/18 16:24
• Resolved: 27/Jul/11 18:39

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

Issue Links

• is duplicated by: OPENJPA-1839 TestXMLCustomerOrder failed against Oracle with "ORA-01461: can bind a LONG value only for insert into a LONG column"