[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] [Comment Edited] (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 edited comment on DERBY-6793 at 2/10/15 8:09 AM: --- 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. To me a fix that just limits functionality is a recognition of insolvency, no offence. was (Author: anydoby): 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=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] [Updated] (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:all-tabpanel ] Sergey Zolotaryov updated DERBY-6793: - Attachment: derby-bug.tar.gz Here's a simpler example 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] [Updated] (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:all-tabpanel ] Sergey Zolotaryov updated DERBY-6793: - Attachment: (was: derby-bug.tar.gz) 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] [Updated] (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:all-tabpanel ] Sergey Zolotaryov updated DERBY-6793: - Description: 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. was: Since migrating from derby 10.7.1.1 to 10.11.1.1 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. 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] [Created] (DERBY-6793) Stream or LOG value cannot be retrieved more than once
Sergey Zolotaryov created DERBY-6793: Summary: 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 Since migrating from derby 10.7.1.1 to 10.11.1.1 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] [Updated] (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:all-tabpanel ] Sergey Zolotaryov updated DERBY-6793: - Attachment: derby-bug.tar.gz Run with mvn clean test -Dtest=Reproduce 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 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)