How do you limit the number of records in a Query with EJB 3.0 ?

How do you limit the number of records in a Query with EJB 3.0 ?

30 | 07 | 2010

JBoss 5 AS Book

"JBoss AS 5 development" reviews
Please share your feedback/review with other readers!

Dashboard

Advertise with Us

RSS Feed
RSS Feed

Java EE 1.6 resources

Java EE 1.6 articles

Login
Sign here for the NewsLetter. Username Password Remember Me Forgot your password? Forgot your username? Create an account

JBoss admin resources

Java EE 1.6 resources
Java EE 1.6 articles

JBoss howto
How to avoid the 50 seconds start up limit in Eclipse ? JBoss recipe of the day ... Read More How can you solve deployment errors caused by large war/jar/ear files ? jboss recipe of the day ... Read More How do you configure your .war to be deployed after your EJB ? jboss recipe of the day ... Read More

How do you limit the number of records in a Query with EJB 3.0 ?

Written by Mark S.

JBoss recipe of the day
Use the setMaxResults method from the Java persistence API

Query



Example:

@PersistenceContext(unitName="myPersistenceUnit")
   private EntityManager em;

   private int maxRecords = 100;

   public void getNextItems() {
        Query q = em.createQuery("select object(o) from Item as o");
        q.setMaxResults(maxRecords);
        items= q.getResultList();
   }

JBoss.org Search

Custom Search

Comments

Only registered users can write comments!

Powered by !JoomlaComment 3.26