how to use view in dbunit

Fahd Akbar

I am trying to fix a failing test case for IDS Pay and I keep getting the following error for the database view:

>> org.dbunit.dataset.NoSuchTableException: salary___region_view

Dbunit by default only works with table and in order to switch on the views you have to do this:

>> DatabaseConfig config = databaseTester.getConnection().getConfig();
>> config.setProperty(DatabaseConfig.PROPERTY_TABLE_TYPE, new String[]{"TABLE", "VIEW"});

>>based on : [dbunit faq](http://www.dbunit.org/faq.html#views)

Problem is even after making the above change, I am getting the same error.

Any help would be greatly appreciated.

-Fahd

Gerry King

Without sounding unhelpful I suggest posting the question on stackoverflow. There may already be an answer

http://stackoverflow.com/search?q=dbunit+views

The purpose of techoverflow is questions about issues specific to our own stuff and systems.