DB2 SQL Error: SQLCODE=-214, SQLSTATE=42822 using Hibernate

Solution verified - Updated on

Request a new translation or translation update

A translation for your language preference does not exist. Click below to request a translation for your selected language.

Submit request

Issue

  • An HQL typed query uses DISTINCT and ORDER BY where the ORDER BY columns include a column that cannot be mapped to the HQL return type

    SELECT DISTINCT employee FROM Employee employee, Task task ... ORDER BY employee.name, task.id
    
...

Subscriber Exclusive Content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content