database - Rollback a certain amount of transactions during deveopment? -
are there tools around monitor db transactions transparently , allow batch rollback? similar dbunit offers not in context of unit test longer period of time (say test lasts 5-10 minutes, done in ui , not in automated test)
like: developer integrates new feature , tests interactively. 10 minutes, data messed , wants go safe state of database.
backups / snapshots not suitable here database pretty large , going backup / snapshot time consuming. more lightweight preferred.
btw, windows sql server 2008 standard used, cannot use snapshots @ all. technology stack application java / jpa / hibernate.
thanks!
i don't know of available achieve describe. have manage own transactions on connection database.
you start transaction @ beginning of tests , roll @ end has side effect of locking tables preventing others using db.
you might want @ using sqlite database, loaded test data, use "throw away". it's fast , great testing.
Comments
Post a Comment