Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

MySql to HQL  RSS feed

 
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
Boost this thread!