List All Pages
In order not to fiddle around with the DBUnit classpath add the following to your ant script
<path id="lib.path">
<fileset dir="../lib"...
This page is to discuss general BestPractices when doing DatabaseTesting against a real database.
I believe the two most important practices are OneDatabasePerDeveloper and GoodSetupNoCleanup. Not...
How to build DbUnit?
Since version 2.0, DbUnit is build with Maven 1.0-rc1. You can download Maven from this URL:
http://maven.apache.org/
You can see project dependencies at the following URL, and...
The current release of dbunit (dbunit-2.2.1.jar) does not seem to include slf4j, nor could I find mention of this dependency on the dbunit site.
I believe that Richard Dallaway's notes about database unit testing is a good start for now. —ManuelLaflamme
You can replace the default DbUnit DataTypeFactory to get custom data types support. DbUnit provides factories, located in ''org.dbunit.ext'' subpackages, for some RDBMS.
OracleDataTypeFactory |...
Originally contributed by FedericoSpinazzi. This DataTypeFactory implementation currently support following IbmDB2 data types:
RDMS type
DbUnit...
DbUnit is a JUnit extension (also usable with Ant) targeted for database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way...
Official DbUnit FAQ from DbUnit website
You can report errors, add precisions or discuss the official FAQ here.
You have an idea for a good FAQ and know the answer? Add it...
There is currently ongoing discussions in the DbUnit developers mailing list about a possible DbUnitDotNet port initiative. —ManuelLaflamme
NDbUnit is an existing project hosted at SourceForge....
Please ask your questions in the DbUnit user mailing list. Questions posted there are usually answered promptly.
Question written here may not be answered in a timely manner.
BuildingDbUnit |...
You should always avoid creating tests that depends on results of preceding tests; thankfully this is the main purpose of DbUnit.
Don't be afraid to leave your trace after a test; principally with...
H2 is the most recent database supported by DbUnit, very similar to HypersonicSQL. So similar that there has been a proposal to refactor the HSQLDB and H2 implementations to mutualize the common...
This DataTypeFactory implementation currently support following H2 data types:
RDMS type
DbUnit type
BOOLEAN
BooleanDataType
If you are allowed to edit pages in this Site, simply click on edit button at the bottom of the page. This will open an editor with a toolbar pallette with options.
To create a link to a new page,...
How do I tell DbUnit to look at aliases as well as tables when searching the DatabaseMetaData?
There is a property on DatabaseConfig which allows you to set the "table types" it will use when...
DbUnit is being developed and unit tested against in-memory HypersonicSQL database. Working great together but I'm not using HypersonicSQL for any other project than DbUnit. —ManuelLaflamme
I'm not personally using IbmDB2 but another DbUnit project member, FedericoSpinazzi, wrote the Db2DataTypeFactory. —ManuelLaflamme
I've had the need to test an XML enabled DB2 UDB v.8 database....
If you never contributed to a wiki please refer to the quickstart and to the syntax pages.
Please comment your wiki posts so they can be reviewed and easily reverted in case of typos or any other...
ManuelLaflamme is the author of the DbUnit database testing-framework.
''I live at Montreal, Canada. I currently work as Senior Developer for Oz Communication since July 2002. I previously worked...
DBUnit user since 1.5.6.
Mike Kienenberger (mkienenb)
mkienenb at alaska dot net
Java MockObjects:
http://www.mockobjects.com/
From time to time I run the DbUnit test suite against an MsSQL instance. At first glance DbUnit work great with it but I'm not using MsSQL for any real life project. The test suite does not use any...
I'm occasionally testing DbUnit with the MySQL instance allocated by SourceForge for the DbUnit project. I fixed multiple case sensitiveness issue by using it. I'm not using MySQL for any other...
This DataTypeFactory implementation currently support following MySQL data types:
RDMS type
DbUnit type
longtext
ClobDataType
bit
BooleanDataType
point
BytesDataType
Describe the new page here.
Comments:
NDbUnit sources are in CVS now.NDbUnit CVS
NDbUnit development merged with DbUnit.Net.SourceForge Request
Development will be continued with monitoring of...
This page illustrates how to the http://www.dbunit.org/properties/primaryKeyFilter property to refresh a table which do not have any primary key. In this situation, you must make sure one of the...
Testing can be simplified if you can get your database in a known state before a test is run. A database should only be used for one test at a time; otherwise the database state cannot be...
http://www.OpenBase.com
I am using the May 3rd, 2004, CVS snapshot with OpenBase8 (8.0.2 on Windows). DBUnit 2.0 will not work with OpenBase due to ResultSet/Statement-closing ordering problems...
Im using DbUnit with OracleDatabase at work on a daily basis since DbUnit inception. You can be pretty confident that DbUnit works well with OracleDatabase and will remain compatible with it...
This DataTypeFactory implementation currently support following OracleDatabase data types:
RDMS type
DbUnit...
This page is a collection of changes available from the CVS repository since the release of DbUnit 2.0. Also look at related PendingDbUnitFaq.
==== DbUnit CVS repository ====
May 3, 2004
Added...
This page is a collection of DbUnitFaq that only applies to the latest development code located in the DbUnit CVS repository. They will probably be integrated into the official DbUnitFaq at the...
I am using DbUnit 2.0 with PostgreSQL 7.3 and 7.4 at work on a daily basis.
All datatypes I use (including bytea) work with the default DataTypeFactory.
Testing of a system incorporating...
This page is a list of recently changed pages. The default timezone is US PST. See the Preferences page for more options. Here is the rss feed for this wiki.
DbUnit user since 2006.
Dublin, Ireland.
Welcome page
What is a Wiki Site?
How to edit pages?
How to join this site?
Site members
Recent changes
List all pages
Page Tags
Site Manager
Page tags
Add a new page
edit this panel
Members:
Moderators
Admins
The DbUnit framework is actively developed and tested with OracleDatabase and HypersonicSQL. DbUnit uses a fairly simple SQL syntax and is compatible, out of the box, with most of the others...
Success to import some data to sybase 12.5 to run unit test
Beware of timestamps though - I am having trouble because Sybase's nanosecond resolution of 1/300th second is causing comparison errors...
example menu
example item 1
example item 2
contact
DbUnit is a JUnit extension (also usable with Ant) targeted for database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way...
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
Read the original http://groups.yahoo.com/group/junit/message/4239 DbUnit 1.0 announcement posted in the JUnit mailing list. —ManuelLaflamme
You will find BIN$ tables in Oracle 10 when you have dropped a table; this is part of Oracle's "Recycle Bin" functionality.
You can delete these tables by typing "PURGE RECYCLEBIN", or use a filter...