Hibernate Community • View topic - Using + operator in Select clause

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

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

shaby775

Post subject: Using + operator in Select clause

Posted: Fri May 28, 2004 12:46 am

Regular

Joined: Tue Mar 23, 2004 2:10 am
Posts: 51

Hello,
I am trying to run following query
"Select new com.sequelsys.common.model.scheduling.ValueObject(sum(a.seqNum + a.myNum)) from AppointmentStatusModel a"

The SeqNum and myNum are both java.lang.Long. Hibernate gives me error that + is undefined alias . If i remove + it works ok butr i need to add both columns please help me

Regards,
Shoaib Akhtar

Top

_charles_

Post subject:

Posted: Fri May 28, 2004 3:26 am

Regular

Joined: Wed May 12, 2004 3:03 am
Posts: 51
Location: France

Hi,

Why don't you do it like this :

Code:

List result1  = session.find(from AppointmentStatusModel a);
Vector result2 = new Vector();
for (..;..;..){
 AppointmentStatusModel a = result1.get(i)
 result2.add(new com.sequelsys.common.model.scheduling.ValueObject(sum(a.seqNum + a.myNum));
}

Charles

Top

shaby775

Post subject:

Posted: Sun May 30, 2004 6:34 am

Regular

Joined: Tue Mar 23, 2004 2:10 am
Posts: 51

Hello,
Thanks Charles for your reply. I know that i can acheive the results through this way but it will severely hit performance. I need to iterate over all the resulted objects i saw the problem in hibernate Jira i hope that it will soon be resolved. I am using hibernate for quite some tme now and it is the best open source tool i have ever seen and this is the only problem i faced hope it will soon resolve and we can use expressions with aggregate function. Any of hibernate team member can give any time frame of resolution of this problem???
Regards,
Shoaib Akhtar

Top

Page 1 of 1

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