Don't know if this handles your needs, and I haven't
tried it with Derby before, but DBUnit allows you to
ensure your tables are in a known state prior to and
following unit tests. It's very easy to use and makes
unit testing code with SQL statements simple to
manage.
Hope that helps.
--- Colin
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 s
