Auto Rollback?

BigSTLCardsFan · **Joined:** Tue Feb 07, 2006 4:54 pm **Posts:** 1

Hibernate version: 3.0

Is there a config file setting that I can set to allow me to test updates to a db w/o saving the changes?

kgignatyev · **Posted:** Thu Mar 30, 2006 5:59 pm

No.

I suggest dumping and restoring database in different schema/catalog and do testing there.
db_dump > file
file > new_db
test against new_db
drop new_db

jt_1000 · **Posted:** Thu Mar 30, 2006 6:02 pm

in order for you changes to be visible to other processes (and persistent for htat matter), like external tools (Sqlplus, TOAD, dbartisan, vienna..etc.) then you need to COMMIT the data. Once you COMMIT, you can't rollback.

So you can't really verify the data w/o a COMMIT.