public inbox for [email protected]  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Arrays support for object views
Date: Tue, 23 Sep 2008 18:29:54 +0200
Message-ID: <[email protected]> (raw)

Hello,
Thanks for the nice project. I encountered some traces of efforts to use
arrays from within pljava but could not find a working example.
I'm trying to create a function that would return a setof complex objects
where some fields of the object are plain old dataype arrays. i.e.:

CREATE TYPE tsTest2 AS
(
     id  bigint ,
     tsType integer  ,
     residuals boolean ,
     length integer,
     obs    float8[]
) ;


then I create a mapping function:

CREATE or replace FUNCTION tt2(integer ,float8 , float8 , float8 )
  RETURNS SETOF tstest2
  AS 'gaia.cu7.omimpl.TimeSeriesImplSQL.timeseriesReturn'
  IMMUTABLE LANGUAGE javaU;

then, whatever I try to do in a java code for   assignRowValues fails:
i.e.: receiver.updateString(6, "{1.0,2.0,3.0}");
would result in:

-- Executing query:
select tt2(0,0.0,0.0,0.0);


ERROR:  java.sql.SQLException: Cannot derive a value of class
[Ljava.lang.Double; from an object of class java.lang.String

you do have updateArray but could not spot any usage example with it.
Please help, otherwise we will have to drop pljava from the project which
has a chance to impact astronomy community thus leverage pljava.
Best regards,
Krzysztof
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080923/b21a2004/attachment.html;

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Subject: Re: [Pljava-dev] Arrays support for object views
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox