Matt Burgess created NIFI-3426: ---------------------------------- Summary: Add ability to set JDBC properties via dynamic properties in DBCPConnectionPool Key: NIFI-3426 URL: https://issues.apache.org/jira/browse/NIFI-3426 Project: Apache NiFi Issue Type: Improvement Reporter: Matt Burgess Assignee: Matt Burgess Priority: Minor
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.). -- This message was sent by Atlassian JIRA (v6.3.15#6346)