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 <rnan...@me.com> 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 <rnan...@me.com> 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 >>> <susanne.schnei...@interactive-systems.de> 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 webobjects-dev-requ...@lists.apple.com: >>>> > Send Webobjects-dev mailing list submissions to >>>> > webobjects-dev@lists.apple.com >>>> > >>>> > 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 >>>> > webobjects-dev-requ...@lists.apple.com >>>> > >>>> > You can reach the person managing the list at >>>> > webobjects-dev-ow...@lists.apple.com >>>> > >>>> > 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<r.szczepan...@smartrecruiters.com> >>>> > Subject: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a >>>> > procedure or is indefined ) >>>> > To: rnan...@me.com >>>> > Cc: webobjects-dev@lists.apple.com >>>> > 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<k...@ksroom.com> >>>> > Subject: Compare old Server to the new mac mini Server >>>> > To: WebObjects List Mailing<Webobjects-dev@lists.apple.com> >>>> > Cc: wo...@webobjects.me >>>> > Message-ID:<877ba62f-0947-4cad-95c5-85bb67bf7...@ksroom.com> >>>> > 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]<k...@ksroom.com> >>>> > [iChat:]<ibase_...@mac.com> >>>> > [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<rnan...@me.com> >>>> > Subject: R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not >>>> > a procedure or is indefined ) >>>> > To: Rafal Szczepanski<r.szczepan...@smartrecruiters.com> >>>> > Cc: webobjects-dev@lists.apple.com >>>> > Message-ID:<3fd14649-2bfe-4213-b636-f0c583a4c...@me.com> >>>> > 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<r.szczepan...@smartrecruiters.com> 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<ramseygur...@gmail.com> >>>> > Subject: Re: Compare old Server to the new mac mini Server >>>> > To: ISHIMOTO Ken<k...@ksroom.com> >>>> > Cc: WebObjects List Mailing<Webobjects-dev@lists.apple.com>, >>>> > wo...@webobjects.me >>>> > Message-ID:<75ad3565-212d-48f7-8384-9a2fd653b...@gmail.com> >>>> > 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<li...@thetimmy.com> >>>> > Subject: Re: Compare old Server to the new mac mini Server >>>> > To: Ramsey Gurley<ramseygur...@gmail.com> >>>> > Cc: WebObjects List Mailing<Webobjects-dev@lists.apple.com>, >>>> > wo...@webobjects.me >>>> > Message-ID:<8b3418e0-c386-4b7e-acab-5217b4c93...@thetimmy.com> >>>> > 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]<k...@ksroom.com> >>>> >>> [iChat:]<ibase_...@mac.com> >>>> >>> [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 (Webobjects-dev@lists.apple.com) >>>> >>> Help/Unsubscribe/Update your Subscription: >>>> >>> http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com >>>> >>> >>>> >>> This email sent to ramseygur...@gmail.com >>>> >> >>>> >> _______________________________________________ >>>> >> Do not post admin requests to the list. They will be ignored. >>>> >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>> >> Help/Unsubscribe/Update your Subscription: >>>> >> http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com >>>> >> >>>> >> This email sent to li...@thetimmy.com >>>> > >>>> > >>>> > >>>> > ------------------------------ >>>> > >>>> > Message: 6 >>>> > Date: Tue, 11 Oct 2011 11:50:10 -0700 >>>> > From: Lon Varscsak<lon.varsc...@gmail.com> >>>> > Subject: Long time no write?and a problem with "Unbound classpath >>>> > container" >>>> > To: webobjects-dev@lists.apple.com >>>> > 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 >>>> > Webobjects-dev@lists.apple.com >>>> > 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 susanne.schnei...@interactive-systems.de >>>> 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 (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com >>> >>> This email sent to rnan...@me.com > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > > This email sent to p...@mac.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
