Description:

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

Tags:

dbcp, jdbc, database, connection, pooling, store

Properties:

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 nifi.properties 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.