Re: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Cail Borrell
Hi Raymond, In general when dealing with functions from EOF you must, in addition to the arguments, define the return type in your eomodel. You define the return type by adding an attribute with the column name "0" (zero). Off the top of my head I believe the attribute name and direction have

Re: EOF Boot Camp and WOWODC 2012

2011-10-17 Thread Ken Anderson
I can only make the July dates next year - so that's my vote! I'll probably drag along someone from work to attend as well. On Sep 20, 2011, at 3:26 PM, Pascal Robert wrote: > Ok, so some news about WOWODC 2012. Like I said before, we want to do a Boot > Camp before WOWODC. That boot camp woul

Re: Building framework branches with Hudson

2011-10-17 Thread David Avendasora
My old Hudson job templates allow you to specify a branch/revision for the Wonder frameworks out of Subversion, I'm not sure how CVS works (never had the "pleasure") but if you take a look at them, they should give you an idea of how to modify the job. https://github.com/avendasora/WOJenkins

Building framework branches with Hudson

2011-10-17 Thread Ramsey Gurley
Hi all, I have a framework (2 actually) that is branched on CVS and I need to build the branch for one project while building the trunk for all the rest of the projects. I'm wondering if there's an easy way to set this up? Thanks, Ramsey ___ Do n

ERAttachments, S3, and dynamic configurations

2011-10-17 Thread Matthew Ness
Hi all, I'm using ERAttachments in a couple of my applications. Some are using the configuration type {S3}. For one of the applications using S3 I have a need to dynamically generate and use a sub-set of the ERAttachment configuration set. I cannot use the standard Properties approach, as the ERA

Q about locked ec (again)

2011-10-17 Thread Philippe Rabier
The question is mainly for Kieran. In the framework COScheduler (job scheduling), I expose an abstract method newEditingContext() to let the developer create his own ec with autolock = false (see discussion in february 2010) like this: @Override public EOEditingContext newEditing

Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Raymond NANEON
Hi Kevin, There are not a way to use function returned PIPELINE Table in WO ? It's not define in EOAttribute class which set the stored Procedure arguments? So I go to use rawRowSql to execute my function in WO. Thanks Raymond NANEON rnan...@me.com Le 17 oct. 2011 à 22:21, Kevin Ren a écrit

Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Kevin Ren
Hi, Raymond, may be this is your typo. Your table type is OBJ_ETU instead of OBJ_ETUDIANT . create or replace TYPE OBJ_ETUDIANT AS OBJECT TYPE TAB_ETUD IS TABLE OF OBJ_ETU; FUNCTION PROFIL_ETUDIANT( etuID in NUMBER ) return TAB_ETUD PIPELINED; 1, if i declare OBJECT and TA

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Kieran Kelleher
Least effort fix might be to exclude your bundle from the woproject task (wopattern exclude) and add an ant task to simply copy the bundle to your dist Resources folder. On Oct 17, 2011, at 12:49 PM, Yung-Luen Lan wrote: > Found the handling code here: > > https://github.com/wolips/wolips/blob

Re: Question about restrictedChoiceKey

2011-10-17 Thread Farrukh Ijaz
Hi Ramsey, The issue has been solved. The reason to hessitate using 'session.keyName' was my understanding to implement a getter for keyName inside Session class. But this has been solved using 'session.objectStore.keyName'. Thanks, Farrukh On 2011-10-17, at 6:34 PM, Ramsey Gurley wrote: >

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Yung-Luen Lan
Found the handling code here: https://github.com/wolips/wolips/blob/master/woproject-ant-tasks/src/java/org/objectstyle/woproject/ant/WOMapper.java Need to figure out how to fix this with least effort. Regards, yllan On Tue, Oct 18, 2011 at 12:12 AM, Yung-Luen Lan wrote: > My Cocoa bundle is i

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Yung-Luen Lan
My Cocoa bundle is included in the FileSet specified by woproject/resources.include.patternset. The problem is how the woapplication task handle it. According to wiki, http://wiki.objectstyle.org/confluence/display/WOL/WOProject-Localization Not localized resource should be copied to the resources

[MEETING] WO-NoVA TOMORROW 10/18/2011

2011-10-17 Thread Andrew Kinnie
Greetings all, This month's WO-NoVA meeting is scheduled for TOMORROW NIGHT at 6:30 at Mad Fox in Falls Church. RSVP appreciated! As indicated last week, we'll be having a relatively informal meeting where we can discuss whatever development related stuff we decide to, and open the floor/tab

Re: CLOSE_WAIT when database is offline

2011-10-17 Thread Philippe Rabier
I didn't play with it for a long time but you have to use the databaseContext delegate see http://webobjects.mdimension.com/hudson/job/Wonder/javadoc/er/extensions/eof/ERXDatabaseContextDelegate.html and implement your own policy (retry several times then gives up). However, if the web app sto

Re: Question about restrictedChoiceKey

2011-10-17 Thread Ramsey Gurley
On Oct 17, 2011, at 3:02 AM, Farrukh Ijaz wrote: > Hi, > > I've a situation. I've three entities: > > Country > CountryGroup > Customer > > The Customer has toOne relationship with Country and Country has toMany > relationship with CountryGroup. The customer doesn't know about CountryGroup >

Re: CLOSE_WAIT when database is offline

2011-10-17 Thread Alexander Spohr
Am 17.10.2011 um 16:19 schrieb Philippe Rabier: > Alexander, do you open a database connection each time the web app receives > an incoming request? No. But the app tries to reconnect when the database goes down. atze > > Philippe > > Sent from my iPhone > > On 17 oct. 2011, at 1

Re: Framework Not Building In Hudson/Jenkins

2011-10-17 Thread Ted Archibald
Got it working now, thanks for the help. After I placed the jars in the Libraries directory proper, everything built fine. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com

Re: CLOSE_WAIT when database is offline

2011-10-17 Thread Philippe Rabier
Alexander, do you open a database connection each time the web app receives an incoming request? Philippe Sent from my iPhone On 17 oct. 2011, at 14:54, Alexander Spohr wrote: > Hi list, > > we have a rather busy WO-service. Sometimes one of our multiple database > servers fails and CLOSE_W

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Kieran Kelleher
Fiddling with the woproject/resources.*.patternset files is how the contents of the Resources dir is specified for the build logic. In the build.xml, you can see this is in target build.woapp and resources declaration. So you can modify the the patternset files and/or directly modify the build x

CLOSE_WAIT when database is offline

2011-10-17 Thread Alexander Spohr
Hi list, we have a rather busy WO-service. Sometimes one of our multiple database servers fails and CLOSE_WAIT shows its ugly head and kills the performance. What I think the problem is: - WebServer asks AppServer for data - AppServer tries to connect to db - more requests come in - AppServer tr

Re: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Susanne Schneider
Hi Raymond, alas I have not much experience with using PL/SQL function through an eomodel. We are using most of our PL/SQL functions through JDBC directly. But the direction seems to be a very reasonable assumption. Oracle at least distinguishes between procedures (without return value) and

Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Raymond NANEON
Here is the columns of return array (an pl/sql structure) : create or replaceTYPE OBJ_ETUDIANT AS OBJECT (/* TODO enter attribute and method declarations here */ ID_ETU NUMBER(7),CIV_NOM VARCHAR2(77),NOM VARCHAR2(40),PRENOM VARCHAR2(30),DATE_NAIS VARCHAR2(10),COM_NAIS VARCHAR2(93),EMAIL VARCHAR2(10

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Yung-Luen Lan
Thanks. Now I have another build problem. If I move my command-line tool (actually, it's a cocoa app bundle without UI) under Resources, then the ant build process will move this file MyWOApp.woa/Contents/Resources/MyTools.app/Contents/Resources/Info.plist to MyWOApp.woa/Contents/Resources/Info.

Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Raymond NANEON
Hi Paul,See my attached pictures in others posts. You will see I define the stored procedure and his arguments. My problem is on external type. I know it's a table or array. But in WO, the EOAttribute don't know it. The EOAttribute use basic type of Oracle and not complexes types like object, array

Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Raymond NANEON
So how to declare column of the array as external Type?Envoyé depuis iCloudLe 17 oct 2011 à 03:33, Paul Yu 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 yo

Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Paul Yu
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 ar

Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Paul Yu
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. Paul On Oct 17, 2011, at 6:27

Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Raymond NANEON
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 t

Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

2011-10-17 Thread Paul Yu
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

Question about restrictedChoiceKey

2011-10-17 Thread Farrukh Ijaz
Hi, I've a situation. I've three entities: Country CountryGroup Customer The Customer has toOne relationship with Country and Country has toMany relationship with CountryGroup. The customer doesn't know about CountryGroup at all. In the Customer query page, I want to present the user list of

Re: Embed a external command-line tool in bundle

2011-10-17 Thread Johann Werner
Hi yllan, I would put that into the 'Resources' directory and use WOResourceManager.pathURLForResourceNamed( command-line-tool-name, // name of your tool null, // null if you put this into your app project null); // null as you are not interested in localized resources jw

Embed a external command-line tool in bundle

2011-10-17 Thread Yung-Luen Lan
Hi, I have some external command-line tools written by Objective-C that needs to be invoked in my wo app. Of course I could put them in somewhere like /usr/local/bin, etc. But I want to embed these command-line tools inside my wo app bundle so that people don't forget to copy the command-line to