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: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?
Date: 2007-12-17 04:16:26
Message-ID: 50955.192.168.1.108.1197864986.squirrel@msqr.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
>> 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/

Yep, that did the trick for me. Thanks!

-- m@

In response to

pgsql-jdbc by date

Next:From: abyssDate: 2007-12-17 22:22:39
Subject: DatabaseMetaData and numeric array
Previous:From: Kris JurkaDate: 2007-12-15 16:19:04
Subject: Re: how to set a PreparedStatement column of XML type in 8.3?

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