All,
I've encoutered a java heap space issue while using

Query q = null;

[...] //create an org.apache.lucene.search.Query

FullTextSession fullTextSession = Search.createFullTextSession(session);
FullTextQuery ftq = fullTextSession.createFullTextQuery(q, entityClass);
ftq.setSort(new Sort(new SortField(CatalogItem.ATTR_ID, SortField.STRING)));
scrollableResults = ftq.scroll(ScrollMode.FORWARD_ONLY); //WIth BIG AMOUNT of results thi will CRASH
scrollableResults.beforeFirst();

F.i., this target a database table with an average of 700.000 tuples, which are indexed in lucene through the Hibernate Search fw. Data aren't stored in lucene stuffs (only database maintains the data set).

Isn't a way to scroll a result set without keeping all in-memory ? Is this possible with a Sort constraint ?

Thanks

thanks for telling this, I'll try reproducing it.

Great !

Please keep me up-to-date...

If you create a jira ticket could you, please, send it to me the ID (MP or on this forum f.i.). It's more convenient than the forum to keep the track ^^.

Thanks

of course!
could you tell use which database, JDBC driver and versions of Hibernate + Hibernate Search ?
Did you get this in a standalone app or in an application server?

Databases :
Oracle 10-11g + spatial cartridge
Postgresql >8.3 + postgis 1.3 (I think)

Latest Hibernate GA jars version

It runs in tomcat (in my test) but several app servers are targetted jboss, oracle, weblogic f.i.

well you can't use all Hibernate GA, does this mean you use Search 3.1CR1 I guess? it's the only compatible with the latest core GA.

To clarify ^^ here are my declared dependencies :

<!-- hibernate -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate</artifactId>
<version>3.2.6.ga</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-annotations</artifactId>
<version>3.3.1.GA</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-search</artifactId>
<version>3.0.1.GA</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>3.0.0.ga</version>
</dependency>

thanks
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-310