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

From: Kris Jurka <books(at)ejurka(dot)com>
To: Matt Magoffin <postgresql(dot)org(at)msqr(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Date: 2007-12-15 16:19:04
Message-ID: Pine.BSO.4.64.0712151114550.2580@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

I've implemented this for the 8.3 driver in CVS. It takes
Object.toString() of anything given with Types.OTHER, so it doesn't
necessarily need to be in String form already.

I've uploaded some jars here if you want to give it a test.

http://ejurka.com/pgsql/jars/mm/

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Matt Magoffin 2007-12-17 04:16:26 Re: how to set a PreparedStatement column of XML type in 8.3?
Previous Message Altaf Malik 2007-12-14 21:50:52 Re: JDBC causing the connection to close after executing a COPY command