No of allowed connections

[Saman Sauron]

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

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User xxx_root already has more than 'max_user_connections' active connections

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.

        for (int i = 0; i < 100; i++) {
            System.out.println(" <><><><><><><>><> CYCLE " + i + " <><><><><><><><><><><><><");

            try{
            Connection con = getJDBCConnection();
            Properties properties = (Properties) SpringContext.getBean("appProperties");
            String db = properties.getProperty("jdbc.db");
            String dailyTradeTable = properties.getProperty("jdbc.dailytrade.table");
            String findSql = "select count(*) as count from  " + db + "." + dailyTradeTable + "";
            PreparedStatement prepGetTrade = con.prepareStatement(findSql);
            ResultSet resultSet = prepGetTrade.executeQuery();

            while (resultSet.next()) {
                System.out.println(" COUNT IS : " + resultSet.getString("count"));
            }
            } catch(Exception e) {
                System.out.println("************ ERROR OCCURED" + e.getMessage());
                e.printStackTrace();
            }
            System.out.println(" <><><><><><><>><> END CYCLE " + i + " <><><><><><><><><><><><><");

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.

[Madhan Sundararajan Devaki]

One simpler alternative is, to ask the host to PROVE that they offer the said number of connections.

[Saman Sauron]

Madhan Sundararajan Devaki wrote:One simpler alternative is, to ask the host to prove that they offer 25 simultaneous connections.

Isn't it obvious that no of connections means "simultaneous connections" in a normal world. Just curious to know is there any host provider who is giving no of connection times as you meant ?? Connections always has to be simultaneous ? Isnt it ?