connectios are not returning to pool

[kavuriprasad]

Dear All,

We are using JBoss and mysql, connectionpool we are using is
JBossManagedConnectionpool. Normally it is working fine. But some
times connections are not returning back to Connection Pool and it
keep growing in 2-3 hrs. So once it happened the next request is not
getting connection from connection pool , it just using the
non-returned connection and we are getting SQL Exception i.e; SQL Error: 0 SQLState: 08S01 (since it is
using the old (bad)connection).
I have gone through the forum to check for related queries, but I was unlucky ..

Your help is highly appreciatable ..

Note: Connections InUse is growing when multiple requests are issued at same time and only one connection was returning back. And once after this scenario single request connectios also not returning back (some times only).

Thanks in advance,
Kavuri.

[daywalkr]

Hi,

i have the same problem with jboss 3.2.5 and mysql.. my availableConnectionsCount is decreasing over time. I added the
<check-valid-connection-sql> tag to the datasource service but, the decreasing of the connection pool did not stop. after 3 days my application throws "get no managed connection" exceptions and fails until restart of jboss. the jboss is on productive use :-(

can somebody help me or give me some hints ?

greetings
ingo

[gabramovic]

Hi daywalkr,

Did you ever resolve this issue as I have the same problem on my production server?

Regards,
Goran