Recently I hosted my web application in a
tomcat server. They are providing Cpanel and mysql db with 25 max user connections. Once i deployed the application and once the cron jobs are running it gave me following exception
After that i used both Apche DBCP connection pool and BoneCp connection pool but the result was same.
I contacted support team from hosting company and they told me that form their side 25 max connections are allowed. So i wanted to figure out
how many connections actually are allowed to connect to the DB. So i wrote a simple code to connect to the DB and fetch some result set with in a loop with out closing the connection.
Once the code is running i found out that only connections are created 5 times but 25 times. When the code runs 6th cycle it gave me the same exception. But when i informed to the hosting team they confirmed that still 25 connections are allowed to connect.
My questions are
1. Is the way i used to check maximum allowed connections correct ?
2. If not how to check the maximum allowed connections to the DB ?
3. Is there any way to check this from DB ?
4. Can i check it with out running this code using a utility tool or something which comes with PhpMyAdmin ?
Thank you.