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@hidden
<mailto:email@hidden>:
> Send Webobjects-dev mailing list submissions to
> email@hidden <mailto:email@hidden>
>
> 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@hidden
<mailto:email@hidden>
>
> You can reach the person managing the list at
> email@hidden
<mailto:email@hidden>
>
> 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@hidden
<mailto:email@hidden>>
> Subject: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a
> procedure or is indefined )
> To: email@hidden <mailto:email@hidden>
> Cc: email@hidden
<mailto:email@hidden>
> 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@hidden <mailto:email@hidden>>
> Subject: Compare old Server to the new mac mini Server
> To: WebObjects List Mailing<email@hidden
<mailto:email@hidden>>
> Cc: email@hidden <mailto:email@hidden>
> Message-ID:<email@hidden
<email@hidden">mailto:email@hidden>>
> 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@hidden <mailto:email@hidden>>
> [iChat:]<email@hidden <mailto:email@hidden>>
> [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@hidden <mailto:email@hidden>>
> Subject: R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not
> a procedure or is indefined )
> To: Rafal Szczepanski<email@hidden
<mailto:email@hidden>>
> Cc: email@hidden
<mailto:email@hidden>
> Message-ID:<email@hidden
<email@hidden">mailto:email@hidden>>
> 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@hidden
<mailto:email@hidden>> 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@hidden
<mailto:email@hidden>>
> Subject: Re: Compare old Server to the new mac mini Server
> To: ISHIMOTO Ken<email@hidden <mailto:email@hidden>>
> Cc: WebObjects List Mailing<email@hidden
<mailto:email@hidden>>,
> email@hidden <mailto:email@hidden>
> Message-ID:<email@hidden
<email@hidden">mailto:email@hidden>>
> 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@hidden <mailto:email@hidden>>
> Subject: Re: Compare old Server to the new mac mini Server
> To: Ramsey Gurley<email@hidden
<mailto:email@hidden>>
> Cc: WebObjects List Mailing<email@hidden
<mailto:email@hidden>>,
> email@hidden <mailto:email@hidden>
> Message-ID:<email@hidden
<email@hidden">mailto:email@hidden>>
> 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@hidden <mailto:email@hidden>>
>>> [iChat:]<email@hidden <mailto:email@hidden>>
>>> [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@hidden
<mailto:email@hidden>)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>>
>>> This email sent to email@hidden
<mailto:email@hidden>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden
<mailto:email@hidden>)
>> Help/Unsubscribe/Update your Subscription:
>>
>>
>> This email sent to email@hidden <mailto:email@hidden>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 11 Oct 2011 11:50:10 -0700
> From: Lon Varscsak<email@hidden
<mailto:email@hidden>>
> Subject: Long time no write?and a problem with "Unbound classpath
> container"
> To: email@hidden
<mailto:email@hidden>
> Message-ID:
> <email@hidden
<email@hidden">mailto:email@hidden>>
> 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@hidden <mailto:email@hidden>
> 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@hidden
<mailto:email@hidden>
web http://www.interActive-Systems.de
----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------