[jira] [Commented] (DERBY-5696) Documentation on LOBs needs some fixes

["Kim Haase (JIRA)" <ji...@apache.org>]

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

Kim Haase commented on DERBY-5696:
----------------------------------

I'm trying to figure out how to document the behavior noted in DERBY-5489, but I'm a little confused. I was going to say something like

"If you call one of the ResultSet methods getBytes, getString, or getObject on a LOB after a different getter has already been invoked, an error occurs."

However, that seems to apply to items a, b, d, and e below, but not to c. Why is it okay to call getObject after getBytes, but not the other way around?

 a) OK: getBytes - getBytes
 b) FAILS: getObject - getBytes
 c) OK: getBytes - getObject
 d) FAILS: getBytes - getObject - getBytes
 e) FAILS: getBlob - getBinaryStream

Thanks for any advice.
                
> Documentation on LOBs needs some fixes
> --------------------------------------
>
>                 Key: DERBY-5696
>                 URL: https://issues.apache.org/jira/browse/DERBY-5696
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>
> DERBY-5489 points out some issues with multiple getXXX calls on LOBs that are not fully documented. The information should probably be added to "Notes on mapping of java.sql.Blob and java.sql.Clob interfaces". In addition, the topic "Mapping of java.sql.Blob and java.sql.Clob interfaces" has a typo and could probably use some additional information as well.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira