Maximum Pool Size parameter in JDBC connection

Hi,

Is there any way to determine the maximum number of pool size has been reached for a JDBC adapter connection while executing the scheduled flow services?

Thanks and Regards,
Shriraksha A N

Well, if you will monitor server logs you will see messages like “no resources available to run this schedule task” … same will be updated in last run status of scheduled task.

Hi Shriraksha,

We can generally get the statistics of a JDBC adapters using the service
WMART\pub.art.connection:getConnectionStatistics and provide the input value as adapter service which do you want to monitor it. you can implement the logic for getting notification before reaches to maximum pool. if I am wrong can you suggest me

Regards,
Jeevan_mjk

Thanks for the response…

Regards,
Shriraksha A N