http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html#queryhql-subqueries Note that HQL subqueries can occur only in the select or where clauses. You can rewrite the query so that the subquery is part of the where clause instead. Referencing the l.idItem in the subquery
Currently, the theta-style on joining the unrelated classes in the where clause using HQL only supports inner join. The request for supporting the outer join for such situation is currently the 3-rd most voted enhancement but I don’t think this feature will be implemented in the near feature as it requires the re-implementation of the … Read more
Joins can only be used when there is an association between entities. Your Employee entity should not have a field named id_team, of type int, mapped to a column. It should have a ManyToOne association with the Team entity, mapped as a JoinColumn: @ManyToOne @JoinColumn(name=”ID_TEAM”) private Team team; Then, the following query will work flawlessly: … Read more
Are you using Hibernate’s Query object, or JPA? For JPA, it should work fine: String jpql = “from A where name in (:names)”; Query q = em.createQuery(jpql); q.setParameter(“names”, l); For Hibernate’s, you’ll need to use the setParameterList: String hql = “from A where name in (:names)”; Query q = s.createQuery(hql); q.setParameterList(“names”, l);
You could achieve it by a workaround using your custom “alias to map” transformer, so your code would change to something like this Query q = mySession.createQuery( “SELECT u.id AS id, u.name AS text, u AS obj FROM User u”) .setResultTransformer( AliasToMapTransformer.renameAlias(“obj”, “object”).build() ); And then using this class: public class AliasToMapTransformer extends BasicTransformerAdapter { … Read more
Use Query.setParameterList(), Javadoc here. There are four variants to pick from.
So because of limitations of the Criteria API, I decided to bend my domain classes to fit. I created an entity class for the Tag. I couldn’t even create it as a value object. It had to have its own id. I feel dirty now. But being able to construct a dynamic query without resorting … Read more
Not supported, input parameters are only allowed in the WHERE and HAVING clauses and you cannot use parameters for the ORDER BY clause. Or if I rephrase, you can’t use parameters for columns, only values. So, either: Have as much named queries as possible sort orders Concatenate the ordering string to the query string Use … Read more
Use the select new map syntax in HQL to fetch the results of each row in a Map. Take a look at the following question, that addresses the issue: How to fetch hibernate query result as associative array of list or hashmap. For instance, the following HQL: select new map(perm.id as pid, perm.name as pname) … Read more
Why do you need to do it in the query? Why not just handle it in the java code. for example: From RandomThing Where randomTime is not null and randomTime >= :currentTimestamp and randomTime <= :maxTimestamp And then just set the parameters.