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 <[EMAIL PROTECTED]> wrote: > > > ----- Original Message ----- > *From:* sin(EaTing), <[EMAIL PROTECTED]> > *To:* Derby Discussion <[email protected]> > *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 > --------------------------------------------------------------------------- > >
