Blocking poolable datasource bug?

[Corin Moss <Co...@tvnz.co.nz>]

Hi Guys,

Before I submit a bug report, I though I'd quickly ask if anyone has
experienced similar behaviour, I've noticed a few postings in the user
group talking about similar things:

I'm using Oracle 9i (9.1.2) with the role for my datasource set to use
ResourceLimitingJdbcDataSource.  I've noticed that under load test when
I have max-strict set to true, and I reach the maximum number of pooled
connections (for example 100) connections are never released back into
the pool, even after the query has executed and returned.  Up until the
maximum is returned the connections are released into the pool properly.
By setting max-strict to false I do not experience this  - every
connection is put back into the pool.  If I hit (for example) 150 pooled
connections, the number of objects in the pool will drop as utilisation
drops. 

It would seem that the blocking thread is not un-blocking, even when a
connection is returned. I haven't dived into the code enough to
understand why this might be happening. I'm not sure if this is because
of something that Oracle is doing,  although this would seem unlikely,
as it is fine when the pool can grow.

So, does anyone have any insight on this? Or should I just go ahead and
submit a bug? :)

Thanks,

Corin

Corin Moss
Lead Developer
TVNZ Interactive

+64 9 916 7367
+64 21 403 054
corin.moss@tvnz.co.nz




================================================================
CAUTION: This e-mail and any attachment(s) contains information
that is intended to be read only by the named recipient(s). It
may contain information that is confidential, proprietary or the
subject of legal privilege. This information is not to be used by
any other person and/or organisation. If you are not the intended
recipient, please advise us immediately and delete this e-mail
from your system. Do not use any information contained in it.

================================================================
For more information on the Television New Zealand Group, visit
us online at http://www.tvnz.co.nz
================================================================