com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: in mysql

Question

Hi I have created jdbc program and database is MySQL 5.1 Also all my friends using same database for connection. Total number of connection became 150 from all of us. So when i want to connect more then i got the following error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. How to resolve this error. Thanks Sunil Kumar Sahoo

Accepted Answer

I solved the problem by increasing number of connection

set @@global.max_connections = 1250;

Have a look on the below link http://www.netadmintools.com/art573.html

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: in mysql

Solution

Problem