I have a Java Application deployed on Jboss and uses the jdbc pool to connect to DB.
I set the max-pool-size to 10 and the application hung after a while. I changed it to 100 but the issue still occured. I checked the database side and I see that only 6 connections are there (not 100).
Is there other jdbc parameters to ajust for this kind of situations? The application is doing a mass concurrency queries that don't take a lof of time.
There can be multiple reasons for application hung. For hung issue thread dumps are useful. Capture multiple(6) thread dumps with interval of 20secs and see which threads are stuck. You can capture thread dump using jstack utility which is shipped with JDK.