did you call Session.commit() ? otherwise you're still in an open transaction, assuming default settings.
Session.execute() is not the same as engine.execute(), where the latter is autocommitting (assuming you also called execution_options(autocommit=True) for this particular text() construct). On May 31, 2012, at 9:23 PM, Will Orr wrote: > Hello all! > > I'm having this *exact* bug from a few years ago wrt. calling stored > procedures. > https://groups.google.com/forum/?fromgroups#!topic/sqlalchemy/qA_ypVgJ1B0 > > What makes it worse, however, is that adding the autocommit execution option > or explicitly starting and stopping a transaction do nothing. > > session.execute(text('call add_logentry(:username, :hostname, :action, > \'0000-00-00 00:00:00\')'), { > 'username': username, > 'hostname': hostname, > 'action' : action > }) > > There's the code. It should insert some values into some tables, however > those values are never inserted, though the primary key counter is > incremented. > > I'm using SQLAlchemy with ZopeTransactionExtension. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/si1vqn5kmjoJ. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.