Hi,

I am using Hibernate version:3.0 and oracle 10.

In my method, first will execute 4 insert query. after executing all insert queries , finally it should be calling a procedure and commit the transaction.

My problem is when i calling this method, what hibernate does is,first calling the procedure and then executing all insert queries.

Why is it doing like this? Is there any configuration required to tell which kind of query should execute first ?.

Help needed.

Thanks in advance.

Hibernate is holding the changes in its cache, and not committing those changes to the database until the Session is closed or the transaction is committed. Since this is happening after the procedue, you see the procedure going first, and then the updates.

So, commit your changes earlier, and it should all work!

You might find this tutorial on How Hibernate Works to be interesting:

A Quick Discussion: What is Hibernate? and How Does it Work?

JavaRanch Thread on Same Topic

Thanks for reply.

You mean Once completed the insertion, commit the changes. then, again call the procedures with new transaction.

like this,

session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
session.save();
session.save()
session.save()
session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();

session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();

call the procedure();
call the procedure();

session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();


Am i correct?

Thanks.