Include ORDER BY cols in SELECT clause -------------------------------------- Key: JBAS-206 URL: http://jira.jboss.com/jira/browse/JBAS-206 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: CMP service Affects Versions: JBossAS-3.2.6 Final Reporter: SourceForge User Assigned To: Scott M Stark Fix For: Closed issues from sourceforge SourceForge Submitter: scoy . Some databases, Oracle in particular, require that columns named in an ORDER BY clause be included in the SELECT clause when SELECT DISTINCT is used. Here is some text from current Oracle documentation: Restrictions on the order_by_clause: * If you have specified the DISTINCT operator in this statement, then this clause cannot refer to columns unless they appear in the select list. * An order_by_clause can contain no more than 255 expressions. This can be worked around using on-find loading with load groups, but it sure would be useful if JBoss managed it for us.