then you're still using zope.transaction. I think you need to ask on the Pyramid list for advice with that, or possibly find a different route to solving your issue.
On Apr 28, 2013, at 3:22 PM, sajuptpm <sajup...@gmail.com> wrote: > Hi Michael Bayer, > > I am getting following errors > > > 1) > engine = DBSession.bind > DBSession.commit() > > assert self.transaction_manager.get().status == ZopeStatus.COMMITTING, > "Transaction must be committed using the transaction manager" > AssertionError: Transaction must be committed using the transaction manager > > > > 2) > conn = engine.connect().execution_options(isolation_level='SERIALIZABLE') > > conn = engine.connect().execution_options(isolation_level='SERIALIZABLE') > AttributeError: 'Connection' object has no attribute 'execution_options' > > > > > ==================== > > > a) Sqlalchemy version > > >>> sqlalchemy.__version__ > '0.5.6' > > > b) > ====dir(engine.connect())========== ['_Connection__branch', > '_Connection__close_with_result', > '_Connection__connection', '_Connection__create_execution_context', > '_Connection__distill_params', > '_Connection__execute_context', '_Connection__invalid', > '_Connection__savepoint_seq', > '_Connection__transaction', '__class__', '__delattr__', '__dict__', > '__doc__', '__format__', > '__getattribute__', '__hash__', '__init__', '__module__', '__new__', > '__reduce__', '__reduce_ex__', > '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', > '__weakref__', '_autorollback', > '_begin_impl', '_begin_twophase_impl', '_branch', '_commit_impl', > '_commit_twophase_impl', '_cursor_execute', > '_cursor_executemany', '_execute_clauseelement', '_execute_compiled', > '_execute_ddl', '_execute_default', > '_execute_function', '_execute_text', '_handle_dbapi_exception', > '_prepare_twophase_impl', > '_release_savepoint_impl', '_rollback_impl', '_rollback_to_savepoint_impl', > '_rollback_twophase_impl', > '_savepoint_impl', 'begin', 'begin_nested', 'begin_twophase', 'close', > 'closed', 'commit_prepared', > 'connect', 'connection', 'contextual_connect', 'create', > 'default_schema_name', 'detach', 'dialect', > 'drop', 'engine', 'execute', 'executors', 'in_transaction', 'info', > 'invalidate', 'invalidated', > 'recover_twophase', 'reflecttable', 'rollback_prepared', 'run_callable', > 'scalar', 'should_close_with_result', > 'statement_compiler'] > > > Thanks, > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.