I have below mentioned configuration for connection pooling on tomcat server 6.0.20:-
Issue here is, that as day passes by, same query that takes about 12-14 seconds to execute in morning takes about 50-70 seconds later in the day...after say 2-3 hours..
And performance degrades further on..I am sure, something is wrong in my connection pooling configuration in server.xml file.
I am not using hibernate or other ORM frameworks.
Pl let me know how do I optimize this configuration.
I added these messages in respective separate "close" methods..And found that
for each query that is executed, these messages were written to log file...So, I guess
connections leak is not taking place...
Is there any other way where we can find if any connections/statements/resultsets are still