[cx-oracle-users] Possible to make SessionPool.acquire() block until connection available?

[Jim F. <jim...@sb...>]

I have an app which has more worker threads than my session pool max setting, because these threads spend most of their time doing wotk other than DB calls.
 
My problem is when acquire() is called and there are no available connections, a cx_Oracle.DatabaseError is immediately thrown.  Ideally I'd like acquire() to block up to some timeout period, and if multiple threads are blocked on acquire(), they received connections in the same order they blocked.
 
Maybe the way the Oracle DRCP interface works (which I know little about) prevents this?