Hi
I'm running
- Apache Nifi 2.3.0
- MS SQL EXPRESS
- JDBC Driver mssql-jdbc-12.8.1.jre11.jar
I've configured Controller Service (DBCPConnectionPool 2.3.0). It was successfully enabled.
Problem: When I try to configure any processor that uses DBCP, I don't see the connection pool.
I tried different connection pools but facing the same issue. No sure what is causing this.
Appreciate any help
@BuffaloDaddy
You are creating your DBCP Controller service in the wrong location.
I see from your attached image you have created your DBCP Controller service from the NiFi Global menu --> Controller Settings --> Management Controller Services. Controller Services create here are for use by Reporting tasks that are also created through this same Controller Settings UI.
Controller Service you want accessible to processors on the NiFi canvas must be created on the process group. Child process group(s) will be able to see the controller services of parent process groups unless explicit policy is applied to child Process Group preventing this inheritance.
When NiFi is started for the first time, NiFi will create the root Process Group for you (Default Root PG name is " NiFi Flow"). This is the canvas you see when you access the NiFi. You can access "Controller Services" by right clicking on any unoccupied space on the canvas to bring up a context menu:
From this context menu select "Controller Services". From there you can add controller service to that process group which your processors can use.
Please help our community grow and thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.
Thank you,
Matt
