Re: [hibernate-dev] RE: scrollableresult OOM problem

2008-11-24 Thread Emmanuel Bernard
The JDBC driver is not involved. We don't use JDBC's scrollable result set. On Nov 24, 2008, at 14:47, Sanne Grinovero wrote: thanks John, hope your back is getting better. I've asked for more information to the reporter. I am not expecting the JDBC driver to do the sort, it is a Lucene so

Re: [hibernate-dev] RE: scrollableresult OOM problem

2008-11-24 Thread Sanne Grinovero
thanks John, hope your back is getting better. I've asked for more information to the reporter. I am not expecting the JDBC driver to do the sort, it is a Lucene sort, so as you said it must be Search's code to keep something around. Maybe we are ignoring the FORWARD_ONLY. 2008/11/24 John Griffin

[hibernate-dev] RE: scrollableresult OOM problem

2008-11-24 Thread John Griffin
I've dealt with this problem but only from an Oracle perspective. Using a FORWARD_ONLY ScrollMode only allows the rs.next() method call. Any other result set record movement method call results in an exception. This allows JDBC to fetch x amount of records (set by fetch size) and then get the next