Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySql to HQL

 
Mike Halford
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Chaps,
I have been using a query in Mysql ..



This won't work on planet Hibernate it complains about the operators in the Sum function. Any ideas on an HQL version of the query ?
Thanks




 
Francois Nadeau
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mike,

I am not sure what t2 refers to, but if you are still stuck on this you can use session's createSQLQuery function to query the database within a SQL function.

Cheers.
 
Mike Halford
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Francois Nadeau wrote:Hi Mike,

I am not sure what t2 refers to, but if you are still stuck on this you can use session's createSQLQuery function to query the database within a SQL function.

Cheers.


aha, t2 should've been t . Thanks. I've worked round it now using SQL functions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic