[DERBY-6318] Simplify setting of possibly null parameters in XPLAIN descriptors

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.11.1.1
• Component/s: SQL
• Urgency: Low
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 28/Aug/13 10:52
• Updated: 29/Aug/13 08:02
• Resolved: 29/Aug/13 08:02

Description

I noticed that the various XPLAIN descriptor classes need to set lots of numeric parameters on a PreparedStatement, using the following idiom to allow null values:

if (parse_time != null)
ps.setLong(2, parse_time.longValue());
else
ps.setNull(2, Types.BIGINT);

The same thing could have been achieved by using a single call to setObject(), like this:

ps.setObject(2, parse_time, Types.BIGINT);

This would make the methods shorter and clearer.