Derby
  1. Derby
  2. DERBY-1800

testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.2.2.0, 10.3.1.4
    • Component/s: Network Server
    • Labels:
      None
    • Environment:
      All
    • Bug behavior facts:
      Regression Test Failure

      Description

      Has failed since 438528, changes: http://www.multinet.no/~solberg/public/Apache/Daily/jvm1.6/UpdateInfo/438528.txt

      Logs in http://www.multinet.no/~solberg/public/Apache/Daily/jvm1.6/Limited/testSummary-438528.html.
      E.g.

          • Start: _Suite jdk1.6.0-rc DerbyNetClient derbynetclientmats:jdbc40 2006-08-31 02:52:09 ***
            0 add
            > ............................F.............
            > There was 1 failure:
            > 1) testSetBinaryStreamLengthLessOnBlobTooLong(org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<22001> but was:<58009>
            > FAILURES!!!
            > Tests run: 2048, Failures: 1, Errors: 0
            Test Failed.
          • End: _Suite jdk1.6.0-rc DerbyNetClient derbynetclientmats:jdbc40 2006-08-31 02:52:26 ***
      1. DERBY-1800.diff
        0.5 kB
        Andreas Korneliussen

        Activity

        Hide
        Kristian Waagan added a comment -

        There are many instances of the 58009 state. Here's the stack trace:

        java.sql.SQLException: A communications error has been detected: Broken pipe.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
        at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:345)
        at org.apache.derby.client.am.PreparedStatement.executeUpdate(PreparedStatement.java:389)
        at org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest.setBinaryStreamOnBlob(PreparedStatementTest.java:1085)
        at org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest.testSetBinaryStreamLengthLessOnBlobTooLong(PreparedStatementTest.java:860) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.textui.TestRunner.doRun(TestRunner.java:116)
        at junit.textui.TestRunner.start(TestRunner.java:172)
        at junit.textui.TestRunner.main(TestRunner.java:138)
        Caused by: org.apache.derby.client.am.DisconnectException: A communications error has been detected: Broken pipe.
        at org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(NetAgent.java:408)
        at org.apache.derby.client.net.Request.flushScalarStreamSegment(Request.java:593)
        at org.apache.derby.client.net.Request.writePlainScalarStream(Request.java:478)
        at org.apache.derby.client.net.Request.writeScalarStream(Request.java:242)
        at org.apache.derby.client.net.NetStatementRequest.buildEXTDTA(NetStatementRequest.java:855)
        at org.apache.derby.client.net.NetStatementRequest.writeExecute(NetStatementRequest.java:145)
        at org.apache.derby.client.net.NetPreparedStatement.writeExecute_(NetPreparedStatement.java:172)
        at org.apache.derby.client.am.PreparedStatement.writeExecute(PreparedStatement.java:1557)
        at org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:1803)
        at org.apache.derby.client.am.PreparedStatement.executeUpdateX(PreparedStatement.java:394)
        at org.apache.derby.client.am.PreparedStatement.executeUpdate(PreparedStatement.java:380)
        ... 24 more
        Caused by: java.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at org.apache.derby.client.net.Request.sendBytes(Request.java:1221)
        at org.apache.derby.client.net.Request.flushScalarStreamSegment(Request.java:591)
        ... 33 more

        Show
        Kristian Waagan added a comment - There are many instances of the 58009 state. Here's the stack trace: java.sql.SQLException: A communications error has been detected: Broken pipe. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95) at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:345) at org.apache.derby.client.am.PreparedStatement.executeUpdate(PreparedStatement.java:389) at org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest.setBinaryStreamOnBlob(PreparedStatementTest.java:1085) at org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest.testSetBinaryStreamLengthLessOnBlobTooLong(PreparedStatementTest.java:860) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.extensions.TestSetup.run(TestSetup.java:23) at junit.textui.TestRunner.doRun(TestRunner.java:116) at junit.textui.TestRunner.start(TestRunner.java:172) at junit.textui.TestRunner.main(TestRunner.java:138) Caused by: org.apache.derby.client.am.DisconnectException: A communications error has been detected: Broken pipe. at org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(NetAgent.java:408) at org.apache.derby.client.net.Request.flushScalarStreamSegment(Request.java:593) at org.apache.derby.client.net.Request.writePlainScalarStream(Request.java:478) at org.apache.derby.client.net.Request.writeScalarStream(Request.java:242) at org.apache.derby.client.net.NetStatementRequest.buildEXTDTA(NetStatementRequest.java:855) at org.apache.derby.client.net.NetStatementRequest.writeExecute(NetStatementRequest.java:145) at org.apache.derby.client.net.NetPreparedStatement.writeExecute_(NetPreparedStatement.java:172) at org.apache.derby.client.am.PreparedStatement.writeExecute(PreparedStatement.java:1557) at org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:1803) at org.apache.derby.client.am.PreparedStatement.executeUpdateX(PreparedStatement.java:394) at org.apache.derby.client.am.PreparedStatement.executeUpdate(PreparedStatement.java:380) ... 24 more Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at org.apache.derby.client.net.Request.sendBytes(Request.java:1221) at org.apache.derby.client.net.Request.flushScalarStreamSegment(Request.java:591) ... 33 more
        Hide
        Andreas Korneliussen added a comment -

        I will check if this is caused by DERBY-1559, and if that is the case, fix the issue.

        Show
        Andreas Korneliussen added a comment - I will check if this is caused by DERBY-1559 , and if that is the case, fix the issue.
        Hide
        Andreas Korneliussen added a comment -

        The problem is caused by not flushing the blob data after an exception occurs.
        Attached patch makes the test pass. I will test the patch more before committing.

        Show
        Andreas Korneliussen added a comment - The problem is caused by not flushing the blob data after an exception occurs. Attached patch makes the test pass. I will test the patch more before committing.
        Hide
        Andreas Korneliussen added a comment -

        Tests shows that the failure has been fixed. Derbyall passes. Running the jdbc40 suite, fails with more or less the same erros on client and embedded, indicating that those failures are not related to this fix, or DERBY-1559.

        JDBC40_EMBEDDED:

        Generating report for RunSuite jdbc40 null null null true
        ------------------ Java Information ------------------
        Java Version: 1.6.0-rc
        Java Vendor: Sun Microsystems Inc.
        Java home: /usr/local/java/jdk1.6.0_b98/jre
        Java classpath: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_de_DE.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_es.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_fr.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_it.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ja_JP.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ko_KR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_pt_BR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_CN.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_TW.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyTesting.jar:/expor
        OS name: SunOS
        OS architecture: x86
        OS version: 5.10
        Java user name: ak136785
        Java user home: /home/ak136785
        Java user dir: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jdbc40_embedded
        java.specification.name: Java Platform API Specification
        java.specification.version: 1.6
        --------- Derby Information --------
        JRE - JDBC: Java SE 6 - JDBC 4.0
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbytools.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbynet.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyclient.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc.jar] 2.4 - (17)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc_license_c.jar] 2.4 - (17)
        ------------------------------------------------------
        ----------------- Locale Information -----------------
        Current Locale : [English/United States [en_US]]
        Found support for locale: [de_DE]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [es]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [fr]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [it]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [ja_JP]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [ko_KR]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [pt_BR]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [zh_CN]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [zh_TW]
        version: 10.3.0.0 alpha - (438476:438489M)
        ------------------------------------------------------
        Test environment information:
        COMMAND LINE STYLE: jdk13
        TEST CANONS: master
        ------------------------------------------------------
        ------------------------------------------------------
        Summary results:

        Test Run Started: 2006-09-04 14:05:59.0
        Test Run Duration: 00:02:19

        10 Tests Run
        90% Pass (9 tests passed)
        10% Fail (1 tests failed)
        0 Suites skipped
        ------------------------------------------------------
        Failed tests in: jdbc40_fail.txt
        ------------------------------------------------------
        Passed tests in: jdbc40_pass.txt
        ------------------------------------------------------
        System properties in: jdbc40_prop.txt
        ------------------------------------------------------
        ------------------------------------------------------
        Failure Details:

                        • Diff file jdbc40/jdbc40/_Suite.diff
            • Start: _Suite jdk1.6.0-rc jdbc40:jdbc40 2006-09-04 14:08:02 ***
              0 add
              > > .......E.E.E.E.E.E.E.E.....E.E.E.E...................
              > > ..............................F..F.F.F.......
              > > ........E.E.E.E.E.E.E.E.....E.E.E.E..................
              > > There were 24 errors:
              > > 1) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 33 more
              > > 2) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 32 more
              > > 3) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 31 more
              > > 4) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 32 more
              > > 5) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 33 more
              > > 6) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 32 more
              > > 7) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 31 more
              > > 8) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 32 more
              > > 9) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 33 more
              > > 10) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 32 more
              > > 11) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 31 more
              > > 12) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 32 more
              > > 13) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 37 more
              > > 14) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 36 more
              > > 15) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 35 more
              > > 16) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'.
              > > ... 36 more
              > > 17) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 37 more
              > > 18) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 36 more
              > > 19) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 35 more
              > > 20) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'.
              > > ... 36 more
              > > 21) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 37 more
              > > 22) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 36 more
              > > 23) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 35 more
              > > 24) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'.
              > > ... 36 more
              > > There were 4 failures:
              > > 1) testTypesNCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-15> but was:<-8>
              > > 2) testTypesLONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-16> but was:<-10>
              > > 3) testTypesNCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<2011> but was:<2007>
              > > 4) testTypesROWID(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-8> but was:<2008>
              > > FAILURES!!!
              > > Tests run: 2053, Failures: 4, Errors: 24
              Test Failed.
            • End: _Suite jdk1.6.0-rc jdbc40:jdbc40 2006-09-04 14:08:18 ***
              ------------------------------------------------------

        JDBC40_CLIENT:

        Generating report for RunSuite jdbc40 null null DerbyNetClient true
        ------------------ Java Information ------------------
        Java Version: 1.6.0-rc
        Java Vendor: Sun Microsystems Inc.
        Java home: /usr/local/java/jdk1.6.0_b98/jre
        Java classpath: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_de_DE.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_es.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_fr.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_it.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ja_JP.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ko_KR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_pt_BR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_CN.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_TW.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyTesting.jar:/expor
        OS name: SunOS
        OS architecture: x86
        OS version: 5.10
        Java user name: ak136785
        Java user home: /home/ak136785
        Java user dir: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jdbc40_client
        java.specification.name: Java Platform API Specification
        java.specification.version: 1.6
        --------- Derby Information --------
        JRE - JDBC: Java SE 6 - JDBC 4.0
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbytools.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbynet.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyclient.jar] 10.3.0.0 alpha - (438476:438489M)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc.jar] 2.4 - (17)
        [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc_license_c.jar] 2.4 - (17)
        ------------------------------------------------------
        ----------------- Locale Information -----------------
        Current Locale : [English/United States [en_US]]
        Found support for locale: [de_DE]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [es]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [fr]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [it]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [ja_JP]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [ko_KR]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [pt_BR]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [zh_CN]
        version: 10.3.0.0 alpha - (438476:438489M)
        Found support for locale: [zh_TW]
        version: 10.3.0.0 alpha - (438476:438489M)
        ------------------------------------------------------
        Framework: DerbyNetClient
        Test environment information:
        COMMAND LINE STYLE: jdk13
        TEST CANONS: master
        ------------------------------------------------------
        ------------------------------------------------------
        Summary results:

        Test Run Started: 2006-09-04 14:08:19.0
        Test Run Duration: 00:01:28

        8 Tests Run
        87% Pass (7 tests passed)
        13% Fail (1 tests failed)
        0 Suites skipped
        ------------------------------------------------------
        Failed tests in: jdbc40_fail.txt
        ------------------------------------------------------
        Passed tests in: jdbc40_pass.txt
        ------------------------------------------------------
        System properties in: jdbc40_prop.txt
        ------------------------------------------------------
        ------------------------------------------------------
        Failure Details:

                        • Diff file jdbc40/DerbyNetClient/jdbc40/TestDbMetaData.diff
            • Start: TestDbMetaData jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:30 ***
              Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbc4/TestDbMetaData.java
            • End: TestDbMetaData jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:30 ***
                        • Diff file jdbc40/DerbyNetClient/jdbc40/_Suite.diff
            • Start: _Suite jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:09:28 ***
              0 add
              > > .......F.F.F.F.F.F.F.F.....F.F.F.F...................
              > > ............................F..F.F.F.........
              > > ......F.F.F.F.F.F.F.F.....F.F.F.F....................
              > > There were 28 failures:
              > > 1) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 2) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 3) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 4) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 5) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 6) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 7) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 8) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 9) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 10) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 11) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 12) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 13) testTypesNCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-15> but was:<-8>
              > > 14) testTypesLONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-16> but was:<-10>
              > > 15) testTypesNCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<2011> but was:<2007>
              > > 16) testTypesROWID(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-8> but was:<2008>
              > > 17) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 18) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 19) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 20) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 21) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 22) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 23) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 24) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 25) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 26) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 27) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > 28) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown.
              > > FAILURES!!!
              > > Tests run: 2048, Failures: 28, Errors: 0
              Test Failed.
            • End: _Suite jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:09:47 ***
                        • Diff file jdbc40/DerbyNetClient/jdbc40/TestJDBC40Exception.diff
            • Start: TestJDBC40Exception jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:31 ***
              Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbc4/TestJDBC40Exception.java
            • End: TestJDBC40Exception jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:31 ***
        Show
        Andreas Korneliussen added a comment - Tests shows that the failure has been fixed. Derbyall passes. Running the jdbc40 suite, fails with more or less the same erros on client and embedded, indicating that those failures are not related to this fix, or DERBY-1559 . JDBC40_EMBEDDED: Generating report for RunSuite jdbc40 null null null true ------------------ Java Information ------------------ Java Version: 1.6.0-rc Java Vendor: Sun Microsystems Inc. Java home: /usr/local/java/jdk1.6.0_b98/jre Java classpath: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_de_DE.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_es.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_fr.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_it.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ja_JP.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ko_KR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_pt_BR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_CN.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_TW.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyTesting.jar:/expor OS name: SunOS OS architecture: x86 OS version: 5.10 Java user name: ak136785 Java user home: /home/ak136785 Java user dir: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jdbc40_embedded java.specification.name: Java Platform API Specification java.specification.version: 1.6 --------- Derby Information -------- JRE - JDBC: Java SE 6 - JDBC 4.0 [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbytools.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbynet.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyclient.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc.jar] 2.4 - (17) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc_license_c.jar] 2.4 - (17) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US] ] Found support for locale: [de_DE] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [es] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [fr] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [it] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [ja_JP] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [ko_KR] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [pt_BR] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [zh_CN] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [zh_TW] version: 10.3.0.0 alpha - (438476:438489M) ------------------------------------------------------ Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2006-09-04 14:05:59.0 Test Run Duration: 00:02:19 10 Tests Run 90% Pass (9 tests passed) 10% Fail (1 tests failed) 0 Suites skipped ------------------------------------------------------ Failed tests in: jdbc40_fail.txt ------------------------------------------------------ Passed tests in: jdbc40_pass.txt ------------------------------------------------------ System properties in: jdbc40_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: Diff file jdbc40/jdbc40/_Suite.diff Start: _Suite jdk1.6.0-rc jdbc40:jdbc40 2006-09-04 14:08:02 *** 0 add > > .......E.E.E.E.E.E.E.E.....E.E.E.E................... > > ..............................F..F.F.F....... > > ........E.E.E.E.E.E.E.E.....E.E.E.E.................. > > There were 24 errors: > > 1) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 33 more > > 2) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 32 more > > 3) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 31 more > > 4) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 32 more > > 5) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 33 more > > 6) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 32 more > > 7) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 31 more > > 8) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 32 more > > 9) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 33 more > > 10) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 32 more > > 11) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 31 more > > 12) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 32 more > > 13) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 37 more > > 14) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 36 more > > 15) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 35 more > > 16) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-15'. > > ... 36 more > > 17) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 37 more > > 18) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 36 more > > 19) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 35 more > > 20) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '2011'. > > ... 36 more > > 21) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 37 more > > 22) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 36 more > > 23) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 35 more > > 24) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '-16'. > > ... 36 more > > There were 4 failures: > > 1) testTypesNCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-15> but was:<-8> > > 2) testTypesLONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-16> but was:<-10> > > 3) testTypesNCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<2011> but was:<2007> > > 4) testTypesROWID(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-8> but was:<2008> > > FAILURES!!! > > Tests run: 2053, Failures: 4, Errors: 24 Test Failed. End: _Suite jdk1.6.0-rc jdbc40:jdbc40 2006-09-04 14:08:18 *** ------------------------------------------------------ JDBC40_CLIENT: Generating report for RunSuite jdbc40 null null DerbyNetClient true ------------------ Java Information ------------------ Java Version: 1.6.0-rc Java Vendor: Sun Microsystems Inc. Java home: /usr/local/java/jdk1.6.0_b98/jre Java classpath: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_de_DE.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_es.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_fr.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_it.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ja_JP.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_ko_KR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_pt_BR.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_CN.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_zh_TW.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyTesting.jar:/expor OS name: SunOS OS architecture: x86 OS version: 5.10 Java user name: ak136785 Java user home: /home/ak136785 Java user dir: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jdbc40_client java.specification.name: Java Platform API Specification java.specification.version: 1.6 --------- Derby Information -------- JRE - JDBC: Java SE 6 - JDBC 4.0 [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbytools.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbynet.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyclient.jar] 10.3.0.0 alpha - (438476:438489M) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc.jar] 2.4 - (17) [/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/jcc/db2jcc_license_c.jar] 2.4 - (17) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US] ] Found support for locale: [de_DE] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [es] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [fr] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [it] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [ja_JP] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [ko_KR] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [pt_BR] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [zh_CN] version: 10.3.0.0 alpha - (438476:438489M) Found support for locale: [zh_TW] version: 10.3.0.0 alpha - (438476:438489M) ------------------------------------------------------ Framework: DerbyNetClient Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2006-09-04 14:08:19.0 Test Run Duration: 00:01:28 8 Tests Run 87% Pass (7 tests passed) 13% Fail (1 tests failed) 0 Suites skipped ------------------------------------------------------ Failed tests in: jdbc40_fail.txt ------------------------------------------------------ Passed tests in: jdbc40_pass.txt ------------------------------------------------------ System properties in: jdbc40_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: Diff file jdbc40/DerbyNetClient/jdbc40/TestDbMetaData.diff Start: TestDbMetaData jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:30 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbc4/TestDbMetaData.java End: TestDbMetaData jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:30 *** Diff file jdbc40/DerbyNetClient/jdbc40/_Suite.diff Start: _Suite jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:09:28 *** 0 add > > .......F.F.F.F.F.F.F.F.....F.F.F.F................... > > ............................F..F.F.F......... > > ......F.F.F.F.F.F.F.F.....F.F.F.F.................... > > There were 28 failures: > > 1) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 2) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 3) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 4) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 5) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 6) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 7) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 8) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 9) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 10) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 11) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 12) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 13) testTypesNCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-15> but was:<-8> > > 14) testTypesLONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-16> but was:<-10> > > 15) testTypesNCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<2011> but was:<2007> > > 16) testTypesROWID(org.apache.derbyTesting.functionTests.tests.jdbc4.JDBC40TranslationTest)junit.framework.AssertionFailedError: expected:<-8> but was:<2008> > > 17) testUnsupportedSetObject_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 18) testUnsupportedSetObjectWithScale_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 19) testUnsupportedSetNull_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 20) testUnsupportedSetNullWithTypeName_NCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 21) testUnsupportedSetObject_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 22) testUnsupportedSetObjectWithScale_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 23) testUnsupportedSetNull_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 24) testUnsupportedSetNullWithTypeName_NCLOB(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 25) testUnsupportedSetObject_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 26) testUnsupportedSetObjectWithScale_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 27) testUnsupportedSetNull_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > 28) testUnsupportedSetNullWithTypeName_LONGNVARCHAR(org.apache.derbyTesting.functionTests.tests.jdbc4.SetObjectUnsupportedTest)junit.framework.AssertionFailedError: No exception thrown. > > FAILURES!!! > > Tests run: 2048, Failures: 28, Errors: 0 Test Failed. End: _Suite jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:09:47 *** Diff file jdbc40/DerbyNetClient/jdbc40/TestJDBC40Exception.diff Start: TestJDBC40Exception jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:31 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbc4/TestJDBC40Exception.java End: TestJDBC40Exception jdk1.6.0-rc DerbyNetClient jdbc40:jdbc40 2006-09-04 14:08:31 ***
        Hide
        Andreas Korneliussen added a comment -

        Committed revision 440062.

        Show
        Andreas Korneliussen added a comment - Committed revision 440062.

          People

          • Assignee:
            Andreas Korneliussen
            Reporter:
            Ole Solberg
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development