When I write a hql query like: I get exception : org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
Could someone please help me with this? If I don't use aggregate function min() then I get valid data with the rest of the query kept same but retrieving other column (Other than subscriberID) values from Subscriber table like say subscriberName. So I guess it is a problem with generator class="sequence"
The project is already in production and I cannot change the mappings just for the enhancement issue I am working on. So could you suggest some solution? Thanks.
[ October 21, 2008: Message edited by: Amit kull ]
[ October 21, 2008: Message edited by: Amit kull ] [ October 21, 2008: Message edited by: Amit kull ]
Thanks, Paul. But the comma is not there in actual code. I just made typo while posting the topic here. I will now edit the query. Meanwhile let me know any other probable causes of this exception. Thanks, again.
joke time: What is brown and sticky? ... ... ... A stick! Use it to beat this tiny ad!