开发者

DBUnit dataset export by set of primary key

开发者 https://www.devze.com 2023-01-20 07:49 出处:网络
I tried to export a dataset from an oracle database by a set of primery keys using: TablesDependencyHelper.getDataset(connection, fullTableName ,

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!!!, checki开发者_C百科ng 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?


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).

0

精彩评论

暂无评论...
验证码 换一张
取 消