db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sin(EaTing)," <uss...@gmail.com>
Subject Re: How to return an array of String in a Java routine?
Date Sat, 31 May 2008 12:10:25 GMT
Thanks.

I may use String[] in the implement of the Java Routine, but I don't know
how to declare the routine. It seems Java Routine in Derby does not support
Array types as IN or OUT parameters?

On Sat, May 31, 2008 at 8:01 PM, Johnny Kewl <john@kewlstuff.co.za> wrote:

>
>
> ----- Original Message -----
> *From:* sin(EaTing), <ussraf@gmail.com>
> *To:* Derby Discussion <derby-user@db.apache.org>
> *Sent:* Saturday, May 31, 2008 5:26 AM
> *Subject:* How to return an array of String in a Java routine?
>
> Hi,
>
> I want to return an array of Strings from a Java routine. How could I
> create the procedure declaration and definition.
>     This is a little vague
>     String[] maybe?
>     Or mabe you asking how to make a record holder? not sure
>
>  Or if possible could I create my own ResultSet in my Java routine, and
> manually insert rows into that ResultSet?
>
>     Try a disconnected recordset
>     Google for CachedRowSetImpl
>     You can create a cached recordset, add remove records without the dB
> and later resync with the dB if you want to.
>
> Good Luck
>
> On this site you may find some code to steal
> ---------------------------------------------------------------------------
> HARBOR : http://www.kewlstuff.co.za/index.htm
> The most powerful application server on earth.
> The only real POJO Application Server.
> See it in Action : http://www.kewlstuff.co.za/cd_tut_swf/whatisejb1.htm
> ---------------------------------------------------------------------------
>
>

Mime
View raw message