So how to declare column of the array as external Type?
Envoyé depuis iCloud
Le 17 oct 2011 à 03:33, Paul Yu <p...@mac.com> a écrit :
I would think you would need to somehow define every attribute of the returned attribute(s) from this procedure.I would think that EOF knows that an Array will be coming back from your call, the issue is COLUMN is a column of the array, not the rows of the array.PaulOn 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 iCloudIs TABLE a valid external type?PaulOn 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 helpEnvoyé depuis iCloudHi 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 helpEnvoyé depuis iCloudThanks Susanne,My entities, functions and procedures are prefixed with schema owner but I go to verify again.ThanksEnvoyé depuis iCloudHi 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
