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)
