Derby should throw a better error message if a BLOB/CLOB column is accessed 
more than once
------------------------------------------------------------------------------------------

                 Key: DERBY-3583
                 URL: https://issues.apache.org/jira/browse/DERBY-3583
             Project: Derby
          Issue Type: Improvement
            Reporter: Kathey Marsden
            Priority: Minor


With the DERBY-2892 fix  revision 642974, users can no longer access a 
BLOB/CLOB column more than once for each row.  Currently the error message is
XJ217 - You cannot invoke other java.sql.Clob/java.sql.Blob methods after 
calling the free() method or after the Blob/Clob's transaction has been 
committed or rolled back.

I don't know that that makes sense given the user called getString()

For getCharacterStream()/getBinaryStream() there is no error on the call, just 
an IOException on the read.

We should throw a clearer error message, that the user is not allowed to make 
multiple getXXX calls on a BLOB/CLOB column for each row.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to