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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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