Here are the release notes:
Release notes for SQLUnit version 4.1
=====================================
Bugs fixed in this release
--------------------------
1. Fixed problem with JNDI lookup not working correctly because it was using the URLClassLoader from ant.
2. Fixed bug pointed out by Chris Watts, that SQLUnit was incorrectly handling NULL values returned from a stored procedure call. Added null handling for types, compatible with pre-4.0 code, to return the string "NULL".
3. Fixed bug pointed out by Arun Viswanath, that SQLUnit was incorrectly handling NULL values returned in OUTPARAMs. This is the same fix as described above.
4. Fixed bug pointed out by Arun Vishwanath, problem with specifying non-basic types (oracle.CURSOR) as parameter values.
5. Fixed bug pointed out by Chris Watts, resultset index values in an error returns actual index positions, rather than resultset ids.
6. Fixed bug pointed out by Jojo Agye, SQLUnit throwing a ClassCastException when getting an error in Assertion.
7. Fixed bug with ConcurrentModificationException in SymbolTable when the multi-threaded version of diff is called.
Changes in this release
-----------------------
Contributions
-------------
1. TypelessPercentageMatcher, a new matcher written by Chris Watts, which allows value matches for numeric data within a certain tolerance, and value matches for String values.
New Features
------------
1. Feature Request (Chris Watts): Typeless matching between results returned from two different databases, implemented as TypelessMatcher. Chris implemented this independently using the TypelessPercentageMatcher described above. Implemented in SQLUnit as a new assertion "resultset-values-equal" which uses TypelessMatcher internally.
2. SQLUnit now allows match elements within test tags as well as diff tags.
3. Enhancement: Added capability to specify multiple URLs (JAR file or class
file directories) as a comma-separated string in the jarfile-url text. This was to allow mock tests to be built for jarfile-url.
4. Bug/Feature 1032804, pointed out by Satish Chitnis. SQLUnit now treats a semi-colon terminator at the end of line as a statement terminator in included files specified by the include tag.
Documentation
-------------
1. Added new chapter on getting a connection.
2. Documentation now provides a list of currently supported matchers.
3. Documentation now provides a list of currently supported reporters.
4. Based on a request from Brian E Dick, SQLUnit now goes back to the multi-page format for its user guide for convenient viewing online, and provides two alternate forms of documentation, a printer friendly (single page HTML) and a downloadable (tar.gz) format.
Refactoring work
----------------
1. There are fewer error messages from SQLUnit with this release. Error messages have been consolidated and in some cases, eliminated. The text has been fixed to make it easier to understand in some cases.
2. Exception chaining has been revisited. There have been some bugs in the past that were difficult to track down, because SQLUnit did not pass the exception all the way up. Most of these cases have been identified and fixed.
3. Type getting logic to a separate HashMap subtype TypeHashMap.
4. The properties files have been moved to the /etc subdirectory under the root of the distribution. The build script will copy the files to the correct place in the src tree when building. This makes the properties files more visible.
5. A new CheckStyle target has been added to the build file, which allows you to run CheckStyle against the tree using the docs/sqlunitCodingChecks.xml. The test tree has not yet been checked using CheckStyle.
New Unit Tests
--------------
Tests: Add tests for different connection
Tests: Add tests for custom asserts
Let me know if you notice any issues.
Thanks
Sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Here are the release notes:
Release notes for SQLUnit version 4.1
=====================================
Bugs fixed in this release
--------------------------
1. Fixed problem with JNDI lookup not working correctly because it was using the URLClassLoader from ant.
2. Fixed bug pointed out by Chris Watts, that SQLUnit was incorrectly handling NULL values returned from a stored procedure call. Added null handling for types, compatible with pre-4.0 code, to return the string "NULL".
3. Fixed bug pointed out by Arun Viswanath, that SQLUnit was incorrectly handling NULL values returned in OUTPARAMs. This is the same fix as described above.
4. Fixed bug pointed out by Arun Vishwanath, problem with specifying non-basic types (oracle.CURSOR) as parameter values.
5. Fixed bug pointed out by Chris Watts, resultset index values in an error returns actual index positions, rather than resultset ids.
6. Fixed bug pointed out by Jojo Agye, SQLUnit throwing a ClassCastException when getting an error in Assertion.
7. Fixed bug with ConcurrentModificationException in SymbolTable when the multi-threaded version of diff is called.
Changes in this release
-----------------------
Contributions
-------------
1. TypelessPercentageMatcher, a new matcher written by Chris Watts, which allows value matches for numeric data within a certain tolerance, and value matches for String values.
New Features
------------
1. Feature Request (Chris Watts): Typeless matching between results returned from two different databases, implemented as TypelessMatcher. Chris implemented this independently using the TypelessPercentageMatcher described above. Implemented in SQLUnit as a new assertion "resultset-values-equal" which uses TypelessMatcher internally.
2. SQLUnit now allows match elements within test tags as well as diff tags.
3. Enhancement: Added capability to specify multiple URLs (JAR file or class
file directories) as a comma-separated string in the jarfile-url text. This was to allow mock tests to be built for jarfile-url.
4. Bug/Feature 1032804, pointed out by Satish Chitnis. SQLUnit now treats a semi-colon terminator at the end of line as a statement terminator in included files specified by the include tag.
Documentation
-------------
1. Added new chapter on getting a connection.
2. Documentation now provides a list of currently supported matchers.
3. Documentation now provides a list of currently supported reporters.
4. Based on a request from Brian E Dick, SQLUnit now goes back to the multi-page format for its user guide for convenient viewing online, and provides two alternate forms of documentation, a printer friendly (single page HTML) and a downloadable (tar.gz) format.
Refactoring work
----------------
1. There are fewer error messages from SQLUnit with this release. Error messages have been consolidated and in some cases, eliminated. The text has been fixed to make it easier to understand in some cases.
2. Exception chaining has been revisited. There have been some bugs in the past that were difficult to track down, because SQLUnit did not pass the exception all the way up. Most of these cases have been identified and fixed.
3. Type getting logic to a separate HashMap subtype TypeHashMap.
4. The properties files have been moved to the /etc subdirectory under the root of the distribution. The build script will copy the files to the correct place in the src tree when building. This makes the properties files more visible.
5. A new CheckStyle target has been added to the build file, which allows you to run CheckStyle against the tree using the docs/sqlunitCodingChecks.xml. The test tree has not yet been checked using CheckStyle.
New Unit Tests
--------------
Tests: Add tests for different connection
Tests: Add tests for custom asserts
Let me know if you notice any issues.
Thanks
Sujit