Hello to everybody,

I have a problem saving an object into the db while processing a loop.
The last object of that loop is never saved. It is no problem of the loop, because I checked with debbugging output whether session.save() and session.flush() is called or not. It is called every time.
After every save()-call I call session.flush() to ensure persistence in DB. Nevertheless the last object remains unsaved...
I also put a session.connection.commit() instead of/in addition to flush(), but it has no effect.

Are there any problems with longlasting/unfinished sessions?

Does anybody know an answer to that problem?


Hibernate version:2.1.2

I am using FireBird 1.5 DB


Thank you,
matze

Any chance you could post your code? That would probably help. Cheers ~

the code that performs the session.save() is mainly a function
like this:

Task resultTask = new Task();
//setting properties of resultTask...

try{
this.session = ThreadSession.get();
this.session.save(resultTask);
try{
this.session.connection().commit();
}catch(SQLException ex){
logger.error(ex);
}
this.session.flush();
this.logger.info("saved task:" + resultTask.getName());
}catch(HibernateException ex){
this.logger.error("error while saving task: " +
resultTask.getName(), ex);
return null;
}

there's a logging statement for every task that needs to be saved including the last that is *not* saved. So I presume that it has to be something with my session.flush behaviour...

you need to understand how the session works, please read the reference guide again, Hibernate in action too.

2 tips:
- take care of transaction
- flush is not commit

Thanks to everybody that answered.

It was the wrong use of transactions. Works fine now....
matze