Thanks. autocommit flag did the trick. BTW is it the best way of
calling stored procedures?
-- jacek
On Feb 19, 12:48 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> add the autocommit=True flag to your text() construct, or use an
> explcit begin()/commit() call with the connection.
>
> On Feb 19, 2009, at 3:28 PM, jack2318 wrote:
>
>
>
> > Hi,
> > I am running following test:
>
> > conn = engine.connect()
> > conn.execute(text("CALL SP_SA_TEST(4)"))
> > conn.close()
>
> > engine echo:
>
> > 2009-02-19 12:17:29,069 INFO sqlalchemy.engine.base.Engine.0x...8310
> > CALL SP_SA_TEST(4)
> > 2009-02-19 12:17:29,069 INFO sqlalchemy.engine.base.Engine.0x...8310
> > []
>
> > inside SP_SA_TEST I have:
>
> > INSERT INTO DEBUG (`FROM`, `COMMENT`, `VALUE`) VALUES ('SP_SA_TEST',
> > 'FIRST', A);
>
> > and this insert is always ROLLBACKED and never COMMITED - I check
> > primary key in DEBUG table - the primary key is increased but then the
> > record is gone.
>
> > When I execute this same procedure from mysql directly everything
> > works fine.
>
> > I'm doing something wrong?
>
> > regards
> > -- jacek
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
