1 Reply Latest reply on Oct 25, 2005 10:05 PM by Hari Babu Nunna

    Connection not getting closed

    Rajesh J Newbie

      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
          Hari Babu Nunna Newbie

          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...