Re: OT: SQL Question

2008-02-19 Thread John Baldwin
Something like this should work in MySQL, assuming datefield doesn't duplicate within table2 for a given t1key. select t1.a, t1.b, t1.c, t2.datefield from table1 t1 left outer join table2 t2 on t1.id = t2.t1key where ((t2.datefield = (select max(t2a.datefield) from tabl

Re: Eclipse and WebObjects Frameworks Javadocs

2008-02-19 Thread Les Vogel
Assuming you've got it installed, you'll find it at: file:///Developer/Documentation/DocSets/com.apple.ADC_Reference_Library.WebObjectsReference.docset/Contents/Resources/Documents/documentation/MacOSXServer/Reference/WO54_Reference/index.html If you don't, you may wish to download the WebObjects

Eclipse and WebObjects Frameworks Javadocs

2008-02-19 Thread Glenn Sequeira
I'm setting up a new WebObjects development system and have run into a problem with Eclipse unable to locate the WebObjects frameworks javadocs. I have followed the instructions of changing the path to the reference documentation in the 'wobuild.properties' file (http://lists.apple.com/archives/we

Re: MySQL 5.0 - note

2008-02-19 Thread Cheong Hee (Datasonic)
Kieran When started using MySQL, I opted for InnoDB after some good reading on its docs. Good advice on the other side of MyISAM and looks like it is lacking of referential integrity checking. I am still using free InnoDB, and practically done my configurations on own, that's including the

Re: OT: Surely they need wo developers

2008-02-19 Thread Chuck Hill
On Feb 19, 2008, at 3:14 PM, James Cicenia wrote: http://www.dubai-architecture.info/DUB-GAL1.htm WOW! Hard to eat up that much budget with WO. You would need J2EE and .Net for that. ;-) Chuck -- Practical WebObjects - for developers who want to increase their overall knowledge of

OT: Surely they need wo developers

2008-02-19 Thread James Cicenia
http://www.dubai-architecture.info/DUB-GAL1.htm WOW! Enjoy James Cicenia ___ 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

Unabled to find an EOClassDescription for objects of class (on application startup)

2008-02-19 Thread Brendan Duddridge
Hi, When we bounce our applications, for the first minute or so after the application has finished launching, we get a bunch of exceptions in our logs: Unabled to find an EOClassDescription for objects of class ca.shopshop.ssmodel.Media. The entity that has the problem varies for every

Re: EOF operation ordering

2008-02-19 Thread Chuck Hill
On Feb 19, 2008, at 9:01 AM, David Avendasora wrote: I'm using Chuck's extensions with MS SQL Server and they are a godsend. My database has all constraints turned on and WO orders its operations perfectly. I'm pretty sure VI works well, but soon after Chuck's fix I actually saw the light

Re: Progressively all threads go into deadlock

2008-02-19 Thread Chuck Hill
Hi Fabrice, On Feb 19, 2008, at 11:17 AM, Fabrice Pipart wrote: Thanks for the answer Chuck ! I ll add the stack traces below. We never lock anything else than EOEditingContext ... (ERXEC actually). We are thinking about a different thing : could it be a memory problem ? We are allocati

Re: Progressively all threads go into deadlock

2008-02-19 Thread Mike Schrag
Monitoring Thread: [1] java.net.SocketOutputStream.socketWrite0 (native method) [2] java.net.SocketOutputStream.socketWrite (SocketOutputStream.java:92) [3] java.net.SocketOutputStream.write (SocketOutputStream.java:136) [4] java.io.BufferedOutputStream.flushBuffer (BufferedOutputStre

Re: Database Independence

2008-02-19 Thread Andrew Lindesay
We just fixed the Prototypes to work like they used to work in WO 4.5 Thanks -- I've added that to the wiki. Prototypes also make the process of modeling 10x faster, btw Yes I can see this would be quite a bit faster -- I'll make a note to revisit this when there is a moment. cheers. __

Re: WOImage inline binding: src-attribute not recognized

2008-02-19 Thread Guido Neitzer
On 19.02.2008, at 10:56, Gavin Eadie wrote: There is an exact parallel failure with http://www.apple.com"; /> : Exception occurred while handling request: com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Main: 7:3: Could not generate an element named: WOHyperlin

Re: WOImage inline binding: src-attribute not recognized

2008-02-19 Thread Gavin Eadie
There is an exact parallel failure with http://www.apple.com"; /> : Exception occurred while handling request: com.webobjects.appserver.parser.woml.WOMLTemplateParserException: Main: 7:3: Could not generate an element named: WOHyperlink Caused by: com.webobjects.appserver._priv

Re: EOF operation ordering

2008-02-19 Thread David Avendasora
I'm using Chuck's extensions with MS SQL Server and they are a godsend. My database has all constraints turned on and WO orders its operations perfectly. I'm pretty sure VI works well, but soon after Chuck's fix I actually saw the light and got rid of my VI and switched to Single Table Inhe

Re: Progressively all threads go into deadlock

2008-02-19 Thread Chuck Hill
On Feb 19, 2008, at 8:59 AM, Fabrice Pipart wrote: Hi ! I am experiencing very annoying deadlock that happen both in development and deployment situations under load situations. It happens randomly. Progressively all threads go into deadlock. They all block on the same method : [1] sun.misc

Progressively all threads go into deadlock

2008-02-19 Thread Fabrice Pipart
Hi ! I am experiencing very annoying deadlock that happen both in development and deployment situations under load situations. It happens randomly. Progressively all threads go into deadlock. They all block on the same method : [1] sun.misc.Unsafe.park (native method) I cannot understand why

Re: Webobjects-dev Digest, Vol 5, Issue 213

2008-02-19 Thread Johann Werner
Am 18.02.2008 um 20:34 schrieb Mike Schrag: I'm using the most recent 3.3.2 build and I'm not seeing any performance issues with Debug As ... You're right. Apparently something got screwed up in my workspace directory. I switched to a new created one and imported all my projects into i

Re: EOF operation ordering

2008-02-19 Thread Pierre Bernard
In WO 4.5 to 5.1 it did work correctly for the purposes it was intended for. We added a delegate to improve sorting so that 2 concurrent injection processes could not dead lock each others. From the next project on, I used deferrable constraints. I don't know why, but it sure is convenien

Re: Database Independence

2008-02-19 Thread Mr. Pierre Frisch
We just fixed the Prototypes to work like they used to work in WO 4.5 i.e. when you change Database vendor we switch the Prototype definitions. This is done at model load time based on the connection dictionary of that model in the form EOJDBCFrontbasePrototypes. As Anjo pointed out the ord

Re: EOF operation ordering

2008-02-19 Thread Chuck Hill
I don't ever recall WO/EOF ordering the operations correctly in any dependable manner. Either you do it in your code, or it is subject to the whims of EOF implementation. I wrote these classes so that I could use MS SQLServer which does not support deferred constraints. See these Wonder cl

Re: EOF operation ordering

2008-02-19 Thread Mike Schrag
Chuck wrote an operation ordering delegate in Wonder to support MSSQL (which doesn't support deferrable) that might be helpful here. ms On Feb 19, 2008, at 10:43 AM, Dov Rosenberg wrote: We have had to resort to deferred constraints for Oracle. For SQL Server we have had to disable the cons

Re: EOF operation ordering

2008-02-19 Thread Dov Rosenberg
We have had to resort to deferred constraints for Oracle. For SQL Server we have had to disable the constraints. I am certainly interested in a more portable solution. Dov Rosenberg On 2/19/08 10:37 AM, "Pierre Bernard" <[EMAIL PROTECTED]> wrote: > Hi! > > Back in the day of WO 4.5 to WO 5.1,

EOF operation ordering

2008-02-19 Thread Pierre Bernard
Hi! Back in the day of WO 4.5 to WO 5.1, I worked on a project where we relied on EOF's capability to order database operations. Actually we even extended the mechanism using a database context delegate to apply further sorting to already sorted operations. On more recent projects, I alwa

Re: Database Independence

2008-02-19 Thread Mike Schrag
The workflow in Entity Modeler is optimized for using prototypes. Historical point here, actually ... This determined the choice of columns (and which ones are editable) in the table view in Entity Modeler. It's to encourage proper behavior by annoyance with the alternative :) In fact, the

Re: Database Independence

2008-02-19 Thread Mike Schrag
Prototypes also make the process of modeling 10x faster, btw ... Even if you don't switch databases at all, I recommend switching entirely to them. The workflow in Entity Modeler is optimized for using prototypes. ms On Feb 19, 2008, at 3:29 AM, Anjo Krank wrote: I presume it is a bit mo

Re: MySQL 5.0 - note

2008-02-19 Thread Kieran Kelleher
Cheong, I use this week's latest (5.0.51a) the original message to the list was inspired by reading the upgrade notes which say the last *statement* is rolled back in the event of a timeout by default unless you use the option given. InnoDB is free. My reference to paying was that if

Re: MySQL 5.0 - note

2008-02-19 Thread Cheong Hee (Datasonic)
Hi Andrew I could be wrong. Thought Kieren meant the new version:32 rolls back the entire transaction(s) if a timeout occurs for the last transaction. ...and therefore saveChanges will ensure all or none of the transactions will be committed into database. So no partial save. I am using ve

Re: Database Independence

2008-02-19 Thread Anjo Krank
I presume it is a bit more clever than just looking for an entity called EOJDBCAdaptorPrototypes and will somehow look for an entity with the JDBC plugin's name in it or something? We had this in Wonder for ages now... for us the lookup is: EOJDBCPostgresqlPrototypes EOJDBCPrototypes EOProt

AutoCompletion Problem in WOLIPS

2008-02-19 Thread Frank Gibau
Hey, Im using System 10.4.11, Eclipse Version: 3.3.1.1 and WO 5.4. In WOLips, in the WO-Component AutoCompletion does not work. In Java and HTML it works. Does anybody know which Preference I have to activate to get it back (it works before the Update of Eclipse) Thanks in advance Frank