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

From Kris Jurka
Subject Re: how to set a PreparedStatement column of XML type in 8.3?
Date
Msg-id Pine.BSO.4.64.0712141529390.29577@leary.csoft.net
Whole thread Raw
In response to Re: how to set a PreparedStatement column of XML type in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
List pgsql-jdbc

On Sat, 15 Dec 2007, Matt Magoffin wrote:

> What about with calls to setObject(int, Object, int) when a String is
> passed in and the type set to Types.OTHER? Would it be possible then...
> say if Object is a String, to treat it as if the stringtype=unspecified
> parameter was set?

Sounds like a good idea to me.  Right now it bails out with the following,
so it's not like we'd be breaking anything that's working...

org.postgresql.util.PSQLException: Cannot cast an instance of
java.lang.String to type Types.OTHER

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Next
From: Altaf Malik
Date:
Subject: Re: JDBC causing the connection to close after executing a COPY command