[ 
https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14311505#comment-14311505
 ] 

Sergey Zolotaryov commented on DERBY-6793:
------------------------------------------

The problem appeared after revision 1330681 in 
org.apache.derby.impl.jdbc.EmbedResultSet (DERBY-5489: getBinary() returns 
incorrect data after getObject() call on BLOB column), lines 679-686.
I don't think it is the right fix to apply - restrict user from multiple calls 
to getObject(int) if it is BLOB or CLOB. I've never seen this in other dbs, 
well in Derby also :) Maybe we could think on how to gracefully handle this?

> Stream or LOG value cannot be retrieved more than once
> ------------------------------------------------------
>
>                 Key: DERBY-6793
>                 URL: https://issues.apache.org/jira/browse/DERBY-6793
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.11.1.1
>         Environment: does not matter
>            Reporter: Sergey Zolotaryov
>         Attachments: derby-bug.tar.gz
>
>
> Since migrating from derby 10.7.1.1 to 10.11.1.1 really innocent code stopped 
> working: retrieving resultset column data using column names if resultset 
> contains blobs stopped working.
> I am attaching a maven project with a unit test which proves the issue. If in 
> pom.xml you change the version to 10.7.1.1 the test will pass. We are using 
> spring-jdbc' queryForMap() which traverses resultset metadata and queries 
> attributes by their column labels. Used to work before.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to