Hibernate Community • View topic - Criteria query with join and group by

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria query with join and group by

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

ckkid

Post subject: Criteria query with join and group by

Posted: Thu Jul 10, 2008 1:01 pm

Newbie

Joined: Thu Jul 10, 2008 12:56 pm
Posts: 1

I would like to write the following query in Criteria but I can't write the correct code.

Code:

select * from a left join b on a.ref=b.id group by a.id order by b.name

Class A
int id;
List<B> bs;
C c;

Class B
int id;
String name;

Class C
int id;
String name;

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