FYI:

JUnit 3.8.2, which was released late last year, includes a number of 
bugfixes and small improvements from the version that is currently 
officially supported by our test harness, 3.8.1.

The most noticeable improvement is a change to the String comparison 
format. For example, with JUnit 3.8.1, if we compare two SQLStates that 
are almost the same, but not quite, JUnit will report something like 
this (don't mind the actual failure, I simply tweaked the test to make a 
point):

 > There was 1 failure:
 > 1) 
testStatementExecuteAfterConnectionClose(org.apache.derbyTesting.functionTests.tests.jdbc4.StatementTest)junit.framework.ComparisonFailure: 
Unexpected SQL state for performing operations on a closed statement. 
expected:<...6> but was:<...3>
 > FAILURES!!!

It is hard to see what the SQLState we actually got was, and further 
debugging is required.

With JUnit 3.8.2, this is what we'll see instead:

 > There was 1 failure:
 > 1) 
testStatementExecuteAfterConnectionClose(org.apache.derbyTesting.functionTests.tests.jdbc4.StatementTest)junit.framework.ComparisonFailure: 
Unexpected SQL state for performing operations on a closed statement. 
expected:<0800[6]> but was:<0800[3]>
 > FAILURES!!!


The rest of 3.8.2 is , AFAIK, compatible with 3.8.1.

JUnit 3.8.2 can be downloaded from
http://sourceforge.net/project/showfiles.php?group_id=15278
(scroll down past the 4.1 release).

I'm attaching the changelog, since I downloaded it some months ago and I 
am not able to find it online any longer.

Try it out if you want. Perhaps we should start recommending JUnit 3.8.2 
instead of 3.8.1?


-- 
John


Knut Anders Hatlen (JIRA) wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-1417?page=comments#action_12430163 ] 
>             
> Knut Anders Hatlen commented on DERBY-1417:
> -------------------------------------------
> 
> Hi Kristian, I tried to run derbyall with the 8a patch and the patch for DERBY-1473. I see this error:
> 
> *** End:   TestQueryObject jdk1.6.0-rc jdbc40:jdbc40 2006-08-24 00:50:02 ***
> ********* Diff file jdbc40/jdbc40/PreparedStatementTest.diff
> *** Start: PreparedStatementTest jdk1.6.0-rc jdbc40:jdbc40 2006-08-24 00:51:29 ***
> 0 add
>> ................................F.........
>> There was 1 failure:
>> 1) testSetBinaryStreamLengthLessOnBlobTooLong(org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<...CL30> but was:<...SDA4>
>> FAILURES!!!
>> Tests run: 82,  Failures: 1,  Errors: 0
> Test Failed.
> *** End:   PreparedStatementTest jdk1.6.0-rc jdbc40:jdbc40 2006-08-24 00:51:34 ***