Supports Expression Language: trueDatabase Driver Class Name | | | Database driver class name Supports Expression Language: true |
Database Driver Location(s) | | | Comma-separated list of files/folders and/or URLs containing the driver JAR and its dependencies (if any). For example '/var/tmp/mariadb-java-client-1.1.7.jar' Supports Expression Language: true |
Database User | | | Database user name Supports Expression Language: true |
Password | | | The password for the database user Sensitive Property: true Supports Expression Language: 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. |
Validation query | | | Validation query used to validate connections before returning them. When connection is invalid, it get's dropped and new valid connection will be returned. Note!! Using validation might have some performance penalty. Supports Expression Language: true |
Dynamic Properties:
Dynamic Properties allow the user to specify both the name and value of a property.
Name | Value | Description |
---|
JDBC property name | JDBC property value | Specifies a property name and value to be set on the JDBC connection(s). If Expression Language is used, evaluation will be performed upon the controller service being enabled. Note that no flow file input (attributes, e.g.) is available for use in Expression Language constructs for these properties. Supports Expression Language: true |
State management:
This component does not store state.Restricted:
This component is not restricted.