Hibernate Community • View topic - hibernate criteria add count rows

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

hibernate criteria add count rows

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

SubaroMows

Post subject: hibernate criteria add count rows

Posted: Mon Sep 15, 2014 9:35 am

Newbie

Joined: Mon Jul 29, 2013 5:31 am
Posts: 3

I have two class User and Toy.
How i can do sql:

Code:

SELECT user.name, user.mail, ..., COUNT(SELECT COUNT(*) FROM Toy WHERE Toy.userId = user.id)
FROM User

Code:

Criteria criteria = session.createCriteria(User.class,"user");
...

Help me, I don't load all Toy on server and when calc size Toy Collection

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