Connections for MySql

[Deepak Vishwanathan]

Hi,

 

I am writing a thread safe connection pool class. I want to connect to
MySQL through jdbc driver. In the initialization method, I write a
method that makes connections to the database and stores them in a
vector. When, I try making the 99th connection, MySQL throws an error
that says "java.sql.SQLException: General error, message from server:
"Too many connections".

 

What is max. limit on the number of connections for the JDBC driver?

 

Thanks,

Deepak