question Re: Error when using ExecuteSQL processor to DBCPConnectionPool in Support Questions

Error when using ExecuteSQL processor to DBCPConnectionPool

0tto — Wed, 12 Feb 2025 03:36:02 GMT

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.

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

Please help me.

Thank you in advance.

Re: Error when using ExecuteSQL processor to DBCPConnectionPool

VidyaSargur — Wed, 12 Feb 2025 09:19:13 GMT

@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.

Re: Error when using ExecuteSQL processor to DBCPConnectionPool

Shelton — Wed, 12 Feb 2025 09:42:26 GMT

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