Eclipse Community Forums: EclipseLink » jpa2.1 join on Criteria API

Help

Home

Home » Eclipse Projects » EclipseLink » jpa2.1 join on Criteria API(how to implement the JPQL using Criteria API)

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

jpa2.1 join on Criteria API [message #1079846]

Mon, 05 August 2013 06:37

ma soot

Messages: 3
Registered: August 2013

Junior Member

hi,

I have 2 entitis: TUser{id, name}, TUserFriend{id, userId, name}
the 2 talbe has PK but NO FK and NO one to many relation.

the new eclipselink2.5, i can run useing JPQL
"select u from TUser u join TUserFriend uf on u.id = uf.userId".

but i don't know how to implement using Criteria API.

Can u help me? Thanks a lot!

Soot.

Report message to a moderator

Re: jpa2.1 join on Criteria API [message #1080571 is a reply to message #1079846]

Tue, 06 August 2013 05:27

ma soot

Messages: 3
Registered: August 2013

Junior Member

None?

Report message to a moderator

Re: jpa2.1 join on Criteria API [message #1080879 is a reply to message #1080571]

Tue, 06 August 2013 13:40

Chris Delahunt

Messages: 1237
Registered: July 2009

Senior Member

The JPA 2.1 javax.persistence.criteria.Join interface defines 'on' methods you can use to get the same behavior:

CriteriaBuilder qb = jpaEM.getCriteriaBuilder();
CriteriaQuery<Employee>cq = qb.createQuery(Employee.class);
Root<Employee> root = cq.from(Employee.class);
Join address = root.join("manager", JoinType.LEFT).join("address", JoinType.LEFT);
address.on(qb.equal(address.get("city"), "Ottawa"));
cq.where(qb.isNotNull(address.get("postalCode")));

If not using JPA 2.1, you will need to cast to EclipseLink's JoinImpl class to access the 'on' methods, added in EclipseLink 2.5.

Report message to a moderator

Re: jpa2.1 join on Criteria API [message #1081407 is a reply to message #1080879]

Wed, 07 August 2013 07:41

ma soot

Messages: 3
Registered: August 2013

Junior Member

Thanks for Chris!
But this isn't what I want.

select u from TUser u join TUserFriend uf on u.id = uf.userId

Bz. NO FK, I want to define the relation using "on" : on u.id = uf.userId

the follow is eclipse doc
http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/j_on.htm#on

Usage

EclipseLink supports using the ON clause between two root level objects.

I just want to define the relation between two root level object. using JPQL, It's OK, but can't using Criteria API.

Report message to a moderator

Re: jpa2.1 join on Criteria API [message #1082398 is a reply to message #1081407]

Thu, 08 August 2013 14:17

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Criteria does not support this.

If you can't use JPQL, then you could use EclipseLink Expressions, which do support this, or mix them with the Criteria API.

http://java-persistence-performance.blogspot.com/2012/05/jpql-vs-sql-have-both-with-eclipselink.html

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Behaviour merge() of detached objects
Next Topic:	@AdditionalCriteria breaks on @LOB updates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 29 02:13:55 GMT 2017

.:: Contact :: Home ::.