Sharing An Oracle Database Connection Between Simultaneous Celery Tasks

I'm working with Python2.7, Celery and cx_Oracle to access the Oracle database. I create a lot of tasks. Each task runs a query through cx_Oracle. Many of this tasks will run simul

Solution 1:

If you wish to have multiple threads sharing the same connection you need to enable threaded mode. Something like this:

conn = cx_Oracle.connect(connection_str, threaded = True)

If you don't you can run into some interesting problems!