A query selecting a JOIN identification variable defined for a single valued relationship field may result in invalid SQL.

For example:

SELECT c FROM Order o LEFT OUTER JOIN o.customer c

See https://glassfish.dev.java.net/issues/show_bug.cgi?id=638 for more information.

Solution

Select a state field from the related instance.

SELECT c.customerId FROM Order o LEFT OUTER JOIN o.customer c