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 "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/01/31 15:27:35 UTC

[jira] Commented: (DERBY-880) jdbcapi/connectionJdbc20.java fails for server (10.1.2.2) and client (10.2.0.0) compatibility testing with > SQLSTATE(null): java.sql.SQLException: Stream of column value in result cannot be retrieved twice

    [ http://issues.apache.org/jira/browse/DERBY-880?page=comments#action_12364615 ] 

Daniel John Debrunner commented on DERBY-880:
---------------------------------------------

I don't think this is a regression. Yes, previously you could call getXXXStream() in embedded twice on the column to read the stream twice, but the second read returned the wrong results. Look at the comments et c. in DERBY-721.

The change was  discussed on the list, the JDBC spec says portable code should only read a column once.

So now we have getXXXStream(0 calls which can only be called once, and thus always return the correct results.

Any applications depending on the old behaviour are returning the worng results ot their users.

> jdbcapi/connectionJdbc20.java  fails for server (10.1.2.2) and client (10.2.0.0) compatibility testing with > SQLSTATE(null): java.sql.SQLException: Stream of column value in result cannot be retrieved twice
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-880
>          URL: http://issues.apache.org/jira/browse/DERBY-880
>      Project: Derby
>         Type: Bug
>   Components: Regression Test Failure, Network Client
>     Versions: 10.2.0.0
>  Environment: OS: Windows 2000, Server: 10.1.2.2 (372412), Client: 10.2.0.0(37212), Testing: 10.1.2.2 (372412), jvm: sun jdk15
>     Reporter: Ramandeep Kaur
>     Priority: Critical
>      Fix For: 10.2.0.0
>  Attachments: connectionJdbc20.diff, connectionJdbc20.tmp, connectionJdbc20.tmpmstr
>
> Ran derby suite "derbynetclientmats" with Server: 10.1.2.2 (372412), Client: 10.2.0.0(37212), Testing: 10.1.2.2 (372412), jvm: sun jdk15 as following:
> 1. Create directories for  10.1.2.2 jar files (all jar files except derbyclient.jar) and 10.2.0.0 jars files (only derbyClient.jar).
>  2. Set CLASSPATh to the jars in the above directories.
>  3. Run suite derbynetclientmats by giving the following command:-
>  java org.apache.derbyTesting.functionTests.harness.RunSuite derbynetclientmats
> Test case jdbcapi/connectionJdbc20.java failed with following exception:-
> > FAIL -- unexpected exception
> > SQLSTATE(null): java.sql.SQLException: Stream of column value in result cannot be retrieved twice
> > java.sql.SQLException: Stream of column value in result cannot be retrieved twice
> Test Failed.
> Attaching diff, tmp, and tmpstr.

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