question Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup in Support Questions

The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Paul Yang — Tue, 21 Apr 2026 11:35:11 GMT

Hello,

I am working with 3 nodes CFM cluster. the version of CFM is 1.0.1.

The below pic shows the steps:

the below pic is config of ExecuteSQL:

the below pic is lookup service:

the below is the config of dbcpconnetionpool:

The behavior is the ExcuteSQL processor will execute very slowly seem hanged. but sometime execute very fast. I believe that is database issue. So my questions is:

1. what is the impact? is dbcp connections pool issue of config? or is the dbcp connections pool lookup wrong behavior?

2. I'm afraid the impact of this will be magnified. when increased database connection pool to 500+.

Could help me to answer my questions?

Thanks

Paul

Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Paul Yang — Wed, 13 Nov 2019 00:16:58 GMT

I'm sorry. Correct the above description.

The behavior is the ExcuteSQL processor will execute very slowly seem hanged. but sometime execute very fast. I believe that is not database issue.

So my questions is:

1. what is the impact? is dbcp connections pool issue of config? or is the dbcp connections pool lookup wrong behavior?

2. I'm afraid the impact of this will be magnified when we face to increased database connection pool config to 500+. Is that the right thing to worry about?

Could help me to answer my questions?

Thanks Paul

Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Paul Yang — Mon, 16 Dec 2019 03:05:53 GMT

Oh, it is network connection issue. it gone away when i add oracle.jdbc.ReadTimeout=120000 and oracle.net.CONNECT_TIMEOUT=10000 to config of DBCPConnectionPool.