> I'm using the 8.3dev-602 JDBC driver, trying to set the value of an "xml"
> type column in an 8.3 database. The driver keeps throwing exceptions like
> ERROR: column "xml" is of type xml but expression is of type character
> I've tried a variety of different ways, including pstmt.setString,
> pstmt.setObject, and pstmt.setObject passing in Types.OTHER.
> What is the correct way to set a statement parameter value for an xml
I am able to work around the issue by setting a PGObject value with the
type set to "xml" and the value my XML String. Is this the way the driver
is expected to work, or should it map Strings to the xml type
automatically in 8.3?
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2007-12-12 23:59:32|
|Subject: Re: how to set a PreparedStatement column of XML type in
|Previous:||From: Oliver Jowett||Date: 2007-12-12 12:12:50|
|Subject: Re: JDBC driver patch for non-ASCII users|