Maximum Pool Size parameter in JDBC connection

shriraksha · April 5, 2011, 12:34pm

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

devexpert · April 5, 2011, 1:29pm

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.

Jeevan_Kiran · April 5, 2011, 2:33pm

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

shriraksha · April 6, 2011, 9:34am

Thanks for the response…

Regards,
Shriraksha A N