Re: prepared statement using postgres array

Christian,

I'm doing this from memory so you may have to adjust.

you really only need to implement toString on the interface.
and the getBaseType.

the method has to output "{e0,e1,e2...}"

Where eN is the element of the array

Dave
On 30-Nov-07, at 12:43 PM, Christian Kindler wrote:

> Hi Dave
>
>> you have to implement the java.sql.Array
>
> hmmm ... i have tried to find a sample implementation of the
> interface, but no success.
>
> I am sure this is a ugly solution but I figures out a workaround:
>
> INSERT INTO Quote(fi_id, market_id, "date", "time",
>                  "open", high, low, "close", vol, oi,
>                  bid, bidvol, ask, askvol,
>                  last,
>                  sysstatus,
>                  buyers,  buyersvol, sellers, sellersvol,
>                  additional)
>           VALUES(?, ?, ?, ?,
>                  ?, ?, ?, ?, ?, ?,
>                  ?, ?, ?, ?,
>                  ?,
>                  ?,
>                  (select string_to_array(?, ',')::float[]),
>                  (select string_to_array(?, ',')::float[]),
>                  (select string_to_array(?, ',')::float[]),
>                  (select string_to_array(?, ',')::float[]),
>                  (select string_to_array(?, ',')::float[])
>                 );
>
> ... as is said not pretty but it works for the moment ...
>
> Thanks!
> Christian
>
> PS But it still will be cool if anybody could provide me a sample
> snipped implementing java.sql.Array
>
>
> --
> cu
> Chris
>
> Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
> Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq