This content has been marked as final. Show 1 reply
I see that you have 100 initial and 100 as max connection pool size but why like that...?????
at start of the server it will wait for 100 connection to create and then move further so try to avoid such thing.
Keep initial capacity 5 or 10 and increment as 5 and keep Max pool size as 100.
This kind of tuning because even though you dont have load but all connection are already created and test frequency is for 120 second but where as inactive connection time you set for 180 seconds.
That cause big issue.
Make sure to keep inactive connection time less then test frequency seconds.
This setting will tune your Datasource and work perfectly and load on server will also reduced.