Re: how to set a PreparedStatement column of XML type in 8.3?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Matt Magoffin <postgresql(dot)org(at)msqr(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Date: 2007-12-14 10:29:10
Message-ID: Pine.BSO.4.64.0712140524590.15803@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Altaf Malik 2007-12-14 11:11:22 Re: JDBC causing the connection to close after executing a COPY command
Previous Message Kris Jurka 2007-12-14 10:24:16 Re: Slow query after upgrades