with multiprocessing, you have to make sure you are using an empty
engine at the start of each process, or have otherwise arranged for
connections to be refreshed in the new process; the database connections
in an engine are pooled, and if you transfer those connections to a new
process it
I get ORA-03113 all the time both using sqlalchemy raw sql and using
Sqlalchemy to select. Can some one help me to check if they is a problem
with my connection string or if they is some thing Missing.
def connect():
try:
return cx_Oracle.Connection(connstring)
except