dbunit-user

Re: [dbunit-user] 'TIMESTAMP WITH TIME ZONE' data type not recognized

[Mark P. <mc....@gm...>]

Op 24-04-2025 om 05:30 schreef Jeff Jensen:
> 
> Note that many years ago regretfully we lost the dbunit.org <http:// 
> dbunit.org> domain.  Whoever owns it currently shows a site for a very 
> old dbUnit release, 2.4.9.  We wish that person would contact us.  But 
> please use this site instead: https://dbunit.sourceforge.net/dbunit/ 
> index.html <https://dbunit.sourceforge.net/dbunit/index.html>
> 

you might try contacting the owner trough the link provided by the WHOIS 
service at https://whois.domaintools.com/dbunit.org (perhaps you've 
already tried)

The contact form link is

https://www.name.com/contact-domain-whois/dbunit.org

hth, Mark

Re: [dbunit-user] 'TIMESTAMP WITH TIME ZONE' data type not recognized

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

Hi,

but AFAIK 'TIMESTAMP WITH TIME ZONE' *is* a standard JDBC data type (mapped
> with java.time.ZonedDateTime)

Good point!  dbUnit has been around for over 20 years so perhaps it didn't
exist or wasn't part of the standard when the core types were implemented.
` ZonedDateTime` definitely didn't exist back then!


Is this error expected?

Yes, for any types that dbUnit does not support.


In any case the same web page suggests to replace the default data type
> factory , but I'm not sure I understand the example provided.

"replace the default data type factory" means to set
`DatabaseConfig.PROPERTY_DATATYPE_FACTORY` to `H2DataTypeFactory` for your
case.  I don't think doing so will fix this problem tho.
What does your dbUnit configuration look like?  Typically, set that
in the `setUpDatabaseConfig()` method override in whichever dbUnit
DatabaseTestCase subclass you use, such as `DefaultPrepAndExpectedTestCase`.
        @Override
        protected void setUpDatabaseConfig(final DatabaseConfig config)
        {
            config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY,
new XxxDataTypeFactory());
        }
The above is a snippet from
https://dbunit.sourceforge.net/dbunit/testcases/PrepAndExpectedTestCase.html


It is enough to subclass `H2DataTypeFactory` and `AbstractDataType` to
> create a new data type? where else it should be used?

The dbUnit `DataType` class has the core supported types; it does not
contain TIMESTAMP WITH TIME ZONE.  People have contributed new data types
over the years when found needed, so if you want to add support for
TIMESTAMP WITH TIME ZONE, we'd welcome it; just let us know and we'll
happily help you with it.  Note that some datatypes are non-standard and
don't apply to all databases so those are implemented only for the specific
database in the org.dbunit.ext subpackages.


Note that many years ago regretfully we lost the dbunit.org domain.
Whoever owns it currently shows a site for a very old dbUnit release,
2.4.9.  We wish that person would contact us.  But please use this site
instead: https://dbunit.sourceforge.net/dbunit/index.html


On Wed, Apr 23, 2025 at 10:45 AM Vito De Tullio <vit...@gm...>
wrote:

> I was trying to integrate dbunit in one of my project and stumbled upon
> this error
>
>
> `WARN org.dbunit.util.SQLHelper [...] data type (2014, 'TIMESTAMP WITH
> TIME ZONE') not recognized and will be ignored. See FAQ for more
> information.`
>
>
> On https://www.dbunit.org/faq.html#typenotrecognized I found the
> following message
>
>
> > By default, DbUnit only supports standard JDBC data types
>
>
> but AFAIK 'TIMESTAMP WITH TIME ZONE' *is* a standard JDBC data type
> (mapped with java.time.ZonedDateTime)
>
>
> Is this error expected?
>
> In any case the same web page suggests to replace the default data type
> factory , but I'm not sure I understand the example provided.
>
> Can you help me how to properly create this custom factory (in my case I'm
> using h2 for some tests in my spring boot application).
>
>
> It is enough to subclass `H2DataTypeFactory` and `AbstractDataType` to
> create a new data type? where else it should be used?
>
>
> --
> Vito De Tullio - Vit...@gm...
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

[dbunit-user] 'TIMESTAMP WITH TIME ZONE' data type not recognized

[Vito De T. <vit...@gm...>]

I was trying to integrate dbunit in one of my project and stumbled upon
this error


`WARN org.dbunit.util.SQLHelper [...] data type (2014, 'TIMESTAMP WITH TIME
ZONE') not recognized and will be ignored. See FAQ for more information.`


On https://www.dbunit.org/faq.html#typenotrecognized I found the following
message


> By default, DbUnit only supports standard JDBC data types


but AFAIK 'TIMESTAMP WITH TIME ZONE' *is* a standard JDBC data type (mapped
with java.time.ZonedDateTime)


Is this error expected?

In any case the same web page suggests to replace the default data type
factory , but I'm not sure I understand the example provided.

Can you help me how to properly create this custom factory (in my case I'm
using h2 for some tests in my spring boot application).


It is enough to subclass `H2DataTypeFactory` and `AbstractDataType` to
create a new data type? where else it should be used?


-- 
Vito De Tullio - Vit...@gm...

[dbunit-user] dbUnit 3.0.0 Released

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

Thanks to the multiple contributors we have a new release with new
features, updates, and fixes.  Please refer to the changes report for
details:
http://dbunit.sourceforge.net/dbunit/changes-report.html

Note the big change in this release warranting a major version bump -
dbUnit now supports JUnit 5!  Thanks to Ed for all the detailed work to
make this happen.

Changes in this version include:

New features:
o Add 'actual is null' and 'actual is not null' constants to ValueComparers
class  Issue: 250. Thanks to jeffjensen.
o Add TableDecoratorDataSet and GeneratedColumnFilterSupport enabling
column filtering from datasets, such as computed columns  Issue: 232.
Thanks to rcd.
o Configure Maven Wrapper for dbUnit builds.  Issue: 258. Thanks to
jeffjensen.

Fixed Bugs:
o Mark postgresql dependency as provided scope  Issue: 443. Thanks to
jeffjensen.
o Fix NoClassDefFoundError for IOUtils  Issue: 445. Thanks to jeffjensen.
o In PostgreSQLOidDataType.setSqlValue(), use connection.unwrap() to get
PGConnection.  Issue: 451. Thanks to wbiller.
o In OracleNClobDataType.setSqlValue() and
OracleXMLTypeDataType.setSqlValue(), use connection.unwrap() to get
statement or resultset.  Issue: 444. Thanks to wbiller.

Changes:
o Upgrade dbUnit from JUnit 4 to JUnit 5  Issue: 222. Thanks to emann.
o Update code for Modernizer plugin violations  Issue: 248. Thanks to
ajohnson.

Re: [dbunit-user] dbUnit 3.0.0-SNAPSHOT with JUnit 5

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

Great news!  Thank you for testing it and letting us know, Mark!  Much
appreciated.


On Sun, Nov 3, 2024 at 5:40 AM Mark Prins <mc....@gm...> wrote:

>
>
> Op 24-10-2024 om 02:20 schreef Jeff Jensen:
> > We published dbUnit 3.0.0-SNAPSHOT which has update to JUnit 5, no more
> > JUnit 4!
> >
> > To try it, please refer to https://dbunit.sourceforge.net/dbunit/
> > repos.html <https://dbunit.sourceforge.net/dbunit/repos.html>.
> >
>
> I bumped the dependency in one of our projects [1] and things appear to
> work just fine. The project was upgraded to junit5/junit-jupiter a while
> ago, so no changes there.
>
> [1] https://github.com/B3Partners/brmo/pull/2292
>
> thanks, Mark
>
>
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

Re: [dbunit-user] dbUnit 3.0.0-SNAPSHOT with JUnit 5

[Mark P. <mc....@gm...>]

Op 24-10-2024 om 02:20 schreef Jeff Jensen:
> We published dbUnit 3.0.0-SNAPSHOT which has update to JUnit 5, no more 
> JUnit 4!
> 
> To try it, please refer to https://dbunit.sourceforge.net/dbunit/ 
> repos.html <https://dbunit.sourceforge.net/dbunit/repos.html>.
> 

I bumped the dependency in one of our projects [1] and things appear to 
work just fine. The project was upgraded to junit5/junit-jupiter a while 
ago, so no changes there.

[1] https://github.com/B3Partners/brmo/pull/2292

thanks, Mark

[dbunit-user] dbUnit 3.0.0-SNAPSHOT with JUnit 5

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

We published dbUnit 3.0.0-SNAPSHOT which has update to JUnit 5, no more
JUnit 4!

To try it, please refer to https://dbunit.sourceforge.net/dbunit/repos.html.

Please email this list for any issues, questions, etc.

[dbunit-user] dbUnit 2.8.0 Released

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

We have a new release with a single new feature:
o Add support for YAML dataset format  Issue: 244. Thanks to bjornbeskow.

Please refer to the changes report for details:
http://dbunit.sourceforge.net/dbunit/changes-report.html

Re: [dbunit-user] Problems when extending the DBTestCase abstract class for my purposes in 2.7.1+

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

Hi,

That is a curious issue.  To see release differences, use the Changes
Reports [0] and the API diff reports [1] to initiate the understanding.

[0] https://dbunit.sourceforge.net/dbunit/changes-report.html#a2.7.1
[1] https://dbunit.sourceforge.net/dbunit/2.7.0-to-2.7.1.html


On Sun, Jan 8, 2023 at 2:29 AM JRSofty <jr...@gm...> wrote:

> Hello,
>
> So I've used DBUnit briefly a few years ago, and decided that it would be
> a good part of my current projects tests. I'm building my project in Maven
> so I included the DBUnit 2.7.3 version in my POM, no problems no errors,
> jar files appeared as expected. Then I wanted to create a new test case so
> I created a class and had it extend the DBTestCase class that is located in
> the DBUnit package org.dbunit. My IDE (I'm using Eclipse's most recent
> version) I receive the following error
> "
>
> The hierarchy of the type MyTestClass is inconsistent
> "
> Which means something is missing, but I have, as far as I know, included
> all dependencies that are needed for this to work.  What I find most
> interesting is that when I downgraded to DBUnit 2.7.0, this error no longer
> occurs and I can work as normal. Once I bump it up to 2.7.1 the error
> appears once more.
>
> Could you provide information on what has changed between 2.7.0 and 2.7.1
> so I can identify what is missing in my project setup? I really would like
> to use the most recent version of the library if possible.
>
> --
> Regards
> Jason Reed
>
> http://jrsofty1.stinkbugonline.com
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

[dbunit-user] Problems when extending the DBTestCase abstract class for my purposes in 2.7.1+

[JRSofty <jr...@gm...>]

Hello,

So I've used DBUnit briefly a few years ago, and decided that it would be a
good part of my current projects tests. I'm building my project in Maven so
I included the DBUnit 2.7.3 version in my POM, no problems no errors, jar
files appeared as expected. Then I wanted to create a new test case so I
created a class and had it extend the DBTestCase class that is located in
the DBUnit package org.dbunit. My IDE (I'm using Eclipse's most recent
version) I receive the following error
"

The hierarchy of the type MyTestClass is inconsistent
"
Which means something is missing, but I have, as far as I know, included
all dependencies that are needed for this to work.  What I find most
interesting is that when I downgraded to DBUnit 2.7.0, this error no longer
occurs and I can work as normal. Once I bump it up to 2.7.1 the error
appears once more.

Could you provide information on what has changed between 2.7.0 and 2.7.1
so I can identify what is missing in my project setup? I really would like
to use the most recent version of the library if possible.

-- 
Regards
Jason Reed

http://jrsofty1.stinkbugonline.com

[dbunit-user] dbunit-maven-plugin 1.2.0 Released

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

Thanks to Bjorn we have a new release with a new import data set feature.
Please refer to the changes report for details:
http://dbunit.sourceforge.net/dbunit-maven-plugin/changes-report.html

Changes in this version include:

New features:
o Create composite dataset from multiple source files.  Issue: 5. Thanks to
bjornbeskow.

Changes:
o Update dbUnit version to 2.7.3. Thanks to jeffjensen.

[dbunit-user] dbUnit 2.7.3 Released

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

Thanks to the multiple contributors we have a new release with new
features, updates, and fixes.  Please refer to the changes report for
details:
http://dbunit.sourceforge.net/dbunit/changes-report.html

Changes in this version include:

New features:
o Enable composing an Operation dataset from multiple source files.  Issue:
5. Thanks to bjornbeskow.
o Add 'actual is null' and 'actual is not null' ValueComparers  Issue: 250.
Thanks to jeffjensen.

Fixed Bugs:
o Nullable UUID column in PostgreSQL caused NPE  Issue: 439. Thanks to
xobotun.
o Timestamp conversion for instants during daylight saving time is off
 Issue: 438. Thanks to jammule.
o Unwrap PGConnection instead of casting to it  Issue: 436. Thanks to
sfranson.

Changes:
o OracleClobDataType: Use non-deprecated CLOB; also prevents
ClassCastException  Issue: 240. Thanks to bambaro.
o Upgrade PostGIS JDBC driver to 2021.1.0  Issue: 251. Thanks to mprins.

[dbunit-user] New 2.7.3-SNAPSHOT Published

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

Four changes merged to 2.7.3-SNAPSHOT and published.  Thank you to the
contributors!
http://dbunit.sourceforge.net/dbunit/changes-report.html#a2.7.3-SNAPSHOT

Please test and let us know if it works and of any issues, thank you!

Re: [dbunit-user] Cant get “bit” datatype to work with mysql

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

Hi,
Instead of MySqlDataTypeFactory, do we need a  MariaDataTypeFactory to
account for what it needs?  I'm not familiar enough with this issue to know
if it should work as is.
Perhaps you can copy MySqlDataTypeFactory to your app and change it until
it works.  Happy for a contribution to dbUnit if you make it work.  Sounds
like we could setup a MariaDB profile in the build as well - if you can do
that, will help keep the builds working with MariaDB too and I'll set it up
on CI.


On Fri, Sep 17, 2021 at 6:36 AM Jonas Jansson <mat...@gm...>
wrote:

>
> Hi, using 2.7.2. I am using the in-memory mariadb4j to setup the server.
>
> I recently noticed that I was using the H2DataTypeFactory since I had some
> warnings in the log. So, I tried changing to MySqlDataTypeFactory,
> But I ran into problems with the “bit” datatype. (My tests work fine
> running the H2 Datatypefactory with the mariadb database)
>
> I have a column in a table defined in my create-schema SQL as:
>
> *accnonexpired Bit(1) NOT NULL*
>
> In the dbunit xml it looks like this:
>
> *accnonexpired=“1**”*
>
> (And in my Java class:)
>
> *@Column(name = "accnonexpired", nullable = false)*
> *private boolean accountNonExpired = true;*
>
>
> But, when I try to set it up I get the exception:
> *com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data
> too long for column 'accnonexpired' at row 1*
>
>
> I looked into the mysql DataTypeFactory and you seem to treat bit’s as
> tiny ints? Not sure why, but I’m sure you have a good reason :)
> Anyway, is there something I can do to make the bit datatype work when
> using the mysql DataTypeFactory?
>
> Pointers appreciated.
>
>
>
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

[dbunit-user] Cant get “bit” datatype to work with mysql

[Jonas J. <mat...@gm...>]

Hi, using 2.7.2. I am using the in-memory mariadb4j to setup the server.

I recently noticed that I was using the H2DataTypeFactory since I had some
warnings in the log. So, I tried changing to MySqlDataTypeFactory,
But I ran into problems with the “bit” datatype. (My tests work fine
running the H2 Datatypefactory with the mariadb database)

I have a column in a table defined in my create-schema SQL as:

*accnonexpired Bit(1) NOT NULL*

In the dbunit xml it looks like this:

*accnonexpired=“1**”*

(And in my Java class:)

*@Column(name = "accnonexpired", nullable = false)*
*private boolean accountNonExpired = true;*


But, when I try to set it up I get the exception:
*com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data
too long for column 'accnonexpired' at row 1*


I looked into the mysql DataTypeFactory and you seem to treat bit’s as tiny
ints? Not sure why, but I’m sure you have a good reason :)
Anyway, is there something I can do to make the bit datatype work when
using the mysql DataTypeFactory?

Pointers appreciated.

[dbunit-user] dbUnit 2.7.1 Released

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

Thanks to the multiple contributors we have a new release with some updates
and fixes.  Please refer to the changes report for details:
http://dbunit.sourceforge.net/changes-report.html

Changes in this version include:

Fixed Bugs:
o DefaultPrepAndExpectedTestCase must use
DatabaseConfig.FEATURE_CASE_SENSITIVE_TABLE_NAMES  Issue: 440.

Changes:
o Update Apache POI to version 4.1.0  Issue: 231. Thanks to felixknecht.
o Eliminate the Maven's relativePath warning  Issue: 235. Thanks to viczi.
o UniqueIdentifierType: change caught exception for Java 12's changed UUID
validation  Issue: 236. Thanks to viczi.
o Use optional in poi-ooxml and postgresql Maven dependencies  Issue: 237.
Thanks to viczi.
o Use optional in junit and hamcrest Maven dependencies  Issue: 238. Thanks
to viczi.
o Remove commons-io dependency  Issue: 239. Thanks to viczi.
o Remove commons-collections dependency  Issue: 240. Thanks to viczi.

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

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

Since SQL requires table name(s) for manipulating the data, dbUnit must
know the table name for inserting the data.  The table name is either the
view name or the actual table behind the view.  If the view allows inserts,
try using the view name.  If it does not, use the actual table names.


On Wed, Mar 10, 2021 at 7:23 AM Patrick Buchheit <pb...@gm...> wrote:

> I may have been unclear. I'm not looking for how to do read/writes from
> the code. I have an existing XML file structured as a flat dataset. The
> schema gets built by hibernate during deployment and the actual table
> contents get loaded from the XML at run time. What I need to know is what
> is the syntax for the XML to represent a view.
>
> On Tue, Mar 9, 2021 at 4:47 PM Jeff Jensen <jj...@ap...> wrote:
>
>> >  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
>>>
>> _______________________________________________
>> 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
>

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

[Patrick B. <pb...@gm...>]

I may have been unclear. I'm not looking for how to do read/writes from the
code. I have an existing XML file structured as a flat dataset. The schema
gets built by hibernate during deployment and the actual table contents get
loaded from the XML at run time. What I need to know is what is the syntax
for the XML to represent a view.

On Tue, Mar 9, 2021 at 4:47 PM Jeff Jensen <jj...@ap...> wrote:

> >  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
>>
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

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
>

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

[Patrick B. <pb...@gm...>]

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
>

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

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

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] Working With View Tables In Dataset

[Patrick B. <pb...@gm...>]

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?

Re: [dbunit-user] weird interaction between PrepAndExpectedTestCase and .csv

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

My guess is need to put the groups of (or single files) of CSVs in separate
directories.  I don't use the CSV data files so am a little vague on it.

If you find a change useful for using CSVs, please open a ticket w/either
merge request or patch so we can improve it.


On Thu, Jul 16, 2020 at 3:54 AM Vito De Tullio <vit...@gm...>
wrote:

> Hi.
> I'm having trouble using PrepAndExpectedTestCase#runTest with
> CsvDataFileLoader.
> Specifically, from what I understand, CsvURLDataSet(used internally)
> expects a parameter with the path of a single .csv file, but actually loads
> all the directory content.
> This means that I cannot use runTest explicitly passing the tables I want
> to test. If I pass multiple preparation tables I end up with duplicated
> data (or errors in case of PK / unique constraints)
>
> --
> Vito De Tullio - Vit...@gm...
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>

[dbunit-user] weird interaction between PrepAndExpectedTestCase and .csv

[Vito De T. <vit...@gm...>]

Hi.
I'm having trouble using PrepAndExpectedTestCase#runTest with
CsvDataFileLoader.
Specifically, from what I understand, CsvURLDataSet(used internally)
expects a parameter with the path of a single .csv file, but actually loads
all the directory content.
This means that I cannot use runTest explicitly passing the tables I want
to test. If I pass multiple preparation tables I end up with duplicated
data (or errors in case of PK / unique constraints)

-- 
Vito De Tullio - Vit...@gm...

Re: [dbunit-user] Can't get rid of "Potential problem"

[Vito De T. <vit...@gm...>]

Is there another way?
I don't really like the approach "subclass to configure"...

Il giorno lun 29 giu 2020 alle ore 16:11 Jeff Jensen <jj...@ap...>
ha scritto:

> Override setUpDatabaseConfig.
>
> This is from
> http://dbunit.sourceforge.net/testcases/PrepAndExpectedTestCase.html
>
>         @Override
>         protected void setUpDatabaseConfig(final DatabaseConfig config)
>         {
>             // set properties as needed
>
>             config.setProperty(DatabaseConfig.FEATURE_BATCHED_STATEMENTS, true);
>
>             // set the specific IDataTypeFactory if needed
>             config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new XxxDataTypeFactory());
>         }
>
> FAQ page has simple example as well:
> http://dbunit.sourceforge.net/faq.html
>
> On Mon, Jun 29, 2020 at 3:48 AM Vito De Tullio <vit...@gm...>
> wrote:
>
>> Hi
>>
>> In my toy project (https://github.com/ZeeD/springbootplusdbunit) I found
>> a
>> strange message in the logs:
>>
>>     Potential problem found: The configured data type factory 'class
>>     org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause
>> problems
>>     with the current database 'H2' (e.g. some datatypes may not be
>> supported
>>     properly). In rare cases you might see this message because the list
>> of
>>     supported database products is incomplete (list=[derby]). If so
>> please
>>     request a java-class update via the forums.If you are using your own
>>     IDataTypeFactory extending DefaultDataTypeFactory, ensure that you
>> override
>>     getValidDbProducts() to specify the supported database products.
>>
>> Searching in the docs and on stackoverflow I tried to tell dbunit to use
>> H2DataTypeFactory, but nothing has worked.
>> What is the correct way to setup the tests?
>>
>> Thanks
>>
>> --
>> Vito De Tullio - Vit...@gm...
>> _______________________________________________
>> 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
>


-- 
Vito De Tullio - Vit...@gm...