Question

我有一个数据集(在Xml中界定),一使用邮政GreSQL、POJO和JPA附加说明,二是同Junit共同测试的Db。

When the test runs, it creates the tables and sequences in the database, but when it starts to read the dataset (xml) with the table definitions and columns, it fires the following error org.dbunit.dataset.NoSuchTableException "nameoftable" I tried to put the name of the table with all caps and normal caps, and it won t work. The table was created in the public schema, and then i tried to define in the xml the table as public."nameoftable" but it also won t work.... any ideas?

我试图用以下版本与注射器一起进行这一测试:2.2.2, 2.3.0和2.4.5。

感谢。

Answer 1

有了DBUnit,你可以使用特定图象进行测试,也可以使用完整的数据库(有多种图象)。如果你使用后者,那么在进口/出口数据集中,或者在数据集中,需要具体说明该表;在邮政总局中,我至少没有尝试过。

在以下法典中加入:

if (strSchema == null || strSchema.isEmpty()) {
    conn = new DatabaseConnection(jdbcConnection);
    conn.getConfig().setProperty(
            "http://www.dbunit.org/features/qualifiedTableNames", true);
}
else
    conn = new DatabaseConnection(jdbcConnection, strSchema);

重要的轨道是财产的确定;其余部分是我用来使与非行或化chem相关联(根据从冲破的XML中抽取的化学名称)。

友情链接