Re: XML document with doctype

Russ,

A cursory glance at JDBC4 suggests that there is support for the SQLXML
type in the driver. Does hibernate have any support for it.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Wed, Jan 23, 2013 at 7:38 PM, Russ Tennant <russ(at)i2rd(dot)com> wrote:

> Is there a way to persist XML data as a DOCUMENT as opposed to CONTENT
> (the default) without using SET XML OPTION / XMLPARSE?
>
> I'm using Hibernate and don't have control over building of the SQL for
> the PreparedStatement out of the box or when it executes to wrap calls
> to SET XML OPTION. For Hibernate, I'm using a UserType I wrote that uses
> SQLXML. In my case, I usually have XML content so it works fine in those
> cases; occasionally, I have a document to persist and then it will fail
> occasionally unless I tell PG that it is a document. I'm trying to find
> the best way to work with Hibernate when I have a document while
> minimizing the amount of Hibernate code I have to write. Before I delve
> into that, I wanted to make sure I wasn't missing any other options for
> passing along DOCUMENT/CONTENT info for converting from a string to an
> XML type.
>
> So, it looks like my options are: XMLPARSE (custom SQL) and SET XML
> OPTION. Are there any other options that I'm missing? Thanks for any help.
>
> --
> Russ Tennant
> Software Engineer
> I2RD (Interactive Information R&D)
> Email: russ(at)i2rd(dot)com
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>