[jboss-user] [EJB 3.0] - Re: JbossQL and m.createQuery(.. OFFSET 5 LIMIT 23)

[cjc]

Hi again,
the reselution is so easy and nice, and now i found the real documentation for that:
http://docs.jboss.org/ejb3/app-server/HibernateEntityManager/reference/en/html_single/index.html


  | @PersistenceContext
  | Entitymanager manager;
  | 
  | public List<SomeObj> findAllBlub(Integer offset, Integer limit){
  |   String order = "ORDER BY ....."
  |   Query q = manager.createQuery("SELECT o FROM SomeObj o "+ order );
  |   q.setFirstResult(offset);
  |   q.setMaxResults(limit);
  |   return q.getResultList();
  | }
  | 

thx all
cjc

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967554#3967554

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967554