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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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