Hibernate Community • View topic - Group by and attributes

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Group by and attributes

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Saloucious

Post subject: Group by and attributes

Posted: Fri Sep 30, 2005 6:26 am

Newbie

Joined: Wed Aug 10, 2005 8:07 am
Posts: 14

Hibernate version:3.0.5

Hi,
just a question about group by.

When you have a query like that

Code:

Select A, sum(aliasB.propertiesXXX)
from A aliasA
join alias.BSet aliasB
group by A

Hibernate generates a query with in the GROUP BY only the property A.id
but in the same time it generates all properties in the SELECT

The first solution is to put all properties in the group by, but this is very boring!!!
is there any other solution ?

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