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
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
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
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
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