[NIFI-5790] DBCPConnectionPool configuration should expose underlying connection idle and eviction configuration

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.9.0
• Component/s: Extensions
• Labels: DBCP database
• Assignee: Colin Dean
• Reporter: Colin Dean
• Created: 05/Nov/18 17:27
• Updated: 17/Dec/19 03:49
• Resolved: 12/Nov/18 18:42

Description

While investigating a fix for NIFI-5789, I noticed in the DBCPConnectionPool documentation that NiFi appears not to have controller service configuration options associated with Apache Commons-DBCP BasicDataSource parameters like minIdle and maxIdle, which I think should be both set to 0 in my particular use case.

Alternatively, I think I could set maxConnLifetimeMillis to something even in the minutes range and satisfy my use case (a connection need not be released immediately but within a reasonable period of time), but this option is also not available.

Issue Links

• causes: NIFI-5789 DBCPConnectionPool controller service always leaves one connection open
• links to: GitHub Pull Request #3133
• links to: GitHub Pull Request #3133
• links to: GitHub Pull Request #3260