On Thu, Oct 8, 2009 at 5:20 PM, Michael Bayer <[email protected]>wrote:
>
> Nicol van der Merwe wrote:
> > My problem is when I am trying to execute a stored procedure and use the
> > commit and rollback features of sqlAlchemy.
>
> the issue is the usage of db.bind.execute("statement"). This system uses
> SQLA's "autocommit" behavior which is not detecting the textual statements
> you're passing along as in need of a "commit".
>
>
> to issue the "commit", use either a text() construct which specifies
> autocommit=True, or use an explicit Transaction/Connection as described in
>
> http://www.sqlalchemy.org/docs/05/dbengine.html#using-transactions-with-connection
> .
>
>
>
>
> >
> > When I execute a simple stored procedure, one that inserts a row into a
> > table and returns one result, it works as expected. It executes
> > successfully
>
snip 8<
Hi Michael
Thanks so much for your help. It's resolved now.
I used an explicit Transaction/Connection as you suggested and now it all
works!
You just made my day :)
--
Nicolaas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
