According to EOF Developer's guide hardcopy book that i have. "You must also define an argument for a stored procedure's return value and for each of its parameters. Add arguments to a stored prcedure the same way you add attributes to an entity. In fact, the arguments of a stored procedure are represented with EOAttribute objects."
Paul On Oct 17, 2011, at 6:27 AM, Raymond NANEON wrote: > Hi, > > I declare External Type ARRAY, OBJECT and so one and stuck on the same error > : com.webobjects.jdbcadaptor.JDBCAdaptorException : Unable to determine JDBC > type for attribute '020_returnValue' when preparing output parameter for > stored procedure. > I try all Oracle externalsTypes which are familiar to Table or Array. > Envoyé depuis iCloud > > Le 17 oct 2011 à 03:10, Paul Yu <[email protected]> a écrit : > >> Is TABLE a valid external type? >> >> Paul >> On Oct 17, 2011, at 5:00 AM, 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/pyu%40mac.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]
