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@postnewspapers.com.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.
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/