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

[Vladimir R. <gre...@gm...>]

Hello, Jim,

Did you consider using language synchronization primitives, like
threading.Semaphore or multiprocessing.Semaphore?


2014-08-01 0:46 GMT+04:00 Jim Freeman <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?
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>