How To Extract A Subset Of A Database Into A Dbunit File Using A Sql Query?

Why ? I have got a big Oracle table. I would like to test some DAO methods. To do so, I use dbunit. Problem I would like to extract a subset of an existing database as a dbunit fla

Solution 1:

I think what you want might be outside of the purview of DBUnit.

What I think the best way to do this is to set-up a series of views which handle the joins and pull your data out through that. Once you have your views you can use SQL queries to pull the data out.