java - org.dbunit.database.AmbigouslyTableNameException

Question

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <employee name = "abc" empId = "100" location = "goa" dept = "IT" />
        <facilities transport="Y" mealcard = "" driver = "Y"/>
        <reportees manager = "XXX" lead = "XXX" VP = "XXX"/>
    <employee name = "XYZ" empId = "101" location = "mombai" dept = "IT" />
        <facilities transport="Y" mealcard = "" driver = "Y"/>
        <reportees manager = "XXX" lead = "XXX" VP = "XXX"/>
    <employee name = "PQA" empId = "102" location = "delhi" dept = "IT" />
        <facilities transport="Y" mealcard = "" driver = "Y"/>
        <reportees manager = "XXX" lead = "XXX" VP = "XXX"/>

上面是我的 XML。我必须验证同样的事情。我使用 DBUnit 将相同的 XML 与其他 XML 进行比较(其他 XML 具有相同的内容，但从不同的源生成)。创建数据集时，我收到“org.dbunit.database.AmbigouslyTableNameException”。

我对每个 XML 标签都有 SQL 查询。例如。对于员工标签，我正在 empID 上查询。对于我正在查询mealCard等的设施，我正在循环遍历XML标签。第一次迭代顺利，没有错误。我正在使用 QueryDataSet.addTable(table_name ,query) 添加表，即 xml 标签。但是，当下一次迭代到来并且我尝试再次添加员工标签时，我收到了上述错误。

Answer 1

配置模式名称，以便 dbUnit 知道要使用哪个。请参阅Why am I getting an "AmbiguousTableNameException"?