Thursday, February 9, 2012 2:57

The requested operation is not supported on forward only result sets

Tagged with:
Posted by on Saturday, July 31, 2010, 16:51
This news item was posted in Documentum category and has 0 Comments so far.

public Object doInHibernate(Session session) throws HibernateException {
Query q = session.createQuery(dql);
q.setFirstResult(size);
q.setMaxResults(rInfo.getPageSize());
return q.list();
}

We need to make sure the value of  parameter of query.setFirstResult is bigger than 0.

And it seems that we can also check if hibernate.jdbc.use_scrollable_resultset is set to true. I didn’t try this for I resolve this issue by setting the correct first result size.

Leave a Reply

You can leave a response, or trackback from your own site.