Hibernate Community • View topic - HQL sum() returns null in addition to the sum value

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL sum() returns null in addition to the sum value

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Leaf-Woods

Post subject: HQL sum() returns null in addition to the sum value

Posted: Thu Mar 15, 2012 3:41 pm

Newbie

Joined: Thu Mar 15, 2012 3:35 pm
Posts: 2

Hi All

I have a hql as "select sum(q.packagePrice) from Quote q"
This hql returns a list that has two elements. The first (list.get(0)) is null. The second (list.get(1)) is the correct value.
Can anybody tell me why I got the null value? The query list is supposed to have a single value right?

Thanks for your help.

Leaf

Top

Leaf-Woods

Post subject: Re: HQL sum() returns null in addition to the sum value

Posted: Mon Mar 19, 2012 10:11 am

Newbie

Joined: Thu Mar 15, 2012 3:35 pm
Posts: 2

Got the reason. The Quote class a child class RQuote. So the hql is run on both the parent and child objects. There is no relationship defined in Quote.hbm.xml or RQuote.hbm.xml. Just RQuote.java is defined as extends Quote. The default lazy fetching is used. Anybody knows how to prevent the child object being queried? Thanks

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