Nifi DBCPC URL automatic refresh

[#1]

Hi team,

I got a challenge.

I set up DBCPC URL by  variable value, and when server change and with the same name,it did not point to the right node when have db failover instance,

For example, when I run executeSQL, before DB failover, it would query from A server, after DB failover, it should switch from A to B, but it did not update the connection, still query from A node.

Would like to know should I config what kind of paremeter to force the connections updated?

Btw, in the meanwhile, there are other processor groups continue using the service to query from DB.

Here is my configurateion so far,

Max Wait Time=default(500 millis)

Max Total Connections=8

Validation query=select 1 from Dual;

Minimum Idle Connections=0

Max Idle Connections=0

Max Connection Lifetime=2mins

Time Between Eviction Runs= default -1

Minimum Evictable Idle Time= default 30 mins

Soft Minimum Evictable Idle Time=default -1

Thanks in advance

[#2]

@Jne Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our NiFi experts @MattWho @cotopaul  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.