[ 
https://issues.apache.org/jira/browse/DERBY-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Knut Anders Hatlen updated DERBY-2647:
--------------------------------------

    Attachment: 2647.diff

I am not able to reproduce this failure in my environment (OpenSolaris snv_64, 
Sun Java 1.4.2, 1.5.0 and 1.6.0).

The test that fails performs the following query
  select * from SYSCS_DIAG.Error_messages where SEVERITY >= 40000 order by 
SQL_STATE
and calls JDBC.assertFullResultSet() on the result.

But even though it orders the results by SQL_STATE, the order of the rows in 
the result is not well-defined as many of them have the same SQL state. The two 
error messages mentioned in the expected/found string both have SQL state 08001.

Attaching a patch which makes the test use JDBC.assertUnorderedResultSet() 
instead of assertFullResultSet(). I have no way of verifying that this fixes 
the problem, but I have committed what I think is a fix with revision 539642.

> .lang.ErrorCodeTest fails with 'Required Derby DataSource property {0} not 
> set.'
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2647
>                 URL: https://issues.apache.org/jira/browse/DERBY-2647
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure, Test
>    Affects Versions: 10.3.0.0
>         Environment: OS: Solaris 10 11/06 s10x_u3wos_10 X86 64bits - SunOS 
> 5.10 Generic_118855-33
> JVM: Sun Microsystems Inc. 1.5.0_07-b03
> Derby Information: JRE - JDBC: J2SE 5.0 - JDBC 3.0
>            Reporter: Ole Solberg
>            Priority: Minor
>         Attachments: 2647.diff
>
>
> Seen in
> http://dbtg.thresher.com/derby/test/trunk16/jvmAll/testing/Limited/testSummary-537924.html
>  / 
> http://dbtg.thresher.com/derby/test/trunk16/jvmAll/testing/testlog/JDK16Jvm1.5SunOS-5.10_i86pc-i386/537924-org.apache.derbyTesting.functionTests.suites.All_diff.txt
> 1) 
> test_errorcode(org.apache.derbyTesting.functionTests.tests.lang.ErrorCodeTest)junit.framework.AssertionFailedError:
>  Column value mismatch @ column 'MESSAGE', row 2:
>     Expected: >A connection could not be established because the security 
> token is larger than the maximum allowed by the network protocol.<
>     Found:    >Required Derby DataSource property {0} not set.<
>       at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:847)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:740)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:682)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:640)
>       at 
> org.apache.derbyTesting.functionTests.tests.lang.ErrorCodeTest.test_errorcode(ErrorCodeTest.java:244)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to