Hibernate Community • View topic - Not able to get an MySQL statement transferred to HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Not able to get an MySQL statement transferred to HQL

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

jbegham

Post subject: Not able to get an MySQL statement transferred to HQL

Posted: Fri Apr 23, 2010 4:47 am

Newbie

Joined: Mon Jun 25, 2007 3:06 pm
Posts: 5

Hi all,

actually I am not able to transfer this MySQL statement to an HQL statement

Code:

SELECT count(*) / count(distinct month(c.created_date_time),year(c.created_date_time)) as averg
FROM comments c

My HQL lines are:

Code:

String hql = "select count(*) / count(distinct month(c.createdDateTime)) as avrg from Comment c";
Float averageBlogsPerYear = (Float) getSession().createQuery(hql).uniqueResult();

If I run it, Hibernate throws this exception:

Code:

org.hibernate.hql.ast.QuerySyntaxException: expecting CLOSE, found '(' near line 1, column 39 [select count(*) / count(distinct month(c.createdDateTime)) as avrg from Comment c

Actually I am lost a bit. Would appreciate any help on this.

Thanks in advance
John

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