hql « ID « JPA Q&A

  1. JPA Q&A
  2. ID
  3. hql




1. Hibernate Many2Many restict on entity id    stackoverflow.com

In my project i have unidirectional many 2 many association: 

@Entity
@Table(name="product")
class Product{
  @Enumerated(EnumType.String)
  @Id 
  @Access(AccessType.Property)
  private ProductType type;
  @Column
  private String name;
}
@Entity
class User{
  @Id
 ...

2. HQL interpretation problem - id    forum.hibernate.org

import java.io.Serializable; import java.util.Calendar; import org.apache.commons.lang.builder.ToStringBuilder; /** @author Hibernate CodeGenerator */ public class IDBLEx implements Serializable { /** identifier field */ private Long ind; /** persistent field */ private Long ruleid; /** persistent field */ private String id; /** persistent field */ private String cpid; /** persistent field */ private String comment; /** persistent field */ private Calendar Date; /** full ...

3. Puzzled. How did HQL reference object id?    forum.hibernate.org

Hi, recently I reviewed my code and something puzzled me quite a bit. In my HQL, I have something like "select..... from eg.Employee e .... where e.id=?" All seems normal to me until I realized in my eg.Employee bean I never declared any id field. The primary key is userId, likewise the same for the hbm.xml which maps userId to USER_ID. ...

4. HQL: Unexpected token for ...where ID is in (1, 2, 3)    forum.hibernate.org

My query is: from ResourceTable where resourceId is in ('1','3','13','14','15','16','17','18','19','20','21','7','8','9','10') I've also tried formatting the list as (1,2,3) (1, 2, 3) ('1', '2', '3') 1,2,3 and 1, 2, 3 Invariably, I get Data Access Failure unexpected token: in near line 1, column 60 [from com.company.model.ResourceTable where resourceId is in ('1','3','13','14','15','16','17','18','19','20','21','7','8','9','10')]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: in near line 1, column ...