[DERBY-4754] SQLClob.getObject() should always return a java.sql.Clob

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.7.1.1
• Component/s: JDBC, SQL
• Labels: derby_triage10_8
• Urgency: Normal
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 23/Jul/10 16:09
• Updated: 15/Feb/12 23:09
• Resolved: 15/Feb/12 23:09

Description

Depending on what SQLClob wraps (a string, a stream, a java.sql.Clob), SQLClob.getObject() sometimes returns a string and other times returns a java.sql.Clob. In at least one spot, the compiler expects that SQLClob.getObject() will always return a java.sql.Clob. See the final cast compiled by SQLToJavaValueNode.generateJavaValue(). I believe that the compiler is correct and SQLClob.getObject() should behave predictably.

Issue Links

• blocks: DERBY-4066 Allow functions/procedures to take Blob/Clob arguments
• relates to: DERBY-4544 Referencing streaming CLOBs in (some) generated column clauses fails