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/archive%40mail-archive.com
This email sent to [email protected]
