derby for unit-testing / db snapshots

[Colin Taylor <co...@gmail.com>]

Hi there, 

I would like to use Derby for my unit testing where a testing snapshot
for the database  is reverted  to after each suite of tests complete.
I believe I could do this my copying the data directory but that seems
a bit heavyweight considering I'll have a lot of suites for my 200+
table schema which I will want to run in isolation.

>From an earlier thread http://tinyurl.com/4ebxq  I understand point of
time recovery is not supported but I could achieve this effect with
log sequence numbers? Can anyone give me some pointers on how i might
achieve this? Do I  get a the current sequence number at the start of
the test suite and then roll the log back to it when the suites
finished.  Or is there perhaps a way for my inserts/updates/deletes to
only exist during the suites lifetime some how..

Cheers for any help
Colin.