From: | "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> |
---|---|
To: | "Kris Jurka" <books(at)ejurka(dot)com> |
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 20:16:12 |
Message-ID: | 49230.192.168.1.108.1197663372.squirrel@msqr.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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@
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2007-12-14 20:31:08 | Re: how to set a PreparedStatement column of XML type in 8.3? |
Previous Message | dmp | 2007-12-14 16:42:12 | Re: how to set a PreparedStatement column of XML type in 8.3? |