You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ole Solberg (JIRA)" <de...@db.apache.org> on 2006/09/01 13:58:25 UTC

[jira] Created: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

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

                 Key: DERBY-1800
                 URL: http://issues.apache.org/jira/browse/DERBY-1800
             Project: Derby
          Issue Type: Bug
          Components: Regression Test Failure
    Affects Versions: 10.3.0.0
         Environment: All
            Reporter: Ole Solberg
            Priority: Minor


Has failed since 438528, changes:  https://clustra.norway.sun.com/~os136789/DBTG_QA_Derby/Daily/jvm1.6/testing/UpdateInfo/438528.txt

*** 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 ***


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Closed: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren closed DERBY-1800.
-------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.2.2.0

> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: https://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server, Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>             Fix For: 10.3.0.0, 10.2.2.0
>
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

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


[jira] Updated: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1800?page=all ]

Andreas Korneliussen updated DERBY-1800:
----------------------------------------

    Component/s: Network Server

> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure, Network Server
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Reopened: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren reopened DERBY-1800:
---------------------------------------


> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: https://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server, Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>             Fix For: 10.2.2.0, 10.3.0.0
>
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

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


[jira] Resolved: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1800?page=all ]

Andreas Korneliussen resolved DERBY-1800.
-----------------------------------------

    Fix Version/s: 10.3.0.0
       Resolution: Fixed

Committed revision 440062.


> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure, Network Server
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Assigned: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1800?page=all ]

Andreas Korneliussen reassigned DERBY-1800:
-------------------------------------------

    Assignee: Andreas Korneliussen

> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Closed: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg closed DERBY-1800.
------------------------------


> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: https://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server, Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

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


[jira] Commented: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-1800?page=comments#action_12432140 ] 
            
Andreas Korneliussen commented on DERBY-1800:
---------------------------------------------

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

> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-1800?page=comments#action_12432508 ] 
            
Andreas Korneliussen commented on DERBY-1800:
---------------------------------------------

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.ja
 r:/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.ja
 r:/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 ***

> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Andreas Korneliussen (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1800?page=all ]

Andreas Korneliussen updated DERBY-1800:
----------------------------------------

    Attachment: DERBY-1800.diff

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.


> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>         Assigned To: Andreas Korneliussen
>            Priority: Minor
>         Attachments: DERBY-1800.diff
>
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Kristian Waagan (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-1800?page=comments#action_12432130 ] 
            
Kristian Waagan commented on DERBY-1800:
----------------------------------------

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


> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>            Priority: Minor
>
> Has failed since 438528, changes:  https://clustra.norway.sun.com/~os136789/DBTG_QA_Derby/Daily/jvm1.6/testing/UpdateInfo/438528.txt
> *** 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

Posted by "Ole Solberg (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1800?page=all ]

Ole Solberg updated DERBY-1800:
-------------------------------

    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 ***


  was:
Has failed since 438528, changes:  https://clustra.norway.sun.com/~os136789/DBTG_QA_Derby/Daily/jvm1.6/testing/UpdateInfo/438528.txt

*** 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 ***



> testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1800
>                 URL: http://issues.apache.org/jira/browse/DERBY-1800
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.3.0.0
>         Environment: All
>            Reporter: Ole Solberg
>            Priority: Minor
>
> 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 ***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira