Timeout of connection even though I have it

[guy_rouillier]

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.

[davidjencks]

I'll leave my comments about the pool code to myself.

In this case I believe the GCMinIdleTime is biting you. The "feature" in question is "Garbage Collection" which in this case means returning connections that have been checked out too long back into the pool. I've yet to think of any circumstance in which this could possibly be appropriate behavior...

Anyway try setting GCMinIdleTime to Long.MAX_VALUE or so. You might need something a little smaller to avoid overflow.. maybe max_value/2

[guy_rouillier]

David, thanks. As always, your assistance is greatly appreciated.