[sqlalchemy] Re: [Sqlalchemy-users] Test failure on Mac OSX 10.4.8 w/ Python 2.4.4c1

2006-10-15 Thread skip . montanaro
Michael> (just FYI we've moved the list to google groups) Ah yes, forgot about that. Michael> i think the error you have might be a result of MySQLDB not Michael> being installed on your machine, and the dialect, not finding Michael> it, is defaulting to "named parameter" mode.

[sqlalchemy] Re: [Sqlalchemy-users] Test failure on Mac OSX 10.4.8 w/ Python 2.4.4c1

2006-10-15 Thread Michael Bayer
hey skip (just FYI we've moved the list to google groups) i think the error you have might be a result of MySQLDB not being installed on your machine, and the dialect, not finding it, is defaulting to "named parameter" mode. i could put a fix into the mysql dialect to default to "position

[sqlalchemy] Re: ObjectAlchemy - ODMG compatible layer for SQLAlchemy

2006-10-15 Thread Michael Bayer
Ilias Lazaridis wrote: > I've understood that SA can be used to produce an SQLObject compatible > layer: > > http://groups.google.com/group/turbogears/browse_thread/thread/89dc84b2e9d9d860 > > maybe you have some comments to this thread. as was mentioned in the thread, ActiveMapper allows a decl

[sqlalchemy] Re: MySQL Has Gone Away

2006-10-15 Thread Michael Bayer
use the "pool_recycle" setting on your create_engine call. On Oct 15, 2006, at 8:33 PM, jlowery wrote: > > This isn't unique to SQLAlchemy, but when using MySQL after long > periods in inactivity (in a web-app server) with the objectstore > session, the error: > > MySQL server has gone away > >

[sqlalchemy] MySQL Has Gone Away

2006-10-15 Thread jlowery
This isn't unique to SQLAlchemy, but when using MySQL after long periods in inactivity (in a web-app server) with the objectstore session, the error: MySQL server has gone away comes up, meaning the database conneciton has timed out. Is there anyway to inject in a simple test query (and possibl

[sqlalchemy] Re: Doubt about proper handling Firebird dialect 1 and 3

2006-10-15 Thread Lele Gaifax
Oleg Deribas wrote: >> Well, most probably yes, even though it would be nice having SA figure >> out and doing the right right by itself. > > Possibly, SA could determine firebird's version and use some > version-specific features. I have the following example for getting > firebird/interbase v

[sqlalchemy] Re: serializable transactions

2006-10-15 Thread Michael Bayer
I cant find any official docs for psycopg2 on this, except the impression from some various mailing list posts that postgres is in "serializable" mode by default, and also if you want to change the isolation mode you use connection.set_transaction_isolation(). also i dont know what the mapp

[sqlalchemy] Re: Doubt about proper handling Firebird dialect 1 and 3

2006-10-15 Thread Oleg Deribas
Hello, Lele Gaifax said the following on 13.10.2006 17:17: >> you as the end user connecting to this firebird database *do* know >> which of firebird dialect 1 or 3 which is to be used for each database, >> correct ? > > Well, most probably yes, even though it would be nice having SA figure

[sqlalchemy] serializable transactions

2006-10-15 Thread Sol
Hello, how would I use serializable transactions with SA and Postgres? Is there something around that i missed? -- Cheers, Sol. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this gr

[sqlalchemy] Re: ObjectAlchemy - ODMG compatible layer for SQLAlchemy

2006-10-15 Thread Ilias Lazaridis
Michael Bayer wrote: > well, I am all in favor of projects basing themselves on SA, and if it > also means that ActiveMapper will be improved/documented, thats just > great. SA also aims to be as open as possible to extensions of its > functionality (but importantly, while keeping specialized con