Hibernate Community • View topic - Using operator '*' in select clause for sum(a*b)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using operator '' in select clause for sum(ab)

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

maly

Post subject: Using operator '*' in select clause for sum(a*b)

Posted: Fri Dec 17, 2004 5:51 am

Newbie

Joined: Fri Dec 17, 2004 5:37 am
Posts: 1

My problem
If I want send question :
select new SimplePositionDEPOValue(sum(p.giveAmt * p.giveAmtPer360), p.valueDateIn, count(*)) from PositionDEPOValue p group by p.valueDateIn

[STDOUT] net.sf.hibernate.PropertyNotFoundException: no appropriate constructor in class: SimplePositionDEPOValue.

What's wrong :
Similary question is good:
select new SimplePositionDEPOValue(sum(p.giveAmt + p.giveAmtPer360), p.valueDateIn, count(*)) from PositionDEPOValue p group by p.valueDateIn

Why don't operator '*' admit in agregate function sum()?

Mariusz Mach

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