Hi. I'm trying to index a complex entity from a table with approx.
100000 Entries. But after some (maybe 400) entries I got an out of memory error. Clearing the session or evicting the current object doesn't solve the problem. The Hibernate Version is 3.2.6 and the Database is Sybase Anywhere 9.0.2.
Any ideas would be helpful.

Regards

Bernd

public void buildIndex()
{
FullTextEntityManager ftem = Search.getFullTextEntityManager(em);
Session session = (Session) em.getDelegate();
ScrollableResults allContacts = session.createQuery("from Contact").scroll();

int count = 0;
while ( allContacts.next() ) {
Contact c = (Contact) allContacts.get(0);
log.debug("Indexing " + count + " : "+ c.getDisplayRepresentation() );
ftem.index(c);
session.clear();
}
}

Hi,
look into the reference documentation of Hibernate Search: there's an example for efficient indexing: Example 6.2

* you're missing the flushToIndexes statement
* how are transactions handled?

Using hibernate 3.2.6 suggest you're using an old version of Hibernate Search, when flushToIndexes was not available. I'd advise to upgrade to Search 3.1.1; otherwise you'll have to split the task in several transactions: index changes are enqueued until transaction commit and are filling up memory.