[NIFI-3426] Add ability to set JDBC properties via dynamic properties in DBCPConnectionPool

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 01/Feb/17 14:43
• Updated: 23/Feb/17 20:29
• Resolved: 04/Feb/17 19:39

Description

Although many JDBC drivers allow for the setting of connection-specific properties via the JDBC URL, some JDBC drivers only accept specific configuration properties for a connection via programmatic calls to add properties to the Connection object; those same properties will not be parsed from the URL.

In general, a proposed improvement is to add support for Dynamic Properties to the DBCPConnectionPool controller service. Each dynamic property would be set as a property on the DataSource when the controller service is enabled. Note that Expression Language can be supported, but as no flow file will be available at enable-time, flow file attributes cannot be used in EL expressions. However the Variable Registry could be leveraged to provide different values in different environments (dev, test, production, e.g.).

Issue Links

• links to: GitHub Pull Request #1461