[NIFI-13103] Enhance AutoCommit property to allow no value set in PutDatabaseRecord

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.26.0, 2.0.0-M3
• Component/s: Extensions
• Assignee: Jim Steinebrey
• Reporter: Jim Steinebrey
• Created: 26/Apr/24 14:18
• Updated: 18/Jun/24 16:59
• Resolved: 01/May/24 21:13

Description

Enhance AutoCommit property to allow value of "No value set" in PutDatabaseRecord to be consistent with PutSQL processor. No value set (null) leaves the database connection's autoCommit mode unmodified. 

Issue Links

• is duplicated by: NIFI-13124 PutDatabaseRecord: when AUTO_COMMIT property equals "No value set", an NPE occurs
• is duplicated by: NIFI-12217 In PutDatabaseRecord processor, when you try to insert a CLOB and a SQLException gets catched, the exception message gets lost
• links to: GitHub Pull Request #8723
• links to: GitHub Pull Request #8937