Skip to main content
0tto
Silver ⭐️⭐️
February 12, 2025
Question

Error when using ExecuteSQL processor to DBCPConnectionPool

Hi everyone,

I would like to ask for technical support in Apache NiFi 2.2.0. In my project, I want to integrate Apache NiFi 2.2.0 to Postgres, which is my data source using DBCPConnectionPool. I use ExecuteSQL processor to interact with PostgreSQL, but I encounter the following error when verifying.

Screenshot from 2025-02-12 10-34-34.png

Some solutions suggest me to check if DBCPConnectionPool is enabled or not. I go to check, it is already enabled.

Screenshot from 2025-02-12 10-20-10.png

 

Please help me.

Thank you in advance.

2 replies

VidyaSargur
Community Manager
Community Manager
February 12, 2025

@0tto Welcome to our community! To get customer support help, you must have a Cloudera subscription. However, to help you get the best possible answer, I have tagged our NiFi experts @MattWho @Shelton @SAMSAL  who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
Shelton
Gold ⭐️⭐️⭐️
February 12, 2025

@0tto 
Please could you share your NiFi logs.
Happy hadooping

Translate