[NIFI-11653] Add Connection URL Validation for DB Connection Pool Services

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.0.0-M1, 1.22.0
• Component/s: Extensions
• Assignee: David Handermann
• Reporter: David Handermann
• Created: 06/Jun/23 14:40
• Updated: 06/Jun/23 16:50
• Resolved: 06/Jun/23 16:50

Description

The DBCPConnectionPool and HikariCPConnectionPool Controller Services support configurable access to databases using JDBC. Properties such as the Connection URL support a wide variety of options and the existing property validation allows any string. A custom property validator should be implemented to provide better scoping for supported use cases. This includes disallowing connections to file-backed database such as H2.

Issue Links

• links to: GitHub Pull Request #7349