File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes No of allowed connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "No of allowed connections" Watch "No of allowed connections" New topic

No of allowed connections

Saman Sauron

Joined: Jul 06, 2010
Posts: 7
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.

Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

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

Not many get the right opportunity !
Saman Sauron

Joined: Jul 06, 2010
Posts: 7
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 ?
I agree. Here's the link:
subject: No of allowed connections
It's not a secret anymore!