Provides Database Connection Pooling Service. Connections can be asked from pool and returned after usage.


dbcp, jdbc, database, connection, pooling, store


In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property is considered “sensitive”, meaning that its value will be encrypted. Before entering a value in a sensitive property, ensure that the file has an entry for the property nifi.sensitive.props.key.

Name Default Value Allowable Values Description
Database Connection URL A database connection URL used to connect to a database. May contain database system name, host, port, database name and some parameters. The exact syntax of a database connection URL is specified by your DBMS.
Database Driver Class Name Database driver class name
Database Driver Jar Url Optional database driver jar file path url. For example 'file:///var/tmp/mariadb-java-client-1.1.7.jar'
Database User Database user name
Password The password for the database user
Sensitive Property: true
Max Wait Time 500 millis The maximum amount of time that the pool will wait (when there are no available connections) for a connection to be returned before failing, or -1 to wait indefinitely.
Max Total Connections 8 The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.