1 Reply Latest reply on Jan 27, 2006 12:16 PM by Adrian Brock

    Sleeping database connection

    Murilo Almeida Newbie

      I am working with JBoss 4.0.3, SQL Server 2000 SP4 and Microsoft SQL Server 2005 JDBC Driver. I have set up a connection pool for my application connect within DB. The IdleTimeoutMinutes are set up for 15 minutes but I can see that JBoss are creating connection and not destroying it fine. I have more than 400 as ConnectionCount and I see that JBoss are creating new connections and does not destroying the old ones. From SQL server side, I see the same number of connection as Sleeping connections. The last SQL statement executed for these connection are [COMMIT TRAN] and [sp_execute;1]. Please, do you have any idea of what is happening and how to resolve this issue? Many thanks in advance.