On Feb 4, 2008 12:08 PM, Felix Schwarz <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm chasing a very nasty bug in my TurboGears-Application > (using SQLAlchemy r4116, Elixir 0.5): I create a new object > and flush that session (ScopedSession) but there is no COMMIT > issued and therefore the data is never saved in the database. > > Interestingly, I can retrieve the new record via Elixirs 'get_by' > mechanism as long as the app is not restarted so the data is at > least 'somewhere' in memory.
Is your session configured to be transactional and you don't issue any session.commit()? Other than that, maybe you are (or Turbogears is) starting a transaction somewhere (with session.begin()) without ever commiting it? Try using a session.commit() at the end of your request code. If those don't help, verify you are not using an in memory sqlite database by mistake (yeah, I know, this is a stupid one but you never know)... Hope it helps, -- Gaëtan de Menten http://openhex.org --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
