Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DBUnit dataset export by set of primary key

Tags:

java

dbunit

I tried to export a dataset from an oracle database by a set of primery keys using:

TablesDependencyHelper.getDataset(connection, fullTableName , 
                    new TreeSet(Arrays.asList(
                        new BigDecimal[]{new BigDecimal(1)})));

That throws me a data file of 45mb!!!, checking the file I realize that the problem was a reference to a table with composite key(6 foreign keys), instead of exporting the unique referenced registry, it took the whole table data. ¿I think this is a bug of DBUnit, anyone knows a solution to this aproach?

like image 740
cesarggf Avatar asked Oct 15 '10 16:10

cesarggf


1 Answers

In the past I have successfully used Jailer (http://jailer.sourceforge.net/) to extract datasets compatible with DBUnit. Jailer has a GUI that allows you to select the tables you want to export and, more important, exclude from the final dataset specific tables. Jailer can export datasets in the XML compatible DBUnit format. Only drawback of Jailer is the time it takes to initially parse the structure of your db - but only if you have a large, complex db).

like image 161
Luciano Fiandesio Avatar answered Oct 16 '22 12:10

Luciano Fiandesio