[GENERAL] Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files

[Bob Moyers]

I have this table:
CREATE TABLE REPORT_STYLE (
    REPORT_STYLE_NAME VARCHAR(75) NOT NULL,
    REPORT_STYLE_VERSION NUMERIC(8,0) NOT NULL,
    UPDATE_TS TIMESTAMP NOT NULL,
    UPDATE_USER_NAME VARCHAR(30) NOT NULL,
    STYLE_DESCR VARCHAR(200),
    JASPER_STYLE XML
);
ALTER TABLE REPORT_STYLE ADD CONSTRAINT PK_RPTSTY PRIMARY KEY 
(REPORT_STYLE_NAME);


And this document (notice the <!DOCTYPE):

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperTemplate PUBLIC "-//JasperReports//DTD Template//EN" 
"http://jasperreports.sourceforge.net/dtds/jaspertemplate.dtd";>

<jasperTemplate>
       <style name="LabelPlainSmall" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="7" isBold="false" isItalic="false" isUnderline="false" 
isStrikeThrough="false"/>
       <style name="TextBoxDefault" forecolor="#000000" backcolor="#FFFFFF" 
isBlankWhenNull="true" fontSize="9"/>
       <style name="ScheduleTitle" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="14" isBold="true"/>
       <style name="CheckBox" forecolor="#000000" backcolor="#FFFFFF" 
hAlign="Center" vAlign="Middle" isBlankWhenNull="true" fontSize="8">
             <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" 
lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" 
lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" 
lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" 
lineColor="#000000"/>
             </box>
       </style>
       <style name="LabelBoldSmall" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="7" isBold="true"/>
       <style name="ScheduleName" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="10" isBold="true"/>
       <style name="LabelDefault" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="8" isBold="false" isItalic="false" isUnderline="false" 
isStrikeThrough="false"/>
       <style name="LabelBoldMedium" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="8" isBold="true"/>
       <style name="LabelPlainLarge" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="10" isBold="false" isItalic="false" isUnderline="false" 
isStrikeThrough="false"/>
       <style name="LabelBoldLarge" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="10" isBold="true"/>
       <style name="NumberDefault" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="9" isBold="true"/>
       <style name="LabelPlainExtraSmall" forecolor="#000000" 
backcolor="#FFFFFF" fontSize="6" isBold="false"/>
       <style name="LabelBoldExtraSmall" forecolor="#000000" 
backcolor="#FFFFFF" fontSize="6" isBold="true"/>
       <style name="Header" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="9"/>
       <style name="Footer" forecolor="#000000" backcolor="#FFFFFF" 
fontSize="9"/>
       <style name="CoverSheetName" forecolor="#000000" backcolor="#FFFFFF" 
isBlankWhenNull="true" fontSize="12" isBold="true"/>
       <style name="SmallCheckBox" forecolor="#000000" backcolor="#FFFFFF">
             <box>
                    <topPen lineWidth="1.0"/>
                    <leftPen lineWidth="1.0"/>
                    <bottomPen lineWidth="1.0"/>
                    <rightPen lineWidth="1.0"/>
             </box>
       </style>
</jasperTemplate>



When I try this update:
UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE 
(REPORT_STYLE_NAME = ?)

I get:
org.postgresql.util.PSQLException: ERROR: invalid XML content
Detail: line 2: StartTag: invalid element name
<!DOCTYPE jasperTemplate PUBLIC "-//JasperReports//DTD Template//EN" "http://jas
^


I AM using 'XMLPARSE(DOCUMENT'.   Why the error?

Using PG 9.3 with this JDBC driver:
10:37:51,822 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 
1-11) JBAS010404: Deploying non-JDBC-compliant driver class 
org.postgresql.Driver (version 9.2)