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

From Matt Magoffin
Subject Re: how to set a PreparedStatement column of XML type in 8.3?
Date
Msg-id 49230.192.168.1.108.1197663372.squirrel@msqr.us
Whole thread Raw
In response to Re: how to set a PreparedStatement column of XML type in 8.3?  (Kris Jurka <books@ejurka.com>)
Responses Re: how to set a PreparedStatement column of XML type in 8.3?  (Kris Jurka <books@ejurka.com>)
Re: how to set a PreparedStatement column of XML type in 8.3?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
>> 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

What about with calls to setObject(int, Object, int) when a String is
passed in and the type set to Types.OTHER? Would it be possible then...
say if Object is a String, to treat it as if the stringtype=unspecified
parameter was set? I apologize if these are obvious questions, I'm just
bouncing ideas around.

-- m@

pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Next
From: Kris Jurka
Date:
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?