• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL to Hibernate HQL conversion error

 
Brinsley Dcunha
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The following query works perfectly in MySQL but when I convert it to Hibernate HQL,
I get the following error :


ERROR PARSER line 1:128: unexpected token: (
ERROR PARSER line 1:172: unexpected token: count



Is there any solution to this ?
Thank you in advance for your help !
 
Vijitha Kumara
Bartender
Posts: 3913
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What changes/modifications have you done to this HQL from your SQL? Perhaps you may post the SQL too?
 
Brinsley Dcunha
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used the same SQL for the HQL conversion...no changes.
Thanks !
Brinsley
 
Cj Recto
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is also one of my problem. I dont know if it is possible in HQL.

This one is a simple query to illustrate,

SQL:


In HQL however, you cannot directly used the same concept, I dont know why, or if it is possible,
hope someone could actually have an answer to this.




 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic