Re: how to set a PreparedStatement column of XML type in 8.3? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: how to set a PreparedStatement column of XML type in 8.3?
Date
Msg-id Pine.BSO.4.64.0712140524590.15803@leary.csoft.net
Whole thread Raw
In response to Re: how to set a PreparedStatement column of XML type in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: how to set a PreparedStatement column of XML type in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
List pgsql-jdbc

On Fri, 14 Dec 2007, Matt Magoffin wrote:

> Do you think it's worth considering having the 8.3 driver do this
> automatic conversion of String <-> xml, so that users don't have to use
> PGObject or set the stringtype=unspecified connection parameter?

The driver can't really do that.  At the time you say setString, the
driver doesn't know that the real target type is xml, so the driver's only
options are to set the parameter type to varchar (String) or unknown (the
unspecified URL parameter).

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Slow query after upgrades
Next
From: Altaf Malik
Date:
Subject: Re: JDBC causing the connection to close after executing a COPY command