Hi, The purpose of the DBCPConnectionPool is to manage a pool of reusable database connections and avoiding establishing new connections for each database request. Because they share the same connection, Flow File scoped dynamic URL evaluation is not supported. For dynamic use of connection pools you may want to look into DBCPConnectionPoolLookup<https://nifi.apache.org/documentation/nifi-2.0.0-M3/components/org.apache.nifi/nifi-dbcp-service-nar/2.0.0-M3/org.apache.nifi.dbcp.DBCPConnectionPoolLookup/index.html>.
Kind Regards, Lehel ________________________________ From: Mark Moore <[email protected]> Sent: Monday, July 8, 2024 11:36 To: [email protected] <[email protected]> Subject: DBCPConnectionPool 2.0.0-M3 Database Connection URL field says EL is supported Hi, We are trying to create a DBCPConnectionPool service for a dynamic connection to different end pts and databases using flow attributes that are correctly evaluated elsewhere but in this field these attributes do not seem to get evaluated correctly. Database Connection URL : jdbc:postgresql://${endpt}:5432/${db} errors out saying connection to localhost:5432 is refused. Thanks Mark Moore Software Developer – BI & Analytics Time: GMT -6:00 [email protected]<mailto:[email protected]> [A black background with green text Description automatically generated]
