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
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