Re: [dbunit-user] Working With View Tables In Dataset

[Jeff J. <jj...@ap...>]

>  How do I actually write a view in a flat dataset?
Does the view allow for inserts or is it read only?  If allows inserts,
should be the same approach as table - view is the table name.  If not,
then insert directly to the tables and ignore the view.

Ensure the DatabaseConfig.PROPERTY_TABLE_TYPE configuration changes
actually took effect.


On Tue, Mar 9, 2021 at 2:08 PM Patrick Buchheit <pb...@gm...> wrote:

> Unfortunately, it does not. I followed that section, but it doesn't
> provide any information about how to actually structure the xml dataset.
> How do I actually write a view in a flat dataset?
>
> On Tue, Mar 9, 2021 at 2:43 PM Jeff Jensen <jj...@ap...> wrote:
>
>> Hi Patrick,
>> This question is in the FAQ [0] and hopefully resolves the issue.
>>
>> [0] http://dbunit.sourceforge.net/faq.html#views
>>
>>
>>
>> On Tue, Mar 9, 2021 at 10:49 AM Patrick Buchheit <pb...@gm...>
>> wrote:
>>
>>> I'm a bit lost on how to deal with database views in dbunit. I found the
>>> section in the FAQs on setting up the config properties but that only
>>> addresses half the problem. What do I need to do to set up the data for the
>>> view in the XML dataset? I tried just defining it as a normal table, but I
>>> end up with TableNotFound exceptions. Is it even possible to work with
>>> views in a flat dataset?
>>> _______________________________________________
>>> dbunit-user mailing list
>>> dbu...@li...
>>> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>>>
>> _______________________________________________
>> dbunit-user mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>>
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>