aspose file tools*
The moose likes JDBC 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
Bookmark "No of allowed connections" Watch "No of allowed connections" New topic
Author

No of allowed connections

Saman Sauron
Greenhorn

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.


S.D. MADHAN
Not many get the right opportunity !
Saman Sauron
Greenhorn

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 ?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: No of allowed connections
 
Similar Threads
Does JDBC Use Certs or CA's ?
errors while compiling the ant script
getting errors while running duke's bank application
Exception during connecting to sql server2005
JDBC Connection Pooling in Websphere