I ha开发者_Python百科ve a domain class Schedule with a property \'days\' holding comma separated values like \'2,5,6,8,9\'.
Any idea why this snippet of HQL would be failing.. REPLACE function requires three arguments is the error. Is t开发者_StackOverflow社区here any other way to perform a replace in HQL>?
This one is odd... I have an hql query that ignore the GOUP BY if ORDER BY is included. it will perform the query without the group by,
I\'d like to know if it\'s possible to specify a select clause in a from clause something like select count(*) as Y, this_.NAME as A, sel2.C
Is it possible to update user type field in HQL query? When I am trying to use user type in where clause everything works fine.
I have a query in HQL which fully works. However, I\'d like to have it expressed in the Criteria form, which is easier to read and maintain.
My databse is MS SQL. I want to use ROW_NUMBER() in HQL. Is it possible? How? I know about Custom Functions. But prefer a way that does no开发者_StackOverflow社区t need to modify web.config.
I would like to build a web interface to present logdata. This should be a nice opportunity to try to build a little web app using Grails, which I have been wanting to try out for quite a while, but 开
How can I write an HQL query like same SQL query like this: select * from User开发者_StackOverflow社区s u where u.id in (1, 3, 4)
I\'m using Hibernate 3.2.6 and I\'m attempting to make a query like so: select a, (select min(date) as someAlias from B b where a.id = b.id)