Possible to make SessionPool.acquire() block until connection available?
Jim Freeman <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users