[DERBY-1938] Add support for setObject(<arg>, null)

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.7.1.1
• Component/s: JDBC
• Assignee: Kristian Waagan
• Reporter: Dag H. Wanvik
• Created: 05/Oct/06 22:38
• Updated: 13/Jan/11 17:31
• Resolved: 08/Sep/10 15:27

Description

Derby presently does not implement support for the method
PreparedStatement.setObject (and similarly for CallableStatement.setObject)
when the supplied value is null, unless a type argument (3rd arg) is also present.
That is, in:
void setObject(int parameterIndex,
Object x)
throws SQLException
x can not be null.

Derby will presently throw an SQLException (client: XJ021, embedded: 22005)
if x is null when calling this method on a preparedStatement.

Porting some applications may be made easier if this restriction is lifted.
See also discussion in DERBY-1904.

Issue Links

• is related to: DERBY-1904 COALESCE with NULL parameter problem
• relates to: DERBY-1610 Resolve difference of type compatibility between Embedded and NetworkServer/NetworkDriver