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

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Component/s: JDBC
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 31/Mar/08 12:27
• Updated: 25/Jul/08 17:12
• Resolved: 08/Apr/08 18:28

Description

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.

Issue Links

• is related to: DERBY-2892 Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks