[NIFI-7208] PutSQL doesn't handle nanoseconds

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0, 1.11.4
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 26/Feb/20 22:58
• Updated: 13/Mar/20 19:00
• Resolved: 13/Mar/20 19:00

Description

According to the documentation PutSQL should be able to manage nanoseconds:

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.9.0/org.apache.nifi.processors.standard.PutSQL/

".]sql.args.N.format [...] as specified according to java.time.format.DateTimeFormatter"

DateTimeFormatter should be able to manage nanoseconds.

The issue seems to be happening in JdbcCommon.java

Line 840-843:
final DateTimeFormatter dtFormatter = getDateTimeFormatter(valueFormat);
TemporalAccessor accessor = dtFormatter.parse(parameterValue);
java.util.Date parsedDate = java.util.Date.from(Instant.from(accessor));
lTimestamp = parsedDate.getTime();

It seems to be truncated on line 842
java.util.Date parsedDate = java.util.Date.from(Instant.from(accessor));

as java.util.Date doesn't handle nanoseconds. A Java time construct that can handle nanoseconds should be used instead of Date.

Issue Links

• links to: GitHub Pull Request #4094
• links to: GitHub Pull Request #4143