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

2014-06-04 Thread Peter Eisentraut
On 5/29/14, 11:59 AM, Bob Moyers wrote: 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

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

2014-06-04 Thread David G Johnston
Peter Eisentraut-2 wrote On 5/29/14, 11:59 AM, Bob Moyers wrote: 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:

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

2014-05-29 Thread 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