1 Reply Latest reply on Oct 25, 2005 10:05 PM by haribabu_nunna

Connection not getting closed

harappa75 Oct 25, 2005 3:55 PM

Hi,

I have a datasource with the following properties

<min-pool-size>5</min-pool-size>
<max-pool-size>30</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>

On JBoss startup I can see there are 5 connections opened in the database (SQL Server)

Now when I start my application, after just using 3 connections (run three queries with 3 different connection) the connection size in the DB has increased to 6 and it continues to increase, I have closed all the connections I am getting.

This is causing the "No Managed Connection Available" error very soon, and everytime I have to restart JBoss.

Can anyone point me in the right direction to solve this.

Regards
Rajesh J

1. Re: Connection not getting closed

haribabu_nunna Oct 25, 2005 10:05 PM (in response to harappa75)

Hai,
The problem for opening the connections is that even u access the Database or not the connections gets created by the min. no. of connection ie min-pool size. Once there are no any transactions on that connections then the Jboss closes the connections.. If they are not getting closed means. the problem is some where ur code has the connection object opened for you.... So plz check the code and also do let me know the version of JBoss ur using.......

Thanks & Regards,
Hari Babu Nunna...
Actions