2 Replies Latest reply on Apr 18, 2002 1:41 PM by Guy Rouillier

    Timeout of connection even though I have it

    Guy Rouillier Newbie

      I'm using JBoss 2.4.3. I have an MBean that will potentially experience a high volume of transactions. Thus, I get a connection (to an Oracle database) from a JBossPool and hold onto it. That is, I don't close it each time I finish a method. This works fine for about half an hour, then I see a message in the log saying my connection has been returned to the pool! The relevant settings are:

      1200000
      120000
      900000

      Who is grabbing this connection I have and returning it to the pool without my consent? I've verified that if I try to use that connection from within my MBean, it says that the connection has been lost.

      Is this an optimization I shouldn't be attempting? No one else is using this pool except this one MBean. Of course I need to still think about Oracle closing the connection.