[DDLUTILS-245] writeDataToFile produce broken XML

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.0
• Fix Version/s: 1.1
• Component/s: Core (No specific database)
• Environment: JRE 1.5 eclipse 3.4 ant 1.7.1
• Assignee: Thomas Dudziak
• Reporter: Nikolas Falco
• Created: 31/Mar/09 09:17
• Updated: 05/May/11 06:04
• Resolved: 05/May/11 06:04

Description

databaseToDdl ant task produces a broken XML output if column's name contains special characters.
Example of a table schema/data exported:

SCHEMA.XML
<table name="C_RE_FE4FB">
<column name="OID$" primaryKey="true" required="true" type="CHAR" size="35" autoIncrement="false"/>
..
<column name="TYPE$_MIMETY_28F8F" primaryKey="false" required="false" type="VARCHAR" size="256" autoIncrement="false"/>
..
</table>

DATA.XML (broken)
<C_RE_FE4FB OID$="8a8081c81f93c944011f93c9b1c4004b " .. TYPE$_MIMETY_28F8F="TEXT.Xml" C_MIMETYPE_M_8FBF9="text/xml" .. />
<C_RE_FE4FB OID$="8a8081c81f93c944011f93c9b752004f " .. TYPE$_MIMETY_28F8F="TEXT.Xml" C_MIMETYPE_M_8FBF9="text/xml" .. />

A little output log

[ddlToDatabase] Written schema to database
[ddlToDatabase] Parse Fatal Error at line 3 column 18: Attribute name "OID" associated with an element type "C_RE_FE4FB" must be followed by the ' = ' character.
[ddlToDatabase] org.xml.sax.SAXParseException: Attribute name "OID" associated with an element type "C_RE_FE4FB" must be followed by the ' = ' character.
[ddlToDatabase] at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanAttribute(XMLDocumentFragmentScannerImpl.java:1016)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:851)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
[ddlToDatabase] at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)

Should be change data.xml output format. Column name (as also table name) should be converted from attriute to value to avoid special characters.
Can become:
<table="C_RE_FE4FB" column1="OID$" value1="8a8081c81f93c944011f93c9b1c4004b " .. columnN="TYPE$_MIMETY_28F8F" valueN="TEXT.Xml" C_MIMETYPE_M_8FBF9="text/xml" .. />