Hibernate Community • View topic - how to use left join to get collection size

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

how to use left join to get collection size

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

yehs220

Post subject: how to use left join to get collection size

Posted: Wed Oct 22, 2003 5:12 am

Newbie

Joined: Thu Aug 28, 2003 8:41 pm
Posts: 17

Code:

select count( elements(cat.kittens) ) from eg.Cat cat group by cat

This query use inner join

Code:

select count( elements(cat.kittens) ) from eg.Cat cat left join cat.kittens group by cat

This query generate sql like

Code:

select count(kittens2_.id) as x0_0_ from Cat cat0_ left outer join Cat kittens1_ on
 cat0_.id=kittens1_.parentId, Cat kittens2_ where cat0_.id=kittens2_.parentId group by  cat0_.id

Code:

select count( elements(kittens) )  from eg.Cat cat left join cat.kittens as kittens group by cat

This query does not work.

How can I do this?

Thanks in advance.

Top

gavin

Post subject:

Posted: Wed Oct 22, 2003 5:17 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

Code:

select count(kit) from Cat cat left join cat.kittens kit group by cat

Top

yehs220

Post subject:

Posted: Wed Oct 22, 2003 9:54 pm

Newbie

Joined: Thu Aug 28, 2003 8:41 pm
Posts: 17

Yeah, it does work, thanks.

Top

Page 1 of 1

[ 3 posts ]

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