http://issues.objectstyle.org/jira/browse/WONDER-439
It's a direct copy of the method used by Postgress and FrontBase's plugins. I've tested it with our stuff and it seems to work perfectly. Dave On Dec 29, 2009, at 2:19 PM, Andrew R. Kinnie wrote: > Thanks to Dave Avendasora, we have apparently fixed the issue by patching the > Oracle plugin to properly handle distinct and sorting in > ERXBatchingDisplayGroups. > > He will file a jira with his patch. > > Andrew > > > On Dec 28, 2009, at 3:06 PM, Chuck Hill wrote: > >> And the qualifiers are what controls what SQL is generated. It could also >> be the way the DG is combining the qualifiers internally. Maybe try >> creating the OR externally and just setting one combined qualifier on the >> DG. If that does not work, consider dropping the ERXKey stuff and build it >> using the Wonder qualifiers directly. You might need to re-state the query. >> >> >> Chuck >> >> >> On Dec 28, 2009, at 10:20 AM, Andrew R. Kinnie wrote: >> >>> Also, the reason I point out the distinct/sorting issue is that the >>> generated SQL uses an order by in the outer select, and if you add distinct >>> in the inner select, it's not including the attributes required by the >>> order by, but only the id attribute. Thus, Oracle raises an error, because >>> the distinct select must contain all the attributes used by the order by. >>> If I run the sql separately, I get the same error, and if I add the order >>> by attributes manually to the SQL, I get the correct result. >>> >>> Andrew >>> >>> >>> On Dec 28, 2009, at 12:53 PM, Chuck Hill wrote: >>> >>>> >>>> On Dec 28, 2009, at 9:06 AM, Andrew R. Kinnie wrote: >>>> >>>>> As a followup, I get the correct number of rows if I comment out any code >>>>> which sorts the displayGroup using attributes other than the id column of >>>>> the entity populating the displayGroup. >>>>> >>>>> Without sorting, and with setUsesDistinct(true); I get 23 rows. >>>>> Navigation works. >>>>> >>>>> If I then try to sort the displayGroup (using in this case the entity's >>>>> lastname then firstname attributes) I get the oracle error, because the >>>>> inner most select statement generated by Wonder/EOF has a distinct, but >>>>> is trying to orderby attributes that are in the outermost select but not >>>>> the inner most select where the distinct statement is. >>>>> >>>>> Is this a bug in Wonder where setUsesDistinct(true); does not work with >>>>> sorting? >>>>> >>>>> Am I missing something? >>>> >>>> >>>> What is the qualifier? If you are using one of the Wonder qualifiers, you >>>> may have found a bug or may be using them incorrectly. >>>> >>>> >>>> Chuck >>>> >>>> -- >>>> Chuck Hill Senior Consultant / VP Development >>>> >>>> Practical WebObjects - for developers who want to increase their overall >>>> knowledge of WebObjects or who are trying to solve specific problems. >>>> http://www.global-village.net/products/practical_webobjects >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >> >> -- >> Chuck Hill Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase their overall >> knowledge of WebObjects or who are trying to solve specific problems. >> http://www.global-village.net/products/practical_webobjects >> >> >> >> >> >> >> > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com > > This email sent to [email protected] > > David Avendasora Senior Software Engineer K12, Inc. ***** WebObjects Documentation Wiki : http://wiki.objectstyle.org/confluence/display/WO/ ***** WebObjects API: http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html ***** _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
