Am 20.02.2011 21:40 schrieb sharkus:
However, when actually testing a query from the site I get an "OperationalError: (OperationalError) no such collation sequence". I can SOMETIMES get things to work if I add something like this to my root controller method (perhaps 1 out of 5 times):
That's because SQLAlchemy is using a pool of database connections (5 by default) and you ran create_collation only on one of the connections.
A simple solution would be to reduce the number of connections to 1 (sqlalchemy.pool_size=1 or sqlalchemy.pool_size=NullPool).
If you want to use the pool, you can set sqlalchemy.creator to a function that sets up your connection with create_collation. See
http://www.sqlalchemy.org/docs/core/pooling.html#using-a-custom-connection-function -- Christoph -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
