I'm trying to add lots off records this way, max 10.000 at one time. Then a i do some other things and come here again with the same session. And do this again. Than i see my that my application get slower and finally stops with a java.lang.outofmemmory error.

I don't know 100% for sure. But i think it goed wrong here. I searched for some time and found only the remark that using the same session for so many records will cause this problem. So i wonder should i close the session after a while and get a new one or are there other solutions. Or maybe my code beneath contains an error.

Any help is appreciated.

try {

// start transaction
session.clear();
session.beginTransaction();

// iterate over alle the data items and save
for (int i = 0; i < dataList.size(); i++) {

session.save((MsconsDataBO) dataList.get(i));

}

// flush and commit
session.flush();
session.connection().commit();

} catch (Exception e) {

try {

// do rollback because of an error
session.connection().rollback();

} catch (Exception eSub) {

Import.errorExceptionExit("[couldn't perform rollback: mscons data]", e);

}

Import.errorExceptionExit("[couldn't add: mscons data]", e);

} finally {

log.debug("inserted " + dataList.size() + " records");

}[/u]

The session should be have a quite short live time.
Try to create a new one sometimes (sometimes is related to your app, so can't be more specific)

IMHO, session.clear() should clear everything. To me it looks like either a bug in Hibernate (unlikely) or just an application problem - these thousands of objects can not be garbage collected because there are still referencies to them (likely)

NOt quite. Hibernate keeps some objects around until the afterTransactionCompletion() phase. So you need to actually close() the session (or just commit the txn), not just clear() it to release *all* associated memory.

gavin is right. I wrote about this and other possible problems with batching inserts with Hibernate.
You can check these articles and I hope they help you out:

http://korhner.github.io/hibernate/hibernate-performance-traps-part-1/
http://korhner.github.io/hibernate/hibernate-performance-traps-part-2/