Hibernate Community • View topic - JPA 2.0 Criteria order by path

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

JPA 2.0 Criteria order by path

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

ppareit

Post subject: JPA 2.0 Criteria order by path

Posted: Fri Jan 29, 2010 5:38 pm

Beginner

Joined: Fri Nov 11, 2005 4:35 pm
Posts: 23

Hi,

I have problems sorting a criteria.

Code:

   CriteriaBuilder builder = getEntityManager().getCriteriaBuilder();
   CriteriaQuery<Object[]> criteria = builder.createQuery(Object[].class);
   Root<GloCompany> gloCompanyRoot = criteria.from(GloCompany.class);

   Join<GloCompany,GloCompanyAddress> gloCompanyAddresses = gloCompanyRoot.join(GloCompany_.gloCompanyAddresses, JoinType.LEFT);
   Join<GloCompanyAddress,GloCompanyAddressLocale> gloCompanyAddressLocales = gloCompanyAddresses.join("gloCompanyAddressLocales", JoinType.LEFT);

   criteria.orderBy(builder.asc(gloCompanyRoot.get("gloCompanyAddresses.gloCompanyAddressLocales.name")));

I get the following error on line:
criteria.orderBy(builder.asc(gloCompanyRoot.get("gloCompanyAddresses.gloCompanyAddressLocales.name")));

Code:

java.lang.NullPointerException
   at org.hibernate.ejb.criteria.path.AbstractPathImpl.unknownAttribute(AbstractPathImpl.java:110)
   at org.hibernate.ejb.criteria.path.AbstractPathImpl.locateAttribute(AbstractPathImpl.java:218)
   at org.hibernate.ejb.criteria.path.AbstractPathImpl.get(AbstractPathImpl.java:189)
   at ....

I know i can do:
criteria.orderBy(builder.asc(gloCompanyAddressLocales .get("name")));
This will work.

I'm looking for a function to order a path given as string. (worked in hibernate criteria)

Thanks in advance,
Pieter Pareit

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum