look into the pool_recycle option described at http://www.sqlalchemy.org/docs/05/dbengine.html .
On Nov 1, 8:41 am, abhishek <[EMAIL PROTECTED]> wrote: > Hello group, > > is there a way through which i can handle MySQL DB Operational errors > "MySQL Server has gone away". i am using turbogears1.0, CP2.2 and > SQLALCHEMY 0.5. > > Just to share i am using turbogears database sessions. > > Here's snippet of imports in model.py file > > from turbogears.database import metadata,mapper,bind_meta_data,session > # import some basic SQLAlchemy classes for declaring the data model > # (seehttp://www.sqlalchemy.org/docs/04/ormtutorial.html) > from sqlalchemy import Table, Column, > ForeignKey,MetaData,create_engine > from sqlalchemy.orm import relation,scoped_session,sessionmaker > from sqlalchemy.schema import PassiveDefault > from sqlalchemy.sql import and_,join,select,func > # import some datatypes for table columns from SQLAlchemy > # (seehttp://www.sqlalchemy.org/docs/04/types.htmlfor more) > from sqlalchemy import String, Unicode, Integer, > DateTime,Text,Date,Time,SmallInteger,Float > from sqlalchemy.ext.assignmapper import assign_mapper > from sqlalchemy.databases.mysql import MSEnum, MSBoolean --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---