Enable TestCase compositions Migrate SCM to Subversion Support for MySQL 5.0 boolean datatype Added pom.xml so it can be built by Maven 2. XmlDataSetWriter now has a flag to include column's name as comment. Added org.dbunit.util.search and org.dbunit.database.search packages, whose classes can be used to search tables depedencies for a given table. Add "transaction" attribute to ant tasks to wrap operations in a single transaction. Can make operations faster. Typo in howto example Properly support writing NCLOBs to Oracle Support CSV files from a URL (e.g. jar file) + CSV fixes Fix the driver in classpath/driver not in classpath to always work regardless of configured driver. Typo in test class AbstractDataSetTest new HsqldbDataTypeFactory for working with booleans in HsqlDB. 741394 - New database compare Ant tag. See Ant task documentation. New Comma Separated Values (CSV) dataset implementation. 824328 & 948479 - Ability to add DOCTYPE declaration when writing a flat Xml dataset. See FAQ. 884422 - FlatDtdWriter has now the ability to generate DTDs with choice model instead of sequence model. Ability to import external file for binary data types like BLOB; the value can be either a qualified URL or a file path name. Do not omit NULL values anymore in INSERT statements. Now only XmlDataSet's <none/> tag are omitted. With FlatXmlDataSet you must use the ReplacementDataSet to achieve the same behavior. 937732 - XlsDataSet now use UTF-16 encoding to support Asian characters. Patch submitted by Shuhei Kondo. Applied XlsTable empty table detection patch submitted by Deepak Kaimal. Added back FlatXmlDataSet constructors taking URL as argument missing in version 2.0. 918631 & 925585 - Fixed FlatXmlDataSet constructors taking InputStream/Reader for loading DTD. DELETE_ALL operation now deletes tables only *once* in reverse order they are encountered. Before, duplicate tables were resulting in multiple deletes. Patch submitted by John Hurst. DELETE_ALL operation now compatible with StreamingDataSet. 947330 - Now closing ResultSet before Statement to fix exceptions thrown by the Firebird JDBC driver and the OpenBase 8.0 JDBC driver. 921869 - Fixed ParameterIndexOutOfBoundsException with InterBase. 947809 - Moved createMetaData() static method from AbstractResultSet to DatabaseTableMetaData and made it public. Can now be used to create ITable from a ResultSet. Support for large Oracle BLOB. Must use OracleDataTypeFactory. Oracle LONG RAW data type support via OracleDataTypeFactory. Original patch submitted by Markus Muller. Added back support for Oracle FLOAT missing in DbUnit 2.0. Must use OracleDataTypeFactory. Support for Oracle NCHAR2 as proposed by Deepak Kaimal. Must use OracleDataTypeFactory. Added DataType.isDateTime() method proposed by Ayman Mahfouz. 726366 & 884422 - Added IColumnFilter interface. Can be used to filter out some table columns. See FAQ. Renamed ITableFilter.isValidName() method to accept() to be consistent with the new IColumnFilter interface. 955354 - Ability to determine the primary keys with IColumnFilter interface instead of DatabaseMetaData.getPrimaryKeys(). Primary keys sequence is not predictable when using filter. See FAQ. Ability to plug custom IDENTITY column detection strategy for InsertIdentityOperation when using user defined types. See FAQ. Added DefaultTableFilter class, which combines capability of the Include/ExcludeTableFilter classes. Mavenized the build and the website! Now use SAX2 instead of Electric XML DOM parser. Streamed mode allows importing and exporting very large XML datasets with minimal memory consumption. Flat XML dataset validation. New ITableIterator interface used to iterate thru dataset tables. Allows lazy tables initialization for some dataset implementations. The IDataSet.getTables method have been deprecated and usage should be avoided. Global System properties are not supported anymore. You must now use the new DatabaseConfig object to alter DbUnit behaviours. Configurable data type factory to easily integrates new data types with the DbUnit core. Factory implementations available for some database vendors. Submit your own! Oracle TIMESTAMP data type support via the OracleDataTypeFactory. Fix truncated Oracle DATE. Must use the OracleDataTypeFactory. Fix for Oracle CLOB greater than 4000 bytes. Must use the OracleDataTypeFactory. MySQL 'longtext' data type support via the MySqlDataTypeFactory. DB2 XML data types support via the Db2DataTypeFactory. Database views support. New pluggable filter strategies for DataSetFilter. You can now exclude/include tables using wildcard patterns. Ability to sort tables by their dependencies with the new DatabaseSequenceFilter strategy. New ReplacementDataSet decorator, which can replace decorated dataset values on the fly. Can be used with flat XML dataset as a new way to specify null values. New XlsDataSet. An MS Excel dataset implementation. Uses the Jakarta POI package. Assertion.assertEquals is now performing typed comparison instead of string representation comparison. INSERT, CLEAN_INSERT and REFRESH operations do not override database default values anymore with null values. Null values are now omitted from insert statements. Operations use multiple prepared statements for the same table, when null values vary from row to row. Moved InsertIdentityOperation to "org.dbunit.ext.mssql" package to be consistent with other vendor extensions. Temporary keep a deprecated copy in "org.dbunit.operation.mssqlserver" to ease transition to DbUnit 2. 786543 - NULL primitive values incorrectly returned as zero (0). Fix Oracle CLOB values incorrectly returned as NULL. DatabaseDataSet improvements: faster access to metadata cache and keep original database table ordering. Better handling of the various data types in general. WARNING! New abstract methods have been added to the DataType class. This change may break your environment if you have implemented your own data types. More efficient XmlDataSet writing. Now put values in CData block only when necessary. Do not enable batched statement by default anymore. Many JDBC drivers have problems with this feature. Fixed table name issue with case sensitive database. 615636 & 735095 - Incorrect XML encoding. Better handling of the XML encoding while writing and reading XML datasets. InputStream and OutputStream methods in XML dataset implementations are no more deprecated. 736439 - Problems with InsertOperation and triggers. 736967 - Wrong scale for numeric value with the jConnect driver for Sybase ASE. Fixed DELETE operation that was not deleting tables in reverse order as expected. 712329 - setObject fails on BEA JDriver for MS-SQL. DbUnitTask DTD export optimization. REFRESH operation optimization. Multiple bugfixes. 533321 - DbUnit is now case insensitive. 555455 - Supports table names escaping (see escapePattern property). 551925 - Allows duplicate table names in datasets. A new method, getTables(), have been added in the IDataSet interface. 590245 & 684610 - New Reader and Writers methods to read and write XML datasets. InputStream and OutputStream methods are now deprecated. New SortedTable and SortedDataSet decorator classes. 645691 - Added the <classpath> nested element in DbUnitTask ant task; used to load the JDBC classes. Added <query> nested element in DbUnitTask <export>. Allows exporting the result of a SELECT as a table of a dataset. See ant task documentation. New Canoo Webtest integration guide. DbUnitTask for Ant contributed by Timothy Ruppert and Ben Cox. Moved the Base64 class to the org.dbunit.util package because Visual Age for Java is not able to handle classes located in the default package. Added system properties documentation. 542034 - Detect ambiguous table names. 542462 - Added a system property to disable usage of batch statement even if the target database support it.. 545238 - Sort tables prior to comparing them. DbUnit now generates an ORDER BY clause in the select statement used by DatabaseDataSet.getTable(). Rows are sorted by primary keys. 554249 - None column values. Added support for BLOB and CLOB data types. Added support for binary data types: BINARY, VARBINARY and LONGVARBINARY. Binary data is persisted in xml datasets using the base64 encoding scheme. Deprecated the DataSetUtils.assertEquals() methods. You should now use Assertion.assertEquals(). 533537 - FlatXmlDataSet and null values. 533537 - Problem with single quotes. 534810 - Problem when primary key include all columns Added support for multiple schemas per connection. See FAQ document. Removed element <none/> from dataset.dtd. This feature was incompatible with future support for the binary data types. 530998 - DataSetUtils.AssertEquals(ITable table, ITable table). 533540 - Problem with DATE, TIME and TIMESTAMP. Added the flat XML dataset format. See the FlatXmlDataSet in Core Components document. Added database data verification feature. See Getting Started document. Updated Electric XML parser to version 3.2. Connections are now closed in each setUp() and tearDown(). You must override the DatabaseTestCase.closeConnection() and provide an empty body to modify this behavior. This is not recommended to bypass connection close if you use connection pooling. Added the IDatabaseConnection interface. Added the DatabaseDataSourceConnection class. This class provides support for accessing JDBC connections from a DataSource. JDBC connections are requested on demand from the DataSource. Multiple performance improvement. 526235 - Cannot export tables with JDBC-ODBC bridge and MS-SQL.