I am evaluating the use of Hibernate and cannot work out how to do the following. My database is a single user database running locally on the users PC.

I wish to interact with the user as follows:
Start a transaction.
Use performs change to a table (insert, updates, deleted)
User then chooses to apply changes or cancel.
To apply, the transaction is commited, to cancel the transaction is rolledback.

While the user is performing operations, I would like any queries to return the objects current state. However, if the user has deleted an object it is still returned by my findbycriteria.

Any suggestions???

Thanks,

Neal

I was wondering which was the purpose of Session.flush().
Maybe this is an example that would make sense to that method.

Try experimenting with Session.flush() and Session.setFlushMode(flushMode).

I was actually just having a look at this but it seems to flush any outstanding session changes to the database. It is called during the transaction commit processing.

I'm actually looking into rollback now as a solution.

Transaction.commit() automatically call flush()....So perhaps calling flush() explicitly is not required here [BTW, flush() synchronises the database state

Rollback is the solution!

When the user applies or cancel then I commit of rollback the changes and the find performs as I require.

Thanks for the suggestions.

Neal

...