hi guys,

release 2.1.2
DB oracle 8i

(simplified) Domain Model
A many-to-one B (non bidirectionnal + cascade = all)

use case:
0- //beginTransation
1- creating new B instance
2- session.save(b); // sequence is hit --> ok
3- session.find ("from A a where a.aId = 123); // flush is triggered, insert of new b is executed --> ok
4- a.setB(b) // nothing in log --> normal no flush is needed here
5- session.commit() // nothing is happening, the commit is done since i can see the row of the previous insert in the DB, but i expect a new flush to be done just before the commit since b has been updated

if i manually add session.flush() just before commit, all works fine

i was just wondering if i misunderstood the fact that a flush was done automatically before a commit when flushMode= auto

Thx

umm .. shouldnt A instance be updated/saved ?
session.saveOrUpdate(a) ????

As I understand, with above and the object graph that you have, B will be updated too when commit happens. There will then be a flush at tx.commit.

--

i don't have to saveOrUpdate A since it has been loaded in the current session.... i really don't know why my current session did not notice A modifications

Most likely you have your FlushMode set to NEVER, in which case a flush never happens until you explicitly call it aside from some special cases like queries against tables with changes waiting to be flushed. That would certainly explain the behaviour you are seeing.

flushmode is auto since in step 3 i can see the sql insert generated just before the select (find method)
I'll check all this on monday

thanks for the tip

Hi All,

I am a J2EE Developer.

I am using JDBC Transaction not JTA. Also using JBoss, but doesn't matter as in standalone i think behavior is same.

By default Session flush mode is auto, it means at any query execution and at transaction.commit(); it should work.

Flush is not working in 3 of the four ways.

1. Not worked, Default auto flush.

2.Not worked, Session session = sessionFactory.openSession();
session.setFlushMode(FlushMode.COMMIT);

3.Not worked, Set the property in hibernate.cfg.xml <property name="hibernate.transaction.flush_before_completion">true</property>

4. Worked ,
session.flush();
tx.commit();

Why the first three are not working, as according to hibernate doc all should work.

My code is as follows,

public void mySave(MyDTO dto) throws Exception {

Session session = null;
Transaction tx = null;
try {
session = hibernate.openSession();
tx = session.beginTransaction();

session.save(dto);
/////////////////
//session.flush(); // I f i remove/comment this line then problem occurs
//////////////////
tx.commit();
} catch (HibernateException e) {
if (tx != null) {
tx.rollback();
}
throw new BSException(e);
} catch (Exception e) {
if (tx != null) {
tx.rollback();
}
throw e;
}
finally {
if (session != null) {
session.close();
}
}
}

output is much like

Hibernate: Select max(id) from mytable;

=================End of output.

In 4th case when I do session.flush b4 tx.commit() manually; then output is much like, and it works fine
Hibernate: Select max(id) from mytable;
Hibernate: insert into mytable(a, b) values (?, ?);