Skip site navigation (1) Skip section navigation (2)

Re: how to set a PreparedStatement column of XML type in 8.3?

From: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Date: 2007-12-12 23:21:24
Message-ID: 50753.192.168.1.108.1197501684.squirrel@msqr.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
> 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@

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?

-- m@


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-12-12 23:59:32
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Previous:From: Oliver JowettDate: 2007-12-12 12:12:50
Subject: Re: JDBC driver patch for non-ASCII users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group