[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14313781#comment-14313781 ] Sergey Zolotaryov commented on DERBY-6793: -- I did not look deeper into the problem myself, yesterday I just made the project build in Eclipse correctly (you guys have really odd project structure, perhaps it's legacy, I understand). I'll investigate how we could better handle the binaries. 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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14312741#comment-14312741 ] Mike Matrigali commented on DERBY-6793: --- user reports issue resulted from changes for DERBY-5489 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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14313029#comment-14313029 ] Myrna van Lunteren commented on DERBY-6793: --- Kristian worked on DERBY-5489, and it was noted in the release note that this change would possibly cause incompatibility for applications retrieving the same blob twice. It seems this is documented incompatibility resulting from a necessary fix (the alternative was incorrect data retrieval). Perhaps Kristian can add more details. Or perhaps you have suggestions for a better approach... 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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14311457#comment-14311457 ] Sergey Zolotaryov commented on DERBY-6793: -- Thanks guys, I'll try to reproduce it in a clean room :) 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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14310908#comment-14310908 ] Rick Hillegas commented on DERBY-6793: -- Hi Sergey, You will raise the likelihood that this issue will be investigated if you can attach a repro which just involves Derby code without the Spring classes. Hope this helps, -Rick 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)
[jira] [Commented] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
[ https://issues.apache.org/jira/browse/DERBY-6793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14310928#comment-14310928 ] Bryan Pendleton commented on DERBY-6793: Perhaps you can run your reproduction with -Dderby.language.logStatementText=true, and post the derby.log? 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)