Hi all,
I am using JBoss 4.0.3SP1 and mysql on linux box. I have getting "No More managed
Connection" error if jboss is up for more than 3 days.
I have kept 200 max connections in mysql ds file and 200 max coonections in myql config
file too. One of the batch jobs creats around 90 odd connections at night. In 3 days, at
JMX console i see "Available coonection count" as 0 and "Connections in
use" as 200.
When i look at mysql, it shows me that 200 coonections were in use at one time but now (at
that time) only 2 or 3 coonections are in use.
I have set idle timeout to "1" in jboss. Still, either the coonections are not
geting released or connects are sitting idle and not being used by jboss when new request
comes.
Please guid me on this. I have checked my code for possible connection leaks and have put
connection.close() at every possible location.
Any work arounds for this? Am i missing anything?
Thanks in advance,
Ravi.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4084956#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...