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/archive%40mail-archive.com This email sent to [email protected]
