Re: [Zope-dev] Re: Strange serializing error when commiting -> zope.sqlalchemy

2008-06-03 Thread Dieter Maurer
Hermann Himmelbauer wrote at 2008-6-3 14:00 +0200: > ... >Hmmm, it's not that easy: I have multiple sites on one Zope3 instance, whereas >every site should connect to another database. For that reason, I thought >about a local utility. However, this results in this serialization error. Usually,

Re: [Zope-dev] Re: Strange serializing error when commiting -> zope.sqlalchemy

2008-06-03 Thread Laurence Rowe
See the long discussion on zope.sqlalchemy Integration ideas. I think the simplest way to achieve this is to register a global utility for each site, with the site name as the utility name perhaps. You can then register an ISession adapter for the root object in each site that does: session = get

Re: [Zope-dev] Re: Strange serializing error when commiting -> zope.sqlalchemy

2008-06-03 Thread Hermann Himmelbauer
Am Dienstag, 3. Juni 2008 12:21 schrieb Laurence Rowe: > Laurence Rowe wrote: > >> I found it by myself: I registered a zope.sqlalchemy related utility, > >> which stores an engine (self.engine = create_engine(DSN,...)) and a > >> scoped session (self.Session = scoped_session(sessionmaker...)). The

[Zope-dev] Re: Strange serializing error when commiting -> zope.sqlalchemy

2008-06-03 Thread Laurence Rowe
Laurence Rowe wrote: Hermann Himmelbauer wrote: Am Montag, 2. Juni 2008 20:04 schrieb Hermann Himmelbauer: Hi, In my zope3 tests, I set up some basic test data. After that, I'm calling transaction.commit(). However, I get the following traceback: --- snip --- F

[Zope-dev] Re: Strange serializing error when commiting -> zope.sqlalchemy

2008-06-03 Thread Laurence Rowe
Hermann Himmelbauer wrote: Am Montag, 2. Juni 2008 20:04 schrieb Hermann Himmelbauer: Hi, In my zope3 tests, I set up some basic test data. After that, I'm calling transaction.commit(). However, I get the following traceback: --- snip --- File "copy_reg.py", line