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

2006-09-14 Thread laszlo.fogas
nobody any idea? i think it's not a special need.. all i want to do is a select with joins and limit... If i'm asking stupid thing please let me know! regards View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3971564#3971564 Reply to the post : http://www.jbos

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

2006-09-10 Thread laszlo.fogas
ok, i try again :) So, i have an object with lots of lazy onetomany relations. I have second level cache enabled(TreeCache). I would like to use pagination with the setfirstresult/maxresult methods. If i initialize the lazy collections with calling the size method, and use pagination the entit

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

2006-09-03 Thread laszlo.fogas
ok I was wrong: It generates the desired offset/limit queries unless you use join fetch in your query to initialize lazy collections. In the docs: (http://docs.jboss.org/ejb3/app-server/HibernateEntityManager/reference/en/html_single/index.html#d0e751) "Nor should fetch be used together with s

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

2006-09-03 Thread laszlo.fogas
Hi, I found the same solution, but when i examined a bit more i realized that the whole resultset is generated every time, and these methods only cut a part of that. It does not generate offset/limit like sql query. Am I right? Because it could cause some performance problems. Lazlo View the

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

2006-08-25 Thread 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 findAllBlub(Integer offset, Inte