Re: [OT] Restoring a FrontBase DB

2010-09-29 Thread Chuck Hill
On Sep 28, 2010, at 10:37 PM, Tim Worman wrote: On Sep 28, 2010, at 2:41 PM, Chuck Hill wrote: On Sep 28, 2010, at 2:27 PM, Mike Schrag wrote: He's active on Twitter, @tuparev Dude. I don't twitter. i don't believe it -- http://twitter.com/chillatgvc ms :-) Well, you gotta

database concept help

2010-09-29 Thread Theodore Petrosky
I am altering a project (adding a relation) and I don't understand the Flatten relationship option. this will be a many to many. I just don't understand what flattening does. I started googling and so far the answers don't click. what's happening in a flattened vs an un-flattened relationship.

Re: database concept help

2010-09-29 Thread Pascal Robert
Le 2010-09-29 à 06:42, Theodore Petrosky a écrit : I am altering a project (adding a relation) and I don't understand the Flatten relationship option. this will be a many to many. I just don't understand what flattening does. I started googling and so far the answers don't click.

REST routes in JavaMonitor

2010-09-29 Thread Pascal Robert
Good morning! Yesterday, I committed REST routes inside JavaMonitor, this is the stuff that was demonstrated at WOWODC 2010. With those routes + the direct actions Anjo added last year, you can control almost everything remotely (make sure JavaMonitor is not open to the world!). The code was

Re: REST routes in JavaMonitor

2010-09-29 Thread David Avendasora
On Sep 29, 2010, at 6:55 AM, Pascal Robert wrote: Good morning! Yesterday, I committed REST routes inside JavaMonitor, this is the stuff that was demonstrated at WOWODC 2010. With those routes + the direct actions Anjo added last year, you can control almost everything remotely (make

Re: database concept help

2010-09-29 Thread Theodore Petrosky
so I am creating a little test. I have a People and a Job entity. attributes: People has a personName attribute and Job has a jobtitle I created the many to many selecting the Flatten Relationship option. I get a new entity: PeopleJob so far so good. I see in _Job.java a method:

UNIQUE constraint on Entity Modeler

2010-09-29 Thread Miguel Arroz
Hi! I had the idea I saw, in some W(O)W(O)DC, someone talking about having a unique checkbox on Entity Modeler for a property. That would make the generated SQL have the UNIQUE constraint to the DB. Did I dream about this, or is it real? I can not find it anywhere. Regards, Miguel

Re: database concept help

2010-09-29 Thread Paul D Yu
Ted Conceptually, if the association entity (PeopleJob) is just that an association between the two EO's and no other attributes are on the the association then Flatten is good. However, if you have another attribute such as isPrimary on the PeopleJob or startDate then flatten would not be

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Kieran Kelleher
inline: NEwEntityIndex.jpg Constraint setting on the index can then be set to 'Distinct' (which I assume is unique in database speak). Not sure if this works for all database platforms though. On Sep 29, 2010, at 9:35 AM, Miguel Arroz wrote: Hi! I had the idea I saw, in some W(O)W(O)DC,

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Miguel Arroz
Hi! Thanks! Doesn't seem to work on PostgreSQL. :( Regards, Miguel Arroz On 2010/09/29, at 14:43, Kieran Kelleher wrote: NEwEntityIndex.jpg Constraint setting on the index can then be set to 'Distinct' (which I assume is unique in database speak). Not sure if this works for all

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Ramsey Gurley
http://developer.apple.com/legacy/mac/library/documentation/InternetWeb/Reference/WO542Reference/com/webobjects/eoaccess/EOEntityIndex.html EOEntityIndex is new in 5.4.x and would require plugin support for it to work. I assume that is at least one of the reasons why it does not work with

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Kieran Kelleher
I am guessing is needs to be implemented in the appropriate db platform plugin or SQLHelper class in Wonder. it is probably implemented in FB since that probably would have been what Mike S was using when he added that feature. On Sep 29, 2010, at 9:48 AM, Miguel Arroz wrote: Hi!

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Kieran Kelleher
OK, well in that case, the new WO54 wonder branch is an opportunity for someone with time on their hands to implement it ;-) -Kieran On Sep 29, 2010, at 10:00 AM, Ramsey Gurley wrote:

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Mike Schrag
the bigger issue is that the 5.3 and 5.4 schema generation API's aren't compatible, so if you use the 5.3 API's, you hit these weird API paths that bypass certain features. it's kind of a mess. currently migrations and entity modeler both use the 5.3 API's. now that we have a 5.4 branch, we can

Re: REST routes in JavaMonitor

2010-09-29 Thread Kieran Kelleher
Good job Robert, er, sorry I meant Elvis ;-) On Sep 29, 2010, at 6:55 AM, Pascal Robert wrote: Good morning! Yesterday, I committed REST routes inside JavaMonitor, this is the stuff that was demonstrated at WOWODC 2010. With those routes + the direct actions Anjo added last year, you can

Re: REST routes in JavaMonitor

2010-09-29 Thread Pascal Robert
Le 2010-09-29 à 10:10, Kieran Kelleher a écrit : Good job Robert, er, sorry I meant Elvis ;-) Just a note, it's not for Elvis the singer, it's for Elvis Gratton : http://www.youtube.com/watch?v=FVHs12e-Fgc On Sep 29, 2010, at 6:55 AM, Pascal Robert wrote: Good morning!

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Mike Schrag
i don't think FB does it either ... if entity modeler just called the 5.4 generation method, it would magically appear, probably. ms On Sep 29, 2010, at 10:03 AM, Kieran Kelleher wrote: I am guessing is needs to be implemented in the appropriate db platform plugin or SQLHelper class in

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Chuck Hill
On Sep 29, 2010, at 7:00 AM, Ramsey Gurley wrote: http://developer.apple.com/legacy/mac/library/documentation/InternetWeb/Reference/WO542Reference/com/webobjects/eoaccess/EOEntityIndex.html EOEntityIndex is new in 5.4.x and would require plugin support for it to work. I assume that is at

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Ramsey Gurley
On Sep 29, 2010, at 11:41 AM, Chuck Hill wrote: On Sep 29, 2010, at 7:00 AM, Ramsey Gurley wrote: http://developer.apple.com/legacy/mac/library/documentation/InternetWeb/Reference/WO542Reference/com/webobjects/eoaccess/EOEntityIndex.html EOEntityIndex is new in 5.4.x and would require

Re: UNIQUE constraint on Entity Modeler

2010-09-29 Thread Mike Schrag
http://developer.apple.com/legacy/mac/library/documentation/InternetWeb/Reference/WO542Reference/com/webobjects/eoaccess/EOEntityIndex.html EOEntityIndex is new in 5.4.x and would require plugin support for it to work. I assume that is at least one of the reasons why it does not work with

Re: REST routes in JavaMonitor

2010-09-29 Thread Joe Little
I'm not dead yet! I think I'll go for a walk... (thump) Yes, my pre-burial grave site just had a small earth tremor. Busy finishing up old projects and about to jump back into the latest 3.6.1 w/ Wonder 5.4 branch goodness for ERModern stuff. Hopefully its not breaking daily at this point. D2W

Current Status of WO

2010-09-29 Thread Alexander Spohr
Hi list, I am planning a new project with heavy load. No HTML output, just plists. Lots of users, small data footprint (about 10k per request). PostgreSQL. I consider using WO and EOF again because it served me well in the last (almost) 15 years. But I am not sure about the current status. The

Re: Current Status of WO

2010-09-29 Thread Pascal Robert
Le 2010-09-29 à 14:28, Alexander Spohr a écrit : Hi list, I am planning a new project with heavy load. No HTML output, just plists. Lots of users, small data footprint (about 10k per request). PostgreSQL. I consider using WO and EOF again because it served me well in the last (almost)

Re: Current Status of WO

2010-09-29 Thread Chuck Hill
On Sep 29, 2010, at 11:28 AM, Alexander Spohr wrote: Hi list, I am planning a new project with heavy load. No HTML output, just plists. Lots of users, small data footprint (about 10k per request). PostgreSQL. I consider using WO and EOF again because it served me well in the last

Re: Current Status of WO

2010-09-29 Thread Paul D Yu
And for you app, you may want to look at ERRest framework. Paul On Sep 29, 2010, at 2:31 PM, Chuck Hill wrote: On Sep 29, 2010, at 11:28 AM, Alexander Spohr wrote: Hi list, I am planning a new project with heavy load. No HTML output, just plists. Lots of users, small data footprint

Re: [Wonder-disc] ERXNavigationMenu - can you have more than one?

2010-09-29 Thread Mark Wardle
Hi Tim, Sorry to be slow replying; day job busy at present! My NavigationMenu.plist looks like this: ( { name = Root; children = (Home, Patients, Reports / letters, Families, Biobank, Messages, My profile, Admin, Logout); }, {

Re: Single stack optimistic lock exception?

2010-09-29 Thread Mark Ritchie
On 24/Sep/2010, at 11:37 AM, Alan Ward wrote: My vote is that you are crazy. :-) This becomes an issue in apps where users concurrently edit the same object. Out of the box, it is last in wins and the second user to save gets no warning that what they are actually editing is not what

Re: Single stack optimistic lock exception?

2010-09-29 Thread Ken Anderson
I spoke to our Oracle guy, and he says that we should maintain one connection to one server, so it shouldn't be possible for us to get one record from one, and a different from the other. So much for that idea! On Sep 24, 2010, at 12:58 PM, Miguel Arroz wrote: It's Oracle RAC, so yes, a

Re: Single stack optimistic lock exception?

2010-09-29 Thread Miguel Arroz
Hi! On 2010/09/29, at 21:31, Mark Ritchie wrote: (Who's now back from traveling and working through the e-mail backlog. ;-) I was starting to get worried about you! ;) Regards, Miguel Arroz ___ Do not post admin requests to the list. They will

Re: Single stack optimistic lock exception?

2010-09-29 Thread Mike Schrag
My vote is that you are crazy. :-) This becomes an issue in apps where users concurrently edit the same object. Out of the box, it is last in wins and the second user to save gets no warning that what they are actually editing is not what they were looking at. Right, but there are

Re: Single stack optimistic lock exception?

2010-09-29 Thread Mark Ritchie
On 29/Sep/2010, at 1:39 PM, Mike Schrag wrote: My vote is that you are crazy. :-) This becomes an issue in apps where users concurrently edit the same object. Out of the box, it is last in wins and the second user to save gets no warning that what they are actually editing is not what

Re: Single stack optimistic lock exception?

2010-09-29 Thread Mike Schrag
My vote is that you are crazy. :-) This becomes an issue in apps where users concurrently edit the same object. Out of the box, it is last in wins and the second user to save gets no warning that what they are actually editing is not what they were looking at. Right, but there are

Maybe out of the Loop

2010-09-29 Thread Gino Pacitti
Hi List I just read this morning on a thread about state of WO. I have great confidence it the future but was not sure if I misread something. Has Apple ceased active development of WO and is it now in the hands of the WO Community with projects such as WONDER? Does Apple support its

Re: Single stack optimistic lock exception?

2010-09-29 Thread Mark Ritchie
On 29/Sep/2010, at 1:46 PM, Mike Schrag wrote: so we are in agreement :) Sure, I'll go with that! ;-) M. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)

Re: Maybe out of the Loop

2010-09-29 Thread Ramsey Gurley
On Sep 29, 2010, at 4:49 PM, Gino Pacitti wrote: Hi List I just read this morning on a thread about state of WO. I have great confidence it the future but was not sure if I misread something. Has Apple ceased active development of WO and is it now in the hands of the WO Community with

Re: Maybe out of the Loop

2010-09-29 Thread Chuck Hill
On Sep 29, 2010, at 1:49 PM, Gino Pacitti wrote: Hi List I just read this morning on a thread about state of WO. I have great confidence it the future but was not sure if I misread something. Has Apple ceased active development of WO and is it now in the hands of the WO Community with

Patched MySQL plugin

2010-09-29 Thread Pascal Robert
Hello everyone, I patched MySQLPlugin locally with the patch that Simon McLean submitted 5 days ago (JIRA WONDER-600, http://issues.objectstyle.org/jira/browse/WONDER-600). If you use MySQL, can you try this version and let us know if the patch is working for you?

Re: Patched MySQL plugin

2010-09-29 Thread Louis Demers
Hi, not really any of my business but am I the only one who finds this approach unsettling ? NSTimestamps are points in time. They are not NSDatestamps. Why mess with the comparison by setting to zero hours, minute and seconds ? Why not just minutes and seconds or again, may be dates too so

Re: Patched MySQL plugin

2010-09-29 Thread Paul Hoadley
On 30/09/2010, at 10:21 AM, Louis Demers wrote: In my app, when that's the behaviour I want, I zero out the data before writing it to the database so that subsequent checks for equality will return values... FWIW, I've found that the only clean solution to this problem is to abandon using

Re: Patched MySQL plugin

2010-09-29 Thread Ramsey Lee Gurley
On Sep 29, 2010, at 9:40 PM, Paul Hoadley wrote: On 30/09/2010, at 10:21 AM, Louis Demers wrote: In my app, when that's the behaviour I want, I zero out the data before writing it to the database so that subsequent checks for equality will return values... FWIW, I've found that the

Re: Patched MySQL plugin

2010-09-29 Thread Chuck Hill
Piling on here. As Louis pointed out, NSTimestamps are points in time. Messing with that in prototypes is a Bad Idea. You will regret. Have you crossed a DST boundary yet in your testing? And making one database behave differently than others seems at least unwise. If you want a calendar

Re: Patched MySQL plugin

2010-09-29 Thread Ken Anderson
An NSTimestamp represents a point in time, as has been stated. Making it behave differently is a bad idea. I have a set of methods that determine today's date in GMT, and store things that are dates that way. I've never had a problem. I pull out the year, month, and day from a timestamp

Re: Patched MySQL plugin

2010-09-29 Thread Chuck Hill
You are not making me hate dates any less. :-) On Sep 29, 2010, at 8:15 PM, Ken Anderson wrote: An NSTimestamp represents a point in time, as has been stated. Making it behave differently is a bad idea. I have a set of methods that determine today's date in GMT, and store things that

Re: Patched MySQL plugin

2010-09-29 Thread Ken Anderson
Sorry Chuck - I hate them too :) On Sep 29, 2010, at 11:17 PM, Chuck Hill wrote: You are not making me hate dates any less. :-) On Sep 29, 2010, at 8:15 PM, Ken Anderson wrote: An NSTimestamp represents a point in time, as has been stated. Making it behave differently is a bad