I need currently inserted value from table with in a transaction.

In the particular scenario I cannot use any locking mechanism, because locking all affected in transaction commit,

Actually am inserting a value to a table, just after that I need that inserted value ….

Eg:
Begin Transaction

Insert - value to table
select the value from table

Commit transaction
.......
Rollback transaction


I cannot get the value before the execution of transaction commit .

I found before commit data which are inserted is not reflecting to table, how can i get the reflected data ? also if roll back is executed need to remove the inserted data .. can u please suggest how to do this,



I found auto-commit property – but I d’t understood what it is.

Thanks in advance.

If I am correct, you want the id generated for the insert statement in our query, for this the best place to go through is at http://docs.jboss.org/hibernate/stable/core/reference/en/html/mapping.html#mapping-declaration-idwhich talks about the id generations and there mapping.

After the insert, force Hibernate to write the changes to the database with
Session.flush(). Then, read the following chapter in the documentation to understand why you have to do this: http://docs.jboss.org/hibernate/stable/ ... e-flushing

Thanks for your replay

Here am using declarative transaction for hibernate, so Session.flush() is not working for me, I think this is due to declarative transaction (dispatcher servlet).

So how can i do this here in my code ?

Hai all

Till now it is not working , then how can i apply Session.flush() in my code.

Thanks in advance.