0 Replies Latest reply on Nov 23, 2002 1:59 AM by fox

    any way to track the # of connection in the pool and connect

    fox Newbie

      Hi All

      It is very thankful some guru can help me out on following questions.

      1) is there any thing in the Jboss framework (API / logging message) that could help me track (i) # of connection in the pool (ii) connections involved in a transaction and were they released back to pool after transaction

      2) how does jboss transaction manager and connection pool handle following case

      [
      start a tx
      con = datasource.getconnection();
      access db
      con.close();
      .......
      con = datasource.getconnection();
      access db
      con.close();
      ......
      con = datasource.getconnection();
      access db
      con.close();
      .....
      end tx
      ]

      As shown above Within the transaction, "datasource.getconnection()" is called multiple times by the DAO objects to access db. (i) Will the same connection always returned by the "getconnection" invocation ?
      (ii) If no so, different pooled connection are returned each time, all are involved in a transaction. Should all these connections be retained by the pool for this transaction until the transaction end (other tx will not be able to fetch these connections from the pool and use them) ?

      Thanks you so much for your reply in advance !

      fox