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

From: Bob Moyers <rmoyers(at)rfdinc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files
Date: 2014-05-29 15:59:24
Message-ID: AA811C413D51F1478988FBED402F0CA5099B10C7B3@IAD2MBX10.mex02.mlsrvr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jones 2014-05-29 16:04:40 Re: Code for user-defined type
Previous Message Kalai R 2014-05-29 15:01:26 Re: Postgresql service stopped automatically after restart