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 [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
-~----------~----~----~----~------~----~------~--~---
