Can I use DbUnit with database views?
Yes. By default DbUnit is configured to only recognize normal tables. Modify the table type property to work with other table types. For example, use {“TABLE”, “VIEW”} for views. Be aware that REFRESH, DELETE and UPDATE operations are not compatible with tables without primary keys. They are not usable with views without overriding primary keys detection. CLEAN_INSERT, INSERT and DELETE_ALL operations are compatible with views.