Entity graph loading problem org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"

[dtaimanov]

Problem:

see JFCS-43
It looks like the same issue as eclipse-ee4j/eclipselink#1635

This issue sometimes occurs during value extraction from batch optimized query (org.eclipse.persistence.mappings.ForeignReferenceMapping#extractResultFromBatchQuery) when count of entities in OneToMany relation is equal to batch size (500 by default) and the same entities loaded through another references in the same graph.

Workaround:

When "IN" condition parameter is empty because required entity is already purged from cache add its id manually to load it explicitly again.