1 Reply Latest reply on Dec 15, 2007 12:04 PM by Vicky Kak

    JBoss Datasource pooling - only option?

    Paul Pantazis Newbie

      Is Datasource pooling considered a standard/default option in JBoss? I am using JBoss 4.0.5 and I am concerned how to keep track of end users threads into the database. If I need to kill a particular users connection will that mean taking down everybody in the pool? is there a way to do individual connections rather than pooling?

      Thanks kindly (PS Backend datasource is DB2).

        • 1. Re: JBoss Datasource pooling - only option?
          Vicky Kak Master

           

          "ppantazis" wrote:
          Is Datasource pooling considered a standard/default option in JBoss? I am using JBoss 4.0.5 and I am concerned how to keep track of end users threads into the database. If I need to kill a particular users connection will that mean taking down everybody in the pool? is there a way to do individual connections rather than pooling?

          Thanks kindly (PS Backend datasource is DB2).

          I am not sure what exactly you are asking .
          If you are getting the connection from the Datasource then you are getting the pooled connection which are provided by JCA framework.
          You can configure the min-pool-size/max-pool-size to 1 in the -ds.xml file , this will keep a single connection in a pool , so logical there is no pool of connection .
          Before doing this please make sure that you understand how Datasource/JCA stuff works and why is it needed .
          For knowing more details about it look here
          http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossJCA