Eclipse Community Forums: EclipseLink » QueryException occurs on an expression that is using getAllowingNull() on an aggregate attribute.

Home » Eclipse Projects » EclipseLink » QueryException occurs on an expression that is using getAllowingNull() on an aggregate attribute.(Exception Description: An outer join (getAllowingNull or anyOfAllowingNone) is only valid for OneToOne, OneToMany, ManyToMany, AggregateCollection and DirectCollection Mappings, and cannot be used for)

Show: Today's Messages :: Show Polls :: Message Navigator

QueryException occurs on an expression that is using getAllowingNull() on an aggregate attribute. [message #813661]

Mon, 05 March 2012 10:18

Dragomir Zoranovic
Messages: 7
Registered: February 2012

Junior Member

Hi,

I have query defined as follows:

ReadAllQuery query = new ReadAllQuery(User.class);
ExpressionBuilder eb = new ExpressionBuilder(User.class);
query.addOrdering(eb.getAllowingNull("aggregateUser").get("aggregateName"));

Attribute aggregateUser is defined as aggregate object of the object User.This query throws following QueryException:

Exception Description: An outer join (getAllowingNull or anyOfAllowingNone) is only valid for OneToOne, OneToMany, ManyToMany, AggregateCollection and DirectCollection Mappings, and cannot be used for the mapping [org.eclipse.persistence.mappings.AggregateObjectMapping].

Should I prevent using getAllowingNull() on agreggate attibutes? Or is there any another solution?

[Updated on: Mon, 05 March 2012 10:23]

Report message to a moderator