Re: [sqlalchemy] connection lost contact error for first database connection every morning

2010-06-09 Thread Michael Bayer
since nobody is getting back to you on this one you want to look into pool_recycle at http://www.sqlalchemy.org/docs/reference/sqlalchemy/connections.html#sqlalchemy.create_engine . On Jun 9, 2010, at 10:33 AM, Kerrb wrote: > We are using SQLAlchemy with our Plone CMS to connect to an Oracle

[sqlalchemy] connection lost contact error for first database connection every morning

2010-06-09 Thread Kerrb
We are using SQLAlchemy with our Plone CMS to connect to an Oracle database. The connection pool is set to 5 and it works fine all day. The first person to try to use it in the morning gets a "connection lost contact" error. If they refresh they get the connection. Oracle is not dropping the connec