Re: Connections for MySql

2004-05-02 Thread Mark Matthews 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Deepak Vishwanathan wrote:

| 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
Deepak,

This is not a client-side (JDBC) issue. See:

http://dev.mysql.com/doc/mysql/en/Too_many_connections.html

Regards,

-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http://www.mysql.com/it-resources/white-papers/tco.php
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAlV+9tvXNTca6JD8RAtECAJ47hlU16q0ieptGbI2lw4s7957e0ACghOM5
xyMxeNmyi1eP1Tn6wK9KtYY=
=FU51
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: connections to MySQL

2002-02-15 Thread Rick Emery 

does your test app connect with root as the user?

-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL


Hello All,

I am new to this list and hope that someone could answer this
question for me.

I am running on a fresh install of Redhat 7.2 and am trying to
connect to MySQL from a program that I have to test the connections,
but am getting error messages saying that the host in not allowed to
connect to this MySQL server.

This is strange because I ran my test app on the same machine that
the MySQL server is running.

Is there some file that I must modify to tell MySQL to accept
connections from various machines including localhost?

Also, does some one have a simple test program that they know works
that I might be able to use to try and connect to a simple database?

I need to validate my app is working correctly.

Thanks in advance,
Lonnie

-- 
 Lonnie Cumberland
 OutStep Technologies Incorporated
 (313) 832-7366

 URL: http://www.outstep.com
 EMAIL: [EMAIL PROTECTED]
  : [EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php