On Oct 17, 2012, at 3:48 PM, Ben Hitz wrote: > > Oh thanks, I hadn't dug that deeply into FSQLA yet. This is narrowing down > the issue though. Our anecdotal experience is that pool_recycle is not doing > anything with Oracle... hopefully have a test (or ideally a "never mind") > follow up in a few days. > > Am I correct in assuming that SQLA connection pool is wholly independent of > Oracle's connection pooling (which we have disabled)?
yes SQLA's system is just dealing with whatever cx_oracle.connect() gives us, I'm not sure if cx_oracle itself has pooling options but we don't call upon those. the key aspect of pool_recycle is that it is only checked when the connection is retrieved from the pool. so the app needs to be closing/returning those connections at the end of each request. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
