Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

probs with query

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jubs

Post subject: probs with query

Posted: Thu Apr 07, 2005 10:29 am

Newbie

Joined: Thu Apr 07, 2005 9:30 am
Posts: 1

hi
I am new to Hibernate and have just got a grasp of the basics...
I have added the following tag to my Event.hbm.xml

Code:

<property name="sum" 
          formula="(select sum(uid) from Events)"/>

and I have added the sum getter an setter methods. but i always get an error

Quote:

WARN - SQL Error: 0, SQLState: 42803
ERROR - ERROR: column "event0_.uid" must appear in the GROUP BY clause or be used in an aggregate function

which could be because I am already executing a query

Code:

"List result = session.createQuery("from Event").list();"

how do i get around this error and get get the sum from the query in the property tag

thnx for any help
jubs

Top

drj

Post subject:

Posted: Fri Apr 08, 2005 3:33 am

Expert

Joined: Fri Nov 07, 2003 4:24 am
Posts: 315
Location: Cape Town, South Africa

Code:

formula="(select sum(e.uid) from Events e group by e.uid)"

This is standard SQL

Top

Page 1 of 1

[ 2 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