This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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 ?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No of allowed connections
 
Similar Threads
errors while compiling the ant script
getting errors while running duke's bank application
JDBC Connection Pooling in Websphere
Exception during connecting to sql server2005
Does JDBC Use Certs or CA's ?