I have the following very simple program with SA0.2, which just changes a field of a selected object and flushes it back to the database:
import sqlalchemy.mods.threadlocal from sqlalchemy import * meta = BoundMetaData('postgres://postgres:[EMAIL PROTECTED]/test', echo=True) class Brand(object): pass t_brands = Table('brands', meta, autoload=True) Brand.mapper = mapper(Brand, t_brands) brands = Brand.mapper.select() brands[1].brand_name = 'BrandNew' objectstore.flush() Running the program gives the following output: ... [2006-05-18 07:43:37,858] [engine]: {} [2006-05-18 07:43:37,890] [engine]: BEGIN [2006-05-18 07:43:37,905] [engine]: UPDATE brands SET brand_name=%(brand_name)s WHERE brands.brand_id = %(brands_brand_id)s [2006-05-18 07:43:37,921] [engine]: {'brand_name': 'BrandNew', 'brands_brand_id': 2} [2006-05-18 07:43:37,953] [engine]: COMMIT Traceback (most recent call last): File "simple_test.py", line 15, in ? objectstore.flush() File "d:\Python24\lib\site-packages\sqlalchemy-0.1.6-py2.4.egg\sqlalchemy\orm\session.py", line 233, in flush self.uow.flush(self, objects, echo=self.echo_uow) File "d:\Python24\lib\site-packages\sqlalchemy-0.1.6-py2.4.egg\sqlalchemy\orm\unitofwork.py", line 243, in flush trans.rollback() File "d:\Python24\lib\site-packages\sqlalchemy-0.1.6-py2.4.egg\sqlalchemy\orm\session.py", line 55, in rollback t[1].rollback() File "d:\Python24\lib\site-packages\sqlalchemy-0.1.6-py2.4.egg\sqlalchemy\engine\threadlocal.py", line 12, in rollback base.Transaction.rollback(self) File "d:\Python24\lib\site-packages\sqlalchemy-0.1.6-py2.4.egg\sqlalchemy\engine\base.py", line 340, in rollback raise exceptions.InvalidRequestError("This transaction is inactive") sqlalchemy.exceptions.InvalidRequestError: This transaction is inactive What could be wrong? By the way, is the main functions described in SA0.2 documentation fully implemented? For example, the function current_session doesn't seem to exist. I am trying to switch to SA as my ORM for a production system. Shall I start with SA0.17 or directly with SA0.2? -- Hong Yuan 大管家网上建材超市 装修装潢建材一站式购物 http://www.homemaster.cn R颧�:&q�[嘿�y�hv�ō�^y�h碴i⒒py����z�r赈�!�端n}�h�戤��%������{^�董y�^r���2����歙焊�m娆�昝� 濉�H��m*az����bq�b�t��鳙�]5m�v�昆�!xg��xΒm���zV�呵��F���遍\�