Hibernate Community • View topic - Problem with createSQLQuery and sum(x*y)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem with createSQLQuery and sum(x*y)

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

M.Eberhardt

Post subject: Problem with createSQLQuery and sum(x*y)

Posted: Sun Feb 03, 2008 12:06 pm

Newbie

Joined: Sat Dec 22, 2007 2:26 pm
Posts: 3

Hello!
I have a strage problem:

Code:

query = "select sum(amount*pricePerPiece), sum(amount) from ForecastValues";
         result = sess.createSQLQuery(query).list();

The columns sum(amount * pricePerPiece) and sum(amount) are completely identical! When I run that query directly on the Database, the result is correct.

any ideas?

Thanks a lot,

Michael

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