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.