Hi I have MySQL (version 3.23.38) installed on Win 98 running locally as mysqld-opt which I am calling from a Java app using the mm.mysql-2.0.4 JDBC driver. I've also tried the new Connector/J but the same problem exists.
When I try to have more than 30 or so open connections at a time from the Java app I am getting the following error back 'Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.SocketException)' The problem does not always occur when I first use the Java app and access the database but after restarting the app several times the error occurs and will subsequently re-occur every time. Prior to the problem I'd not changed any of the configuration settings from the MySQL install. I've tried increasing max_connections (which was set at 100) but this has no effect. Sounds to me like some resource is being used up and possibly not being released but apart from that I haven't much clue. Regards Tony Prichard --------------------------------------------------------------------- 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