[sqlalchemy] DBAPIError

2010-02-15 Thread Federica D'Elia
hello, I developed an application that uses SQLAlchemy to write the records on the server. I have freetds 0.82.6 on the server. Sometimes I get an error like this: DBAPIError: (Error) ('08S01', '[08S01] [FreeTDS][SQL Server]Write to the server failed (20006) (SQLExecDirectW)') The error is not

[sqlalchemy] select nextval - None

2010-02-15 Thread Christoph Haas
Dear list, I have been upgrading an application I wrote with SQLAlchemy 0.4 to 0.5.8. Currently I'm fighting a strange effect. In some places of my application I can't insert data into the database any more. I get error messages like: IntegrityError: (IntegrityError) null value in column

Re: [sqlalchemy] select nextval - None

2010-02-15 Thread Michael Bayer
Christoph Haas wrote: So apparently SQLAlchemy tries to insert a new row with the id field being None. This is obviously wrong because the field is supposed to contain the next serial value. I enabled debugging and saw that before the insert SQLAlchemy runs: ___SQL___