On 27 Sie, 14:12, caffecoder <[EMAIL PROTECTED]> wrote:
> Hello.
>
> I have pylons 0.96 (SVN) and current SQLAlchemy, and I have bug that
> doesn't exist earlier.
>
> My connection code:
> <code>
> import sqlalchemy.mods.threadlocal
> from sqlalchemy import DynamicMetaData, objectstore
>
> metadata = DynamicMetaData( case_sensitive = False )
>
> def db_connect( dsn ):
> engine = create_engine( dsn, echo=False, echo_pool=False,
> encoding='latin2', convert_unicode=True, pool_recycle=3600,
> pool_timeout=15, pool_size=5 )
> metadata.connect( engine )
> </code>
>
> command "netstat -an|grep 5432|grep ESTABLISHED|wc -l" displays one
> more connection after each refresh of page until I have exceptions
> such as:
>
> sqlalchemy.exceptions.DBAPIError: (Connection failed)
> (OperationalError) FATAL: sorry, too many clients already
Don't use DynamicMetaData(), use MetaData(), it's the problem.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
