Hi Raymond, In general when dealing with functions from EOF you must, in addition to the arguments, define the return type in your eomodel.
You define the return type by adding an attribute with the column name "0" (zero). Off the top of my head I believe the attribute name and direction have no importance for the return type. In your case you could have attributes like this: NAME COLUMN NAME DIRECTION 010_etuId 010_etuId In return 0 In This should work with ordinary values returned from functions. I can't say if your pipelined return type makes a difference. -Cail On 17/10/2011, at 11.00, Raymond NANEON wrote: > Hi, > > I added a returnValue attribute in my function declaration in my eomodel. I > declared external type of my attribute as Table and custom data as > NSMutableDictionnary. When I execute my function I get this error : > > <eo3.png> > > com.webobjects.jdbcadaptor.JDBCAdaptorException : Unable to determine JDBC > type for attribute '020_returnValue' when preparing output parameter for > stored procedure. > Thanks for your help > Envoyé depuis iCloud > > Le 17 oct 2011 à 01:00, Raymond NANEON <[email protected]> a écrit : > >> Hi All, >> >> I verified my function owner and all is fine but I have always the same >> problem FUNCTION is not a procedure or is undefined. >> >> The Function : >> >> FUNCTION PROFIL_ETUDIANT( >> etuID in NUMBER -- id etudiant >> ) return TAB_ETUID PIPELINED; >> >> In eomodel : >> <eo1.png> >> >> <eo2.png> >> >> What The problem? It's because my function declaration in eoModel don't have >> return attribute? >> >> Thanks for your help >> Envoyé depuis iCloud >> >> Le 13 oct 2011 à 00:33, Raymond NANEON <[email protected]> a écrit : >> >>> Thanks Susanne, >>> >>> My entities, functions and procedures are prefixed with schema owner but I >>> go to verify again. >>> >>> Thanks >>> Envoyé depuis iCloud >>> >>> Le 12 oct 2011 à 01:48, Susanne Schneider >>> <[email protected]> a écrit : >>> >>>> Hi Raymond, >>>> >>>> I would gess this is more an Oracle than an WebObjects problem. Oracle >>>> can be very picky regarding user rights if you are dealing with separate >>>> user schemes for your EOModel. Maybe the function is defined by another >>>> user than that used by WebObjects to execute it? >>>> >>>> You should check if the function owner is the user executing and, if >>>> they are not equal, if the necessary execute rights have been given. >>>> Furthermore if the function itself accesses tables from another user >>>> than owner or executer, than you have another problem to solve :-) >>>> >>>> HTH, >>>> Susanne >>>> >>>> Am 11.10.2011 21:11, schrieb [email protected]: >>>> > Send Webobjects-dev mailing list submissions to >>>> > [email protected] >>>> > >>>> > To subscribe or unsubscribe via the World Wide Web, visit >>>> > http://lists.apple.com/mailman/listinfo/webobjects-dev >>>> > or, via email, send a message with subject or body 'help' to >>>> > [email protected] >>>> > >>>> > You can reach the person managing the list at >>>> > [email protected] >>>> > >>>> > When replying, please edit your Subject line so it is more specific >>>> > than "Re: Contents of Webobjects-dev digest..." >>>> > >>>> > >>>> > Today's Topics: >>>> > >>>> > 1. Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a >>>> > procedure or is indefined ) (Rafal Szczepanski) >>>> > 2. Compare old Server to the new mac mini Server (ISHIMOTO Ken) >>>> > 3. R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not >>>> > a procedure or is indefined ) (Raymond NANEON) >>>> > 4. Re: Compare old Server to the new mac mini Server (Ramsey Gurley) >>>> > 5. Re: Compare old Server to the new mac mini Server (Tim Worman) >>>> > 6. Long time no write?and a problem with "Unbound classpath >>>> > container" (Lon Varscsak) >>>> > >>>> > >>>> > ---------------------------------------------------------------------- >>>> > >>>> > Message: 1 >>>> > Date: Tue, 11 Oct 2011 11:13:58 +0200 >>>> > From: Rafal Szczepanski<[email protected]> >>>> > Subject: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a >>>> > procedure or is indefined ) >>>> > To: [email protected] >>>> > Cc: [email protected] >>>> > Message-ID:<001e01cc87f6$1d55f960$5801ec20$@com> >>>> > Content-Type: text/plain; charset="us-ascii" >>>> > >>>> > Hi Raymond, >>>> > >>>> > >>>> > >>>> > I'm using Oracle functions and everything works smooth. Can you please >>>> > provide more details about your configuration? >>>> > >>>> > >>>> > >>>> > Cheers, >>>> > >>>> > Rafal >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > -------------- next part -------------- >>>> > An HTML attachment was scrubbed... >>>> > URL: >>>> > http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/f8e7ed28/attachment.html >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 2 >>>> > Date: Tue, 11 Oct 2011 11:19:47 +0200 >>>> > From: ISHIMOTO Ken<[email protected]> >>>> > Subject: Compare old Server to the new mac mini Server >>>> > To: WebObjects List Mailing<[email protected]> >>>> > Cc: [email protected] >>>> > Message-ID:<[email protected]> >>>> > Content-Type: text/plain; charset="us-ascii" >>>> > >>>> > Hi, >>>> > >>>> > I have replaced one of my Server. >>>> > >>>> > >>>> > >>>> > The old Server was a mac mini 2GB intel core duo with FrontBase 4 and >>>> > Wonder-D2W Application. >>>> > >>>> > The Average Transaction Time was : 0.626s (3 Instances used) >>>> > >>>> > The new Server is a mac mini 8GB i7 with FrontBase 5 and the some >>>> > Wonder-D2W Application. >>>> > >>>> > The Average Transaction Time is : 0.036s (3 Instances used) >>>> > >>>> > >>>> > about 17 Time faster. >>>> > >>>> > >>>> > >>>> > Thank you >>>> > >>>> > Ken Ishimoto >>>> > >>>> > -------------------------------------------------------- >>>> > K's ROOM >>>> > -------------------------------------------------------- >>>> > [E-Mail]<[email protected]> >>>> > [iChat:]<[email protected]> >>>> > [HP] http://www.ksroom.com/ >>>> > _____________________________________________________________________ >>>> > This e-mail has not been scanned for viruses because it was written on >>>> > an Mac, >>>> > and there are NO Viruses on an Apple Computer. >>>> > For further information visit http://www.apple.com >>>> > >>>> > >>>> > >>>> > >>>> > -------------- next part -------------- >>>> > An HTML attachment was scrubbed... >>>> > URL: >>>> > http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/aca64a75/attachment.html >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 3 >>>> > Date: Tue, 11 Oct 2011 09:54:27 +0000 (GMT) >>>> > From: Raymond NANEON<[email protected]> >>>> > Subject: R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not >>>> > a procedure or is indefined ) >>>> > To: Rafal Szczepanski<[email protected]> >>>> > Cc: [email protected] >>>> > Message-ID:<[email protected]> >>>> > Content-Type: text/plain; charset="utf-8" >>>> > >>>> > Hi Rafal, >>>> > >>>> > I use Eclipse JEE Indigo , WOLips 3.7 and Wonder latest version. My >>>> > function return a table. >>>> > >>>> > i.e : >>>> > >>>> > PL/SQL >>>> > >>>> > TYPE TAB_ETUD IS TABLE OF OBJ_ETU; >>>> > >>>> > FUNCTION PROFIL_ETUDIANT( >>>> >     etuID in NUMBER >>>> >     ) return TAB_ETUD PIPELINED; >>>> > >>>> > here my java method : >>>> > >>>> > public boolean executeProcedure(NSMutableDictionary procResult, String >>>> > procedure, NSDictionary dicoData){ >>>> >   boolean noError = true; >>>> >   startsWorking(); >>>> >   EOAdaptorChannel adaptorChannel = adaptorChannel(); >>>> >    this.executedProcResult.removeAllObjects(); >>>> >    try { >>>> >     EOStoredProcedure myProcedure = >>>> > EOModelGroup.defaultGroup().storedProcedureNamed(procedure); >>>> >     adaptorChannel.executeStoredProcedure(myProcedure, dicoData); >>>> >    >>>> > this.executedProcResult.addEntriesFromDictionary(adaptorChannel.returnValuesForLastStoredProcedureInvocation()); >>>> > } catch (Throwable e) { >>>> >     e.printStackTrace(); >>>> >    noError = false; >>>> >    String exMessage = LoginLog.getMessageForException(e); >>>> >     if (exMessage == null) exMessage = "Le message d'erreur inconnu"; >>>> >     this.executedProcResult.setObjectForKey(exMessage, "ERREUR"); >>>> >  } >>>> >    if ((procResult != null)&& (procResult != this.executedProcResult)) >>>> >    procResult.addEntriesFromDictionary(this.executedProcResult); >>>> >    stopsWorking(); >>>> >    return noError; >>>> > } >>>> > So you think the error message is about the WOLips version or wonder >>>> > version? The returned data is unsupported? >>>> > >>>> > Thaks >>>> > Envoyé depuis iCloud >>>> > >>>> > Le 11 oct 2011 à 02:13, Rafal >>>> > Szczepanski<[email protected]> a écrit : >>>> > >>>> > Hi Raymond, >>>> >  >>>> > I’m using Oracle functions and everything works smooth. Can you please >>>> > provide more details about your configuration? >>>> >  >>>> > Cheers, >>>> > Rafal >>>> >  >>>> >  >>>> > -------------- next part -------------- >>>> > Skipped content of type multipart/related >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 4 >>>> > Date: Tue, 11 Oct 2011 08:34:40 -0700 >>>> > From: Ramsey Gurley<[email protected]> >>>> > Subject: Re: Compare old Server to the new mac mini Server >>>> > To: ISHIMOTO Ken<[email protected]> >>>> > Cc: WebObjects List Mailing<[email protected]>, >>>> > [email protected] >>>> > Message-ID:<[email protected]> >>>> > Content-Type: text/plain; charset="us-ascii" >>>> > >>>> > Skipped content of type multipart/alternative-------------- next part >>>> > -------------- >>>> > A non-text attachment was scrubbed... >>>> > Name: smime.p7s >>>> > Type: application/pkcs7-signature >>>> > Size: 4233 bytes >>>> > Desc: not available >>>> > Url : >>>> > http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/cdabf880/smime.bin >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 5 >>>> > Date: Tue, 11 Oct 2011 11:35:28 -0700 >>>> > From: Tim Worman<[email protected]> >>>> > Subject: Re: Compare old Server to the new mac mini Server >>>> > To: Ramsey Gurley<[email protected]> >>>> > Cc: WebObjects List Mailing<[email protected]>, >>>> > [email protected] >>>> > Message-ID:<[email protected]> >>>> > Content-Type: text/plain; charset=us-ascii >>>> > >>>> > Also, I'm wondering how many developers are running their apps and >>>> > database on the same box? Obviously there's an opportunity to cut down >>>> > on transaction time there but it also creates a single point of failure. >>>> > >>>> > Tim Worman >>>> > UCLA GSE&IS >>>> > >>>> > On Oct 11, 2011, at 8:34 AM, Ramsey Gurley wrote: >>>> > >>>> >> Hi Ken, >>>> >> >>>> >> Impressive. Out of curiosity, how did you take the measurements? I've >>>> >> seen some built in metrics stuff in ERD2W, but I've never put it to >>>> >> use. So naturally, I'm wondering if this sort of info is available at >>>> >> the flip of a switch, or is it something you had to implement yourself? >>>> >> >>>> >> Ramsey >>>> >> >>>> >> On Oct 11, 2011, at 2:19 AM, ISHIMOTO Ken wrote: >>>> >> >>>> >>> Hi, >>>> >>> >>>> >>> I have replaced one of my Server. >>>> >>> >>>> >>> >>>> >>> >>>> >>> The old Server was a mac mini 2GB intel core duo with FrontBase 4 and >>>> >>> Wonder-D2W Application. >>>> >>> >>>> >>> The Average Transaction Time was : 0.626s (3 Instances used) >>>> >>> >>>> >>> The new Server is a mac mini 8GB i7 with FrontBase 5 and the some >>>> >>> Wonder-D2W Application. >>>> >>> >>>> >>> The Average Transaction Time is : 0.036s (3 Instances used) >>>> >>> >>>> >>> >>>> >>> about 17 Time faster. >>>> >>> >>>> >>> >>>> >>> >>>> >>> Thank you >>>> >>> >>>> >>> Ken Ishimoto >>>> >>> >>>> >>> -------------------------------------------------------- >>>> >>> K's ROOM >>>> >>> -------------------------------------------------------- >>>> >>> [E-Mail]<[email protected]> >>>> >>> [iChat:]<[email protected]> >>>> >>> [HP] http://www.ksroom.com/ >>>> >>> _____________________________________________________________________ >>>> >>> This e-mail has not been scanned for viruses because it was written on >>>> >>> an Mac, >>>> >>> and there are NO Viruses on an Apple Computer. >>>> >>> For further information visit http://www.apple.com >>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> >>> _______________________________________________ >>>> >>> Do not post admin requests to the list. They will be ignored. >>>> >>> Webobjects-dev mailing list ([email protected]) >>>> >>> Help/Unsubscribe/Update your Subscription: >>>> >>> http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com >>>> >>> >>>> >>> This email sent to [email protected] >>>> >> >>>> >> _______________________________________________ >>>> >> Do not post admin requests to the list. They will be ignored. >>>> >> Webobjects-dev mailing list ([email protected]) >>>> >> Help/Unsubscribe/Update your Subscription: >>>> >> http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com >>>> >> >>>> >> This email sent to [email protected] >>>> > >>>> > >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 6 >>>> > Date: Tue, 11 Oct 2011 11:50:10 -0700 >>>> > From: Lon Varscsak<[email protected]> >>>> > Subject: Long time no write?and a problem with "Unbound classpath >>>> > container" >>>> > To: [email protected] >>>> > Message-ID: >>>> > <calaw18zswxeqggb3rgudhult_zqnha9yzfoluc9qcqkvetr...@mail.gmail.com> >>>> > Content-Type: text/plain; charset=windows-1252 >>>> > >>>> > Hey, it's been 8 months since I've left my long-time company of >>>> > SmartHealth and have mostly been out of the WO space since. I have >>>> > done a few projects for my old employer, so I'm not completely rusty. >>>> > >>>> > However… :) >>>> > >>>> > I went to start a new project today, and I'm getting "Unbound >>>> > classpath container" errors on all of the WO Frameworks. My >>>> > ~/Library/Application\ Support/WOLips/wolips.properties seems fine. >>>> > Although, I can't seem to find the WO Frameworks anywhere. :) So I'm >>>> > assuming that is the issue. >>>> > >>>> > The weird thing is, that the last project I did worked fine and >>>> > haven't "removed WO" from my machine. I am running Lion (although I'm >>>> > positive I upgraded to this before my last project). >>>> > >>>> > Any reason why the system would delete frameworks? Maybe after a >>>> > software update? >>>> > >>>> > -Lon >>>> > >>>> > >>>> > ------------------------------ >>>> > >>>> > _______________________________________________ >>>> > Webobjects-dev mailing list >>>> > [email protected] >>>> > http://lists.apple.com/mailman/listinfo/webobjects-dev >>>> > >>>> > End of Webobjects-dev Digest, Vol 8, Issue 752 >>>> > ********************************************** >>>> >>>> -- >>>> Susanne Schneider >>>> Coordinator secuTrial Development >>>> >>>> iAS interActive Systems GmbH >>>> Dieffenbachstraße 33 c, 10967 Berlin >>>> >>>> fon +49 30 22 50 50 - 498 >>>> fax +49 30 22 50 50 - 451 >>>> mail [email protected] >>>> web http://www.interActive-Systems.de >>>> >>>> ---------------------------------------------------- >>>> Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche >>>> Sitz der Gesellschaft: Berlin >>>> Amtsgericht Berlin Charlottenburg, HRB 106103B >>>> ---------------------------------------------------- >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com >>> >>> This email sent to [email protected] > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/cail%40frontbase.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
