nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Burgess (JIRA)" <j...@apache.org>
Subject [jira] [Created] (NIFI-3426) Add ability to set JDBC properties via dynamic properties in DBCPConnectionPool
Date Wed, 01 Feb 2017 14:43:51 GMT
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)

Mime
View raw message