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