Have you looked at DbUnit?
http://dbunit.sourceforge.net/
I use an in-memory database (Hsqldb currently) and dbunit for testing
database expectations.
On 10/9/08, tmgstewar..ol.com <tmgstewart@aol.com> wrote:
> Hi, All:
>
> Background --
>
> We have an existing (successful) product that has a VB interface.
>
> We are changing to a Java UI, with Cayenne as the ORM interface to the MS
> SQL database and Eclipse as the RCP.
>
> We have existing automated test scripts (IBM Rational Robot) and some
> manual (in text files...and probably some in the testers' minds). You know
> the story. I want to capitalize on what is already there, tweaking as
> necessary, and then supplement with my own once I understand any helpful
> mechanisms that have been put into place.
>
> I have been tasked to verify the first release of the new Java UI, focusing
> mainly on the database (that the database has not been corrupted by the new
> UI).
>
> My question is this....
>
> Where would I look to learn more about how I might use the existing test
> scripts (automated, files) and create my own to verify that the database has
> not been corrupted? What are the terms? Has anyone blazed this path
> before?
>
> I know that this is a somewhat broad question, and I will also post onto
> the Eclipse mailing list (since it may involve going one layer "outside" of
> Cayenne), but I'm really trying to become familiar with tools that help me
> test.
>
> Thank you,
> Theresa
>
>
This archive was generated by hypermail 2.0.0 : Thu Oct 09 2008 - 11:51:42 EDT