If an entity is requested by a distinct query and the result should be ordered by an attribute of a joined entity of an e.g. of an OneToMany relation the query created by hibernate does not contain the order attribute in the result list. Databases like postgres and h2 reject to process this query.
This functinality is essential for many cases where data is filtered and ordered in paged tables with complex queries. |
|