Re: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar

Thanks,

sorry for my poor level in Java/JDBC :

but how do you use that ?

i've tried :

ret.updateObject("DATA",writer.toString() ,java.sql.Types.SQLXML);

but it's still doesn't work :

ERROR: column "DATA" is of type xml but expression is of type character
varying
Hint: You will need to rewrite or cast the expression.

neither this one :

ret.updateObject("DATA",(java.sql.Types.SQLXML)writer.toString());

sorry,

On Sat, Oct 23, 2010 at 6:09 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au>wrote:

> On 23/10/2010 11:53 AM, Michael musset wrote:
>
>> So, what I have to do ?
>>
>> i've tried to convert my xml into String but it still doesn't work :
>>
>> ret.updateString("DATA", myXmlString);
>>
>>
>> the error appear when i did a updaterow in my resultset
>>
>>
>> the error is:
>>
>> org.postgresql.util.PSQLException: ERROR: column "DATA" is of type xml
>> but expression is of type character varying
>> Hint: You will need to rewrite or cast the expression.
>>
>
> It's one of those irritating areas where PostgreSQL's overzealous refusal
> to cast ::text or ::varchar for interpretation as literals of another type
> bites you.
>
> You need to use updateObject("DATA", java.sql.Types.SQLXML) so the JDBC
> driver knows what type to specify.
>
> --
> Craig Ringer
>
> Tech-related writing at http://soapyfrogs.blogspot.com/
>