On Apr 12, 2007, at 10:31 AM, vinjvinj wrote:
> The problem is that the data is not seen by the second application > server. When I log into to mysql from my desktop I CAN see the data. > The problem goes away when I restart the application server with sql- > alchemy. I'm caching the mysql.db connection object. its possible that the connection youve retrieved, once used to query a table, now has an open transaction on it and is not reading the actual results. consider calling rollback() on the connection after each query, or just returning it to the connection pool via close() (which also calls rollback()) and then re-acquiring it from the pool as needed. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
