Hi, I have a JNDI connection to a MySQL database, a new thread is started every n seconds which queries a web service and then returns with the response time or a timeout. Each of these threads has a connection to the database. If the server is responding very slowly or indeed not responding at all then the number of threads which are running obviously grows.
If I watch the SQLManager there are only ever 8 connection maximum from the java application when technically more should exist. The maximum in both the tomcat JNDI declaration and in MySQL are set to 100. Max Idle is also set to 100. Thread concurrency is set to 100 in MySQL properties. I'm not sure but have an idea that the thread concurrency setting for a JNDI may be the problem, the default for mysql is 8 as well so could be set to 8 in JNDI but I have no idea to change it. Anybody know how to or have any other ideas? I am using Tomcat 5.0 and the mysql connector version 3.0.14. Help appreciated, Thanks, Christopher Hampson
