db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From todd runstein <todd_...@yahoo.com>
Subject Re: derby for unit-testing / db snapshots
Date Mon, 04 Apr 2005 13:45:26 GMT
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

Hope that helps.

--- Colin Taylor <colin.taylor@gmail.com> wrote:
> 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.

The only "dumb question" is the one you were too afraid to ask.
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
Get a handle on your data with "pocOLAP", the "little" OLAP project

Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!

View raw message