You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
(31) |
Apr
(65) |
May
(62) |
Jun
(13) |
Jul
(30) |
Aug
(11) |
Sep
(6) |
Oct
(9) |
Nov
(14) |
Dec
(17) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(44) |
Feb
(112) |
Mar
(68) |
Apr
(58) |
May
(56) |
Jun
(78) |
Jul
(50) |
Aug
(14) |
Sep
(41) |
Oct
(50) |
Nov
(31) |
Dec
(36) |
2004 |
Jan
(55) |
Feb
(70) |
Mar
(37) |
Apr
(26) |
May
(95) |
Jun
(27) |
Jul
(25) |
Aug
(33) |
Sep
(75) |
Oct
(30) |
Nov
(31) |
Dec
(15) |
2005 |
Jan
(11) |
Feb
(81) |
Mar
(33) |
Apr
(67) |
May
(53) |
Jun
(57) |
Jul
(15) |
Aug
(22) |
Sep
(18) |
Oct
(32) |
Nov
(3) |
Dec
(30) |
2006 |
Jan
(32) |
Feb
(16) |
Mar
(16) |
Apr
(9) |
May
(24) |
Jun
(14) |
Jul
(1) |
Aug
(16) |
Sep
(33) |
Oct
(34) |
Nov
(64) |
Dec
(25) |
2007 |
Jan
(32) |
Feb
(20) |
Mar
(8) |
Apr
(21) |
May
(22) |
Jun
(21) |
Jul
(16) |
Aug
(2) |
Sep
(5) |
Oct
(4) |
Nov
(12) |
Dec
(7) |
2008 |
Jan
(17) |
Feb
(21) |
Mar
(52) |
Apr
(23) |
May
(43) |
Jun
(23) |
Jul
(27) |
Aug
(5) |
Sep
(13) |
Oct
(13) |
Nov
(35) |
Dec
(14) |
2009 |
Jan
(54) |
Feb
(94) |
Mar
(48) |
Apr
(41) |
May
(45) |
Jun
(79) |
Jul
(53) |
Aug
(24) |
Sep
(24) |
Oct
(26) |
Nov
(34) |
Dec
(26) |
2010 |
Jan
(55) |
Feb
(25) |
Mar
(24) |
Apr
(37) |
May
(15) |
Jun
(13) |
Jul
(27) |
Aug
(20) |
Sep
(12) |
Oct
(11) |
Nov
(12) |
Dec
(12) |
2011 |
Jan
(18) |
Feb
(19) |
Mar
(13) |
Apr
(13) |
May
(14) |
Jun
(17) |
Jul
(7) |
Aug
(15) |
Sep
(7) |
Oct
(11) |
Nov
(6) |
Dec
(8) |
2012 |
Jan
(7) |
Feb
(5) |
Mar
(2) |
Apr
(1) |
May
|
Jun
(2) |
Jul
(3) |
Aug
(1) |
Sep
(4) |
Oct
(6) |
Nov
(8) |
Dec
(2) |
2013 |
Jan
|
Feb
(1) |
Mar
(5) |
Apr
(1) |
May
(1) |
Jun
|
Jul
(3) |
Aug
(2) |
Sep
|
Oct
(1) |
Nov
|
Dec
(5) |
2014 |
Jan
(10) |
Feb
(5) |
Mar
(1) |
Apr
(9) |
May
|
Jun
(1) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
2015 |
Jan
|
Feb
|
Mar
(2) |
Apr
(1) |
May
(3) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
2016 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(4) |
Jun
(12) |
Jul
(1) |
Aug
(1) |
Sep
|
Oct
|
Nov
(4) |
Dec
(2) |
2017 |
Jan
(19) |
Feb
(1) |
Mar
(2) |
Apr
|
May
(1) |
Jun
(5) |
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
(4) |
Dec
|
2018 |
Jan
|
Feb
(2) |
Mar
(1) |
Apr
(6) |
May
(2) |
Jun
|
Jul
|
Aug
(6) |
Sep
(4) |
Oct
(1) |
Nov
|
Dec
|
2019 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
(3) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(6) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2021 |
Jan
|
Feb
|
Mar
(6) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(2) |
Oct
(1) |
Nov
|
Dec
|
2022 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2023 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Jeff J. <jj...@ap...> - 2024-06-02 22:25:02
|
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 |
From: Jeff J. <jj...@ap...> - 2023-01-08 16:10:02
|
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 > |
From: JRSofty <jr...@gm...> - 2023-01-08 08:29:23
|
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 |
From: Jeff J. <jj...@ap...> - 2022-02-13 21:17:09
|
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. |
From: Jeff J. <jj...@ap...> - 2022-02-13 06:32:05
|
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. |
From: Jeff J. <jj...@ap...> - 2021-10-30 19:13:09
|
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! |
From: Jeff J. <jj...@ap...> - 2021-09-17 16:01:53
|
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 > |
From: Jonas J. <mat...@gm...> - 2021-09-17 11:35:50
|
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. |
From: Jeff J. <jj...@ap...> - 2021-07-22 22:05:35
|
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. |
From: Jeff J. <jj...@ap...> - 2021-03-10 15:16:14
|
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 > |
From: Patrick B. <pb...@gm...> - 2021-03-10 13:23:33
|
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 > |
From: Jeff J. <jj...@ap...> - 2021-03-09 21:47:08
|
> 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 > |
From: Patrick B. <pb...@gm...> - 2021-03-09 20:08:13
|
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 > |
From: Jeff J. <jj...@ap...> - 2021-03-09 19:43:00
|
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 > |
From: Patrick B. <pb...@gm...> - 2021-03-09 16:49:22
|
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? |
From: Jeff J. <jj...@ap...> - 2020-07-16 13:35:26
|
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 > |
From: Vito De T. <vit...@gm...> - 2020-07-16 08:53:56
|
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... |
From: Vito De T. <vit...@gm...> - 2020-06-30 07:21:46
|
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... |
From: Jeff J. <jj...@ap...> - 2020-06-29 14:11:26
|
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 > |
From: Vito De T. <vit...@gm...> - 2020-06-29 08:47:57
|
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... |
From: Vito De T. <vit...@gm...> - 2020-06-24 15:48:51
|
Il giorno mer 24 giu 2020 alle ore 14:35 Jeff Jensen <jj...@ap...> ha scritto: > Perhaps my notes help you: > * one CSV file per table. > * CSV base filename must match table name. > * requires a file named table-ordering.txt containing all table names > (same as the base file name; case insensitive but best to match case), one > per line, sorted in insert order. > * all data CSV files must reside in the same directory as > table-ordering.txt > * numeric CSV data file fields must not have trailing spaces before the > comma-separator as will interpret it as a String instead of a number. > * specify null values as null without quotes. > thank you for your notes, they are very helpful > if there is a better way to obtain my goals > > A quick review of your sample code shows manual approaches instead of > using the framework features. My suggestion is to > setup PrepAndExpectedTestCase per the doc page you mentioned , autowiring > it to the tests, as it is fast and simple by copying and pasting the code > from the docs. Configure it with the applicable DataFileLoader, perhaps > CsvDataFileLoader for CSV instead of FlatXmlDataFileLoader as shown on the > doc page. > that was my initial plan, but I found some errors (probably related to the "table-ordering.txt" needed file I didn't knew about) then switched to a manual approach. I updated the code to rely on PrepAndExpectedTestCase again and this time I successfully run the tests. thank you for your help. On Wed, Jun 24, 2020 at 3:12 AM Vito De Tullio <vit...@gm...> > wrote: > >> Hi >> I'm new to dbunit, and I'm trying to understand if it can help me with >> some automated integration tests. >> I have a spring-boot application that normally use oracle as db, but in >> my tests I'm using h2. >> The interaction with the db is through spring data repositories (using >> hibernate under the hood). >> >> My goal is to verify the behavior on the db of calling the rest api I >> expose, in a controlled and reproducible manner. >> >> In the documentation I see that it's possible to use flatxml, xml, query >> on a db, etc. but on >> https://blog.mousetech.com/dbunit-and-csv-reference-data/ I also found >> that csv can be used. >> I really prefer this format to express the tables, but I have encountered >> some troubles trying to using them with PrepAndExpectedTestCase, like how >> stated in >> http://dbunit.sourceforge.net/testcases/PrepAndExpectedTestCase.html#Java_8.2B_and_Anonymous_Interfaces >> >> I have tried to write some helper to let me achieve a cleaner test >> writing (it's on https://github.com/ZeeD/springbootplusdbunit ) but I >> would like to know if there is a better way to obtain my goals >> >> 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... |
From: Jeff J. <jj...@ap...> - 2020-06-24 12:34:59
|
Hi, My goal is to verify the behavior on the db of calling the rest api I've used dbUnit for testing with many products for the same tech setup, Spring Data JPA over Hibernate, and it works great. I also use PrepAndExpectedTestCase a lot because I think it is the easiest way to make the tests (less setup, more declaratively with the method params of data). I also found that csv can be used. CSV works but it is a little less flexible about setup. Yes, the docs for CSV handling are practically non-existent. I noted that awhile ago and have a TODO with notes to improve. Perhaps my notes help you: * one CSV file per table. * CSV base filename must match table name. * requires a file named table-ordering.txt containing all table names (same as the base file name; case insensitive but best to match case), one per line, sorted in insert order. * all data CSV files must reside in the same directory as table-ordering.txt * numeric CSV data file fields must not have trailing spaces before the comma-separator as will interpret it as a String instead of a number. * specify null values as null without quotes. if there is a better way to obtain my goals A quick review of your sample code shows manual approaches instead of using the framework features. My suggestion is to setup PrepAndExpectedTestCase per the doc page you mentioned , autowiring it to the tests, as it is fast and simple by copying and pasting the code from the docs. Configure it with the applicable DataFileLoader, perhaps CsvDataFileLoader for CSV instead of FlatXmlDataFileLoader as shown on the doc page. If you struggle with CSV, make flat xml work and then swap it for CSV. The rest of dbUnit usage is the same, only the DataFileLoader differs. On Wed, Jun 24, 2020 at 3:12 AM Vito De Tullio <vit...@gm...> wrote: > Hi > I'm new to dbunit, and I'm trying to understand if it can help me with > some automated integration tests. > I have a spring-boot application that normally use oracle as db, but in my > tests I'm using h2. > The interaction with the db is through spring data repositories (using > hibernate under the hood). > > My goal is to verify the behavior on the db of calling the rest api I > expose, in a controlled and reproducible manner. > > In the documentation I see that it's possible to use flatxml, xml, query > on a db, etc. but on > https://blog.mousetech.com/dbunit-and-csv-reference-data/ I also found > that csv can be used. > I really prefer this format to express the tables, but I have encountered > some troubles trying to using them with PrepAndExpectedTestCase, like how > stated in > http://dbunit.sourceforge.net/testcases/PrepAndExpectedTestCase.html#Java_8.2B_and_Anonymous_Interfaces > > I have tried to write some helper to let me achieve a cleaner test writing > (it's on https://github.com/ZeeD/springbootplusdbunit ) but I would like > to know if there is a better way to obtain my goals > > Thanks > > > -- > Vito De Tullio - Vit...@gm... > _______________________________________________ > dbunit-user mailing list > dbu...@li... > https://lists.sourceforge.net/lists/listinfo/dbunit-user > |
From: Vito De T. <vit...@gm...> - 2020-06-24 08:12:01
|
Hi I'm new to dbunit, and I'm trying to understand if it can help me with some automated integration tests. I have a spring-boot application that normally use oracle as db, but in my tests I'm using h2. The interaction with the db is through spring data repositories (using hibernate under the hood). My goal is to verify the behavior on the db of calling the rest api I expose, in a controlled and reproducible manner. In the documentation I see that it's possible to use flatxml, xml, query on a db, etc. but on https://blog.mousetech.com/dbunit-and-csv-reference-data/ I also found that csv can be used. I really prefer this format to express the tables, but I have encountered some troubles trying to using them with PrepAndExpectedTestCase, like how stated in http://dbunit.sourceforge.net/testcases/PrepAndExpectedTestCase.html#Java_8.2B_and_Anonymous_Interfaces I have tried to write some helper to let me achieve a cleaner test writing (it's on https://github.com/ZeeD/springbootplusdbunit ) but I would like to know if there is a better way to obtain my goals Thanks -- Vito De Tullio - Vit...@gm... |
From: Jeff J. <jj...@ap...> - 2020-02-24 00:18:36
|
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/changes-report.html Changes in this version include: New features: o Add new syntax to set relative date, time and timstamp in dataset Issue: 224. Thanks to kforkiss. o Setup public CI Issue: 227. o Add IsActualContainingExpectedStringValueComparer comparing if actual contains expected Issue: 229. o Add support for MSSQL's datetimeoffset data type Issue: 228. Thanks to rcd. o DefaultPrepAndExpectedTestCase.runTest(): catch Throwable instead of Exception Issue: 243. o Update Oracle Dependency to ojdbc8 from Maven Central Issue: 246. Fixed Bugs: o NPE in DefaultPrepAndExpectedTestCase.makeAdditionalColumnInfo when excludeColumns is null Issue: 417. o DefaultPrepAndExpectedTestCase.verifyData() sorts table columns by Strings Issue: 423. o IllegalArgumentException when setting PROPERTY_IDENTITY_COLUMN_FILTER Issue: 315. Thanks to lufecir. o CachedDataSet does not work Issue: 424. o FilteredDataSet does not inherit case sensitivity of wrapped set Issue: 426. Thanks to lcann. o DatabaseDataSet SchemaSet ignores case sensitivity setting in normalizing schema names Issue: 427. Thanks to lcann. o IsActualWithinToleranceOfExpectedTimestampValueComparer assumes values are represented as Timestamps Issue: 428. Thanks to lcann. o Fix null values being inserted when a column is referenced with different casing Issue: 431. Thanks to lorentzforces. Changes: o Update PostgreSQL driver version Issue: 221. Thanks to aklemp. |
From: Jeff J. <jj...@ap...> - 2019-09-22 13:40:41
|
> I have more than 400 tests but for One specific test Only i need to disable constraints Key ? The specific test must drop the constraint using DDL, run the test, then restore the constraint using DDL. On Sun, Sep 22, 2019 at 2:08 AM Philippe Couas <pc...@or...> wrote: > Hi, > > > > > > > I have more than 400 tests but for One specific test Only i need to > disable constraints Key ? > > > In my Java Spring project i have tested many options without result > > > Could you help me > > > Thanks > > > > > > [code] > > > > > package com.zz.service; > > > > import java.util.Calendar; > > > > > > > > @RunWith(SpringJUnit4ClassRunner.class) > > @ContextConfiguration(locations = { > "classpath:config/ioc/application-context-spring-test.xml" }) > > @TestExecutionListeners({ > DependencyInjectionTestExecutionListener.class, > CleanInsertTestExecutionListener3A.class, > TransactionalTestExecutionListener.class, }) > > @TransactionConfiguration(transactionManager = "myTxManager", > defaultRollback = true) > > public class FluxDSImplTest36466 { > > > > > > > > // Chargement gros flux > > @Test > > public void testSauvegardeGrosFlux1() throws > subDomainException { > > // on modifie le flux dans une transaction > et on le sauvegarde > > DefaultTransactionDefinition def = new > DefaultTransactionDefinition(); > > > def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); > > TransactionStatus status = null; > > try { > > status = > myTxManager.getTransaction(def); > > // > entityManager.createNativeQuery("SET @@foreign_key_checks = > 0;").executeUpdate(); > > // entityManager.flush(); > > Flux flux = > entityManager.find(Flux.class, 36466L); > > Flux xx = > fluxDS.createOrUpdate(flux, ON_QMANAGER, WITH_BINDINGS, SEND_QDN, > FORCEONQMANAGER, date, user); > > } finally { > > if (status != null && > !status.isCompleted()) { > > > myTxManager.rollback(status); > > } > > entityManager.clear(); > > } > > } > > } > > > > class CleanInsertTestExecutionListener3A implements > TestExecutionListener { > > private static final Logger LOG = > LoggerFactory.getLogger(CleanInsertTestExecutionListener3A.class); > > private static final String fn = > "/dataset/creationFluxUSTest/PRD36466.xml"; > > > > @Override > > public void beforeTestMethod(TestContext testContext) > throws Exception { > > // location of the data set > > String dataSetResourcePath = null; > > // first, the annotation on the test class > > DataSetLocation dsLocation = > testContext.getTestInstance().getClass().getAnnotation(DataSetLocation.class); > > if (dsLocation != null) { > > // found the annotation > > dataSetResourcePath = > dsLocation.value(); > > LOG.info("annotated test, > using data set: {} ", dataSetResourcePath); > > } else { > > // no annotation, let’s try > with the name of the test > > String tempDsRes = > testContext.getTestInstance().getClass().getName(); > > // tempDsRes = > StringUtils.replace(tempDsRes, " . ", " / "); > > tempDsRes = fn; > > if > (getClass().getResourceAsStream(tempDsRes) != null) { > > LOG.info(" > detected default dataset: {} ", tempDsRes); > > > dataSetResourcePath = tempDsRes; > > } else { > > LOG.info(" no > default dataset "); > > } > > } > > if (dataSetResourcePath != null) { > > Resource dataSetResource = > testContext.getApplicationContext().getResource(dataSetResourcePath); > > FlatXmlDataSetBuilder builder > = new FlatXmlDataSetBuilder(); > > builder.setColumnSensing(true); > > IDataSet dataSet = > builder.build(dataSetResource.getInputStream()); > > ReplacementDataSet > replaceDataSet = new ReplacementDataSet(dataSet); > > > replaceDataSet.addReplacementObject("[NULL]", null); > > > replaceDataSet.addReplacementObject("[null]", null); > > > replaceDataSet.addReplacementObject("[Xnull]", null); > > Calendar cal = > Calendar.getInstance(Locale.getDefault()); > > > replaceDataSet.addReplacementObject("[NOW]", cal.getTime()); > > IDatabaseConnection dbConn = > new > DatabaseDataSourceConnection(testContext.getApplicationContext().getBean(DataSource.class)); > > // BAD TEST > > // > dbConn.getConnection().prepareStatement("set @@session.foreign_key_checks = > 0").execute(); > > // > dbConn.getConnection().prepareStatement("set referential_integrity > FALSE").execute(); > > // > dbConn.getConnection().prepareStatement("set > foreign_key_checks=0;").execute(); > > // > dbConn.getConnection().prepareStatement("set > foreign_key_checks=0").execute(); > > // > dbConn.getConnection().createStatement().execute("SET > FOREIGN_KEY_CHECKS=0;"); > > > DatabaseOperation.CLEAN_INSERT.execute(dbConn, replaceDataSet); > > } else { > > LOG.info(" {} does not have > any data set, no data injection ", testContext.getClass().getName()); > > } > > } > > > > > > } > > > > [/code] > > > > Regards > > Philippe > _______________________________________________ > dbunit-user mailing list > dbu...@li... > https://lists.sourceforge.net/lists/listinfo/dbunit-user > |