RE: [dbunit-user] org.dbunit.dataset.NoSuchTableException: MSMS_AVAILABLE_INVENTORY

[Manuel L. <man...@sy...>]

---- On Thursday, June 19, 2003 11:21 AM Rhommer Varilla wrote ----
>
> I am trying to export my tables to a FlatXmlDataSet.  The problem
> is that I
> am getting the following exception when on the following line:
>
>         FlatXmlDataSet.write(fullDataSet, new
> FileOutputStream("full.xml"));
>
> ===================================================
> org.dbunit.dataset.NoSuchTableException: MSMS_AVAILABLE_INVENTORY
> 	org.dbunit.dataset.ITableMetaData
> org.dbunit.database.DatabaseDataSet.getTableMetaData(java.lang.String)
> 		DatabaseDataSet.java:179
> 	org.dbunit.dataset.ITable
> org.dbunit.database.DatabaseDataSet.getTable(java.lang.String)
> 		DatabaseDataSet.java:201
> 	org.dbunit.dataset.ITable[]
> org.dbunit.dataset.FilteredDataSet.getTables()
> 		FilteredDataSet.java:98
> 	electric.xml.Document

<exception snip>

> When I inspect the contents of...IDataSet fullDataSet =
> connection.createDataSet();
> I see the list of tables that I am concerned with, but it still gets the
> exception.
>
> What gives?
>

The two principal causes of this error when using the FilteredDataSet class
are:

1. Tables not present in decorated dataset
In the 1.5.x distribution, the table names specified in the FilteredDataSet
must exist in the decorated dataset. This is not necessary anymore with the
current CVS repository version.

2. Usage of qualified table names
When the qualified names feature is enabled, you must prefix the table names
specified in the FilteredDataSet with the schema name (like "SCHEMA.TABLE").

I hope this helps,

Manuel