Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files - Mailing list pgsql-general
| From | Bob Moyers |
|---|---|
| Subject | Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files |
| Date | |
| Msg-id | AA811C413D51F1478988FBED402F0CA5099B10C7B3@IAD2MBX10.mex02.mlsrvr.com Whole thread Raw |
| Responses |
Re: Re: PostgreSQL 9.3 XML parser seems not to recognize
the DOCTYPE element in XML files
|
| List | pgsql-general |
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)
pgsql-general by date: