Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group