Postgres Pro
Downloads
Home   >   mailing lists

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

From Matt Magoffin
Subject how to set a PreparedStatement column of XML type in 8.3?
Date
Msg-id 51046.192.168.1.108.1197434523.squirrel@msqr.us
Whole thread Raw
Responses Re: how to set a PreparedStatement column of XML type in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
List pgsql-jdbc
Tree view 
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
varying

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 column?

Thanks,
m@

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: JDBC driver patch for non-ASCII users
Next
From: sulfinu@gmail.com
Date:
Subject: Re: JDBC driver patch for non-ASCII users