ValueList Handler pattern with Hibernate in JBoss

rocket · **Posted:** Tue Aug 10, 2004 11:53 pm

Hi all,
Somebody has an example of a ValueList Handler implementation with the Hibernate in JBoss environment?
I try to modify the http://cvs.sourceforge.net/viewcvs.py/v ... iew=markup to use an Session Facade EJB (Stateless).
The problem is that in this implementation a session is remained open between scroll iterations. So, if I use a Session Facade EJB, the session is opened and closed between requests.

PS. To use EJB Statefull is discouraged because performance coast, no?

shl · **Posted:** Wed Aug 11, 2004 3:10 am

what about usage of:

Code:

session.createQuery(hqlQuery)
    setFirstResult(startRow)
    .setMaxResults(MAX_ROW_NUM)
    .list();

And if you need session with its filled first-level cache, to avoid repeated fetches, use Statefull Bean with the following approach:

Code:

this.session.reconnect(); // or this.session.connect(newJDBCConnection)
// iterate....
List result = this.session.createQuery(hqlQuery)
    setFirstResult(startRow)
    .setMaxResults(MAX_ROW_NUM)
    .list();
this.session.disconnect();

return result;

Or think about second-level caching.