Application locks out during session.flush()

Ravikiran Chittari · **Joined:** Thu Nov 18, 2004 12:24 pm **Posts:** 2

Hibernate version:
2.1
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I have a large java object which I save to database using hibernate. I think I am using the hibernate interface properly.

This java object has 4 collections
when I try to save this campaign it works fine most of the times but, sometimes it locks the application and I find that Session.finalize() has kicked in at the time.

It is a simple case, but it is huge java object with 4 collections

I am not sure how to fix this problem. Hoping to see some responses.

Thank you

Dencel · **Joined:** Tue Jan 27, 2004 12:22 pm **Posts:** 103

The problem probably is that the session gets to big.
Iterate over the collections in java and save/update the elements per element to the session. Flush and clear the session in the code. Something like this:

Code:

int counter=0;
Iterator it = myObj.myLargeCollection().iterator();
while(it.hasNext()){
   counter++;
   session.saveOrUpdate(it.next());
    if((counter % 50) == 0){
       // Empty session cache
      session.flush();
      session.clear();
    }
}

christian · **Posted:** Thu Nov 18, 2004 1:09 pm

This is a very wild guess. I'd say the problem can't be found until the original poster reads the red box.

Ravikiran Chittari · **Joined:** Thu Nov 18, 2004 12:24 pm **Posts:** 2

I am the one who posted the question.

The large object I have is

Object A --> has B, C, D, E
B, C, D, E are collections
Object A itself has around 40 elements.

I like one of the suggestions that was about trying to go for itermediate flushes.

So, in my case what is happenning is, when I do a flush

It has to save the whole 40 elements in Object A
and then do the flush of each of these collections.

So, it is only one object save(), So, I cannot do an intermediate flush I think. So, what do you think the problem / solution in this case?