Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 10:19 PM, Guido Neitzer wrote: On 18.12.2008, at 21:26, Chuck Hill wrote: FB might have fixed that. I am pretty sure that someone was complaining about the OR vs IN difference being quite significant. That might have been FB 3. You know us old folks, we all live in

Re: optimization/indexing

2008-12-18 Thread Guido Neitzer
On 18.12.2008, at 21:26, Chuck Hill wrote: FB might have fixed that. I am pretty sure that someone was complaining about the OR vs IN difference being quite significant. That might have been FB 3. You know us old folks, we all live in the past. ;-) I'm not sure on OR vs. IN, but Front

Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:40 PM, Jeff Schmitz wrote: Does WinAnalysis.comboTeamID have an index? I'd guess that it does and that the index is corrupt. Or that is one VERY large table and there is no index. If you can get FrontBase to use an IN instead of ORs that will also make it faster, b

Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:36 PM, Jeff Schmitz wrote: I can agree that it's more a "collection" than a "relation", but what I don't understand is, how is a "collection" implemented differently than a "relationship" in EOModeler? Somewhere along the line I got the idea that using the "MutableA

Re: optimization/indexing

2008-12-18 Thread Jeff Schmitz
Just one varchar50 and a handful of ints. On Dec 18, 2008, at 10:39 PM, Clark Mueller wrote: LOB refers to large object (i.e. a blob or clob type). Are any of those columns in WinAnalysis a blob or a clob? II am guessing not, from the column names I see there... but if you are, and you're

Re: optimization/indexing

2008-12-18 Thread Jeff Schmitz
Does WinAnalysis.comboTeamID have an index? I'd guess that it does and that the index is corrupt. Or that is one VERY large table and there is no index. If you can get FrontBase to use an IN instead of ORs that will also make it faster, but you have some kind of hunka burning serious SQL

Re: optimization/indexing

2008-12-18 Thread Clark Mueller
LOB refers to large object (i.e. a blob or clob type). Are any of those columns in WinAnalysis a blob or a clob? II am guessing not, from the column names I see there... but if you are, and you're fetching 189 blobs, I would think that could possibly be a contributor. Clark On 18-Dec-08, a

Re: optimization/indexing

2008-12-18 Thread Jeff Schmitz
I can agree that it's more a "collection" than a "relation", but what I don't understand is, how is a "collection" implemented differently than a "relationship" in EOModeler? Somewhere along the line I got the idea that using the "MutableArray" prototype was bad juju, so if not that, and

Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 7:41 PM, Jeff Schmitz wrote: By consider a different design, do you mean something like the below (from the wiki)? Coming form an OO world, I perhaps took the paradigm too far and chopped up my data into too many tables? I'd consider going a step back before that and r

Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:22 PM, Mike Schrag wrote: Does WinAnalysis.comboTeamID have an index? I'd guess that it does and that the index is corrupt. Or that is one VERY large table and there is no index. If you can get FrontBase to use an IN instead of ORs that will also make it faster, bu

Re: optimization/indexing

2008-12-18 Thread Mike Schrag
Does WinAnalysis.comboTeamID have an index? I'd guess that it does and that the index is corrupt. Or that is one VERY large table and there is no index. If you can get FrontBase to use an IN instead of ORs that will also make it faster, but you have some kind of hunka burning serious SQL

Re: optimization/indexing

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:11 PM, Jeff Schmitz wrote: "LOBs"? Sorry, I'm not familiar with that term. I have set the EOAdaptorDebugEnabled flag. Below is the output from a ERXBatchFetchUtilities.batchFetch call that takes 94 seconds. It's traversing something like a 1 to 65 to 2 relationship

Re: optimization/indexing

2008-12-18 Thread Jeff Schmitz
"LOBs"? Sorry, I'm not familiar with that term. I have set the EOAdaptorDebugEnabled flag. Below is the output from a ERXBatchFetchUtilities.batchFetch call that takes 94 seconds. It's traversing something like a 1 to 65 to 2 relationship. Dec 18 20:48:38 netBrackets[2001] (ERXNSLogLog4

Re: optimization/indexing

2008-12-18 Thread Clark Mueller
Jeff, What does your model/database schema actually look like? Have you tried setting EOAdaptorDebugEnabled to true in your launch config (or via property)? How do the LOBs fit into your design? Clark On 18-Dec-08, at 7:41 PM, Jeff Schmitz wrote: By consider a different design, do you

Re: optimization/indexing

2008-12-18 Thread Jeff Schmitz
By consider a different design, do you mean something like the below (from the wiki)? Coming form an OO world, I perhaps took the paradigm too far and chopped up my data into too many tables? e.g. Would denormalizing my 1 --> 65 --> 2 tables into a single table help? Or would a better

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Mike Schrag
This is probably better on the Wonder list as this seems to be a Wonder issue. It might be that your Wonder code needs to be updated. The line numbers below are not close to what is in the head. out of date most likely but also this is almost certainly a 5.4/5.3 problem and that you have th

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Chuck Hill
Hi Mark, This is probably better on the Wonder list as this seems to be a Wonder issue. It might be that your Wonder code needs to be updated. The line numbers below are not close to what is in the head. On Dec 18, 2008, at 1:59 PM, Mark Morris wrote: I see my ERExtensions says it's at

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Mark Morris
I see my ERExtensions says it's at version 4.0.0.500. More on the error itself: java.lang.RuntimeException: computeQueryDictionaryInContext failed. at er.extensions.ERXWOForm._appendHiddenFieldsToResponse(ERXWOForm.java: 228) at er.extensions.ERXWOForm.appendChildrenToResponse(ERXWO

Re: WebObjects 4.5.1

2008-12-18 Thread Andrew Sardone
> > On Dec 17, 2008, at 10:05 AM, dfles...@oceanobjects.com wrote: > >> I have an old WOF Objective-C code application that I would like to revive >> and convert to Java and WO 5.X However, I would like to get the old version >> running again running again before converting it. >> >> However, I ca

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Chuck Hill
Is there a stack trace? A more complete error message? Chuck On Dec 18, 2008, at 1:29 PM, Mark Morris wrote: I'm struggling with the exact same error right now, and also have the console message symptoms Randall mentions. I was thinking perhaps I have incompatible versions of something.

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Mark Morris
I'm struggling with the exact same error right now, and also have the console message symptoms Randall mentions. I was thinking perhaps I have incompatible versions of something. Here's what I have (after trying to update everything to see if it would help): WebObjects 5.4.3

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 12:16 PM, Randall Perry wrote: The 5.4 _source_ version of Wonder needs the New Hotness version of WOLips if you are building it. And that needs Eclipse 3.4. If you just have the binary install, then either one should be fine. It's just the binary. Where did you in

Re: computeQueryDictionaryInContext error

2008-12-18 Thread Randall Perry
> The 5.4 _source_ version of Wonder needs the New Hotness version of WOLips if > you are building it. And that needs Eclipse 3.4. If you just have the binary > install, then either one should be fine. It's just the binary. > > Where did you install them? /Library/Frameworks, as instructed in t

Re: casting in qualifier format strings

2008-12-18 Thread Florijan Stamenkovic
On Dec 18, 2008, at 12:22, Mike Schrag wrote: How in the world did you discover this?!? You didn't actually try to do it??? I can pretty much guarantee this did not come from the current documentation. :-P Um .. yeah .. Unless you consider digging through decompiled javacc- generated parse

Re: [ANN] WOGWT framework for integrating GWT with WebObjects

2008-12-18 Thread JR Ruggentaler
I can't find method WOGWTServerUtil.extractUpdateContainerFromResponse(request, response) in WOGWT (wogwt.jar: wogwt/WOGWTServerUtil.class). Below is the "WOGWT - Getting Started" doc which says to add the dispatchRequest() method to your application subclass. 8) Add this function to your

Re: Two directActions on one form

2008-12-18 Thread David Holt
Thanks Cail, That solved it! David On 18-Dec-08, at 4:24 AM, Cail Borrell wrote: Hi David, It should work if you add the actionClass="DirectAction" binding the form component. -Cail On 18/12/2008, at 02.34, David Holt wrote: I must be missing something basic, but I am doing simple logi

Re: casting in qualifier format strings

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:22 AM, Mike Schrag wrote: How in the world did you discover this?!? You didn't actually try to do it??? I can pretty much guarantee this did not come from the current documentation. :-P Um .. yeah .. Unless you consider digging through decompiled javacc- generated par

Re: casting in qualifier format strings

2008-12-18 Thread Mike Schrag
How in the world did you discover this?!? You didn't actually try to do it??? I can pretty much guarantee this did not come from the current documentation. :-P Um .. yeah .. Unless you consider digging through decompiled javacc- generated parser code "documentation" ... I mean ... it SORT of

Re: casting in qualifier format strings

2008-12-18 Thread Chuck Hill
On Dec 18, 2008, at 8:12 AM, Florijan Stamenkovic wrote: Cool... How in the world did you discover this?!? You didn't actually try to do it??? I can pretty much guarantee this did not come from the current documentation. :-P Chuck On Dec 18, 2008, at 00:12, Mike Schrag wrote: I v

Re: casting in qualifier format strings

2008-12-18 Thread Florijan Stamenkovic
Cool... How in the world did you discover this?!? You didn't actually try to do it??? F On Dec 18, 2008, at 00:12, Mike Schrag wrote: I very rarely use qualifier format strings, but i have a special case where I needed one, but i needed a timestamp literal in it ... turns out you can ca

stable

2008-12-18 Thread Jeremy Matthews
Has the new rev of WOLips been deemed "stable"? I've been out of the office...lots of folks seemed to have moved - like to get the installer into the public if that is the case. Thanks, jeremy ___ Do not post admin requests to the list. They will be

Re: Unlocking thread not owner deadlock from an Ajax Updating Container

2008-12-18 Thread Mike Schrag
I'm pretty sure I have nothing else happening in any of my own self created threads. I've disabled concurrent request handling. EditingContexts are created from ERXEC.newEditingContext() with one tied to each user session . I'm not using defaultEditingContext() and have ERXECs autolocking t

Unlocking thread not owner deadlock from an Ajax Updating Container

2008-12-18 Thread Paul Stringer
Hi all, I'm encountering a deadlock situation when using an Ajax Update container which triggers the exception and stacktrace below. I'm wondering if it's been encountered before and if someone could point to where I might be going wrong and possible causes. It appears to come fairly consis

Re: Two directActions on one form

2008-12-18 Thread Cail Borrell
Hi David, It should work if you add the actionClass="DirectAction" binding the form component. -Cail On 18/12/2008, at 02.34, David Holt wrote: I must be missing something basic, but I am doing simple login form with two submit buttons. I used to have the form bound to a login direct ac