Why I get a "AmbiguousTableNameException" and NoSuchTableException? This error occurs when no schema is specified and that DbUnit detect that it is getting columns information from multiple tables having the same name and located in different schemas.
You can solve this problem in three different ways:
Provide the schema name when creating the database connection. Note that for Oracle you must specify the schema name in uppercase. (schema名一定要大写,为数据库名) Ensure that the connection is restricted to access only one schema. Enable the qualified table names feature.