[OPENJPA-2169] TestOracleXmlColumn test failed using Oracle 11.2 driver

• Type: Test
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.2.0, 2.3.0
• Fix Version/s: 2.2.1, 2.3.0
• Component/s: jdbc
• Assignee: Albert Lee
• Reporter: Albert Lee
• Created: 02/Apr/12 20:55
• Updated: 03/Apr/12 18:18
• Resolved: 03/Apr/12 18:18

Description

TestOracleXmlColumn test failed using Oracle 11.2 driver.

In Oracle 10, if xml data in a flat string stored in a xml column

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"></project>

when retrieve from the db, it returns the exact format. However in Oracle 11.2, the string is reformatted to:

<?xml version="1.0" encoding="UTF-8"?>\n
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"/>\n