1 Reply Latest reply on Jul 6, 2004 12:55 PM by Ratheesh Ramachandran

    Database connection Pool problems/questions

    Ratheesh Ramachandran Newbie

      In order to check the Pooling behavior, I was trying the following (after configuring an oracle database as datasource) :

      //get datasource using jndi
      Connection conn = datasource.getConnection("user1", "pwd1");
      conn.close();
      conn = datasource.getConnection("user2", "pwd2");
      conn.close();

      Then, I checked the sessions in the database. It says : 1 alive session for user "user2".

      After some 15 minutes, I checked again. The database now says : 1 alive session for user "user1" !

      Could somebody explain this behavior ? When does a connection in a Pool finally get closed ?

      Thanks
      Ratheesh