jpa 2 hibernate limit (max results) to a CriteriaQuery

java hibernate jpa-2.0 criteriaquery
Hugo picture Hugo · Sep 9, 2010 · Viewed 17.2k times · Source

maybe it's a silly question but I cannot find the answer in the docs: How can set a limit to the CriteriaQuery using JPA2?

Thanks

Answer

Mike Q picture Mike Q · Sep 9, 2010

A CriteriaQuery is not an executable Query. You need to create a TypedQuery first using EntityManager.createQuery(criteriaQuery). You can then set the max results of this and execute it.

Related questions

JPA CascadeType.ALL does not delete orphans

I am having trouble deleting orphan nodes using JPA with the following mapping @OneToMany (cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "owner") private List<Bikes> bikes; I am having the issue of the orphaned roles hanging around the …

Read More
Hibernate JPA, MySQL and TinyInt(1) for Boolean instead of bit or char

Here is my JPA2 / Hibernate definition: Code: @Column(nullable = false) private boolean enabled; In MySql this column is resolved to a bit(1) datatype - which does not work for me. For legacy issues I need to map the boolean to …

Read More
How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6

I have an one-to-one, bidirectional entity relationship with shared keys. When I attempt to save the owner of the association I get a "null id generated" exception against the owned side of the relationship. I am utilizing hibernate-entitymanager and using …

Read More