Hi there, I am retrieving information from a Postgres database via the EntityManager, createQuery and its function getResultList(). It is easy to use especially with the EJB entity annotations. A disadvantage is that it stores all the results in memory. I know about the pagination possibilities with setFirstResult() and setMaxResults().
I want to access data like a cursor and only having one record at a time in memory (not totaly true, since the dbms will store some additional records in memory, but ok). It is meant for a server side process triggered by a timer, so pagination using the getResultList() makes no sence. Has anybody some experience with ScrollableResults and the scroll() and evict() functions in JBoss ? And if possible share some code how to do this in JBoss. I have spent several days now on this topic, but I have no idea how to proceed. Thanks in advance, Marcel View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4036118#4036118 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4036118 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
