[Zope-DB] cannot commit and nothing is written

[Florian Schuler]

Hello List,

I have a problem using pycong-0.99-5.

I want to insert a line into a table from a python script.=20
I do:=20
-->
c1.execute("insert into %s values
(%d,%d,%d,'%s','%s','%s','%s','%s','%s',%d);"=20
    				% (Mail_TABLE,
    				   int(MailID),
    				   int(ListID),
    				   int(ListEbene),
    				   str(Absender_Adresse),
    				   str(Absender_Name),
    				   str(EMailDaten_betreff),
    				   str(datum),
    				   str(uhrzeit),
    				   str(EMailDaten_inhalt),
    				   int(BezugMailID)))
c1.commit()
<--

It seems to work. The Debug message of pycong says:

[15758] psyco_curs_execute(): operation =3D >insert into mailingliste
values
(11,10,0,'fschuler@braunconsulting.de','fschuler@braunconsulting.de','N/=

A','11.10.2001','16:21:46','Das ist eine TestMassage mit List ID im
header',1);<
[15758] psyco_curs_execute(): operation->refcnt =3D 1
[15758] _psyco_curs_execute(): connection at 0x81072b0 OK
[15758] _psyco_curs_execute(): query =3D >insert into mailingliste =
values
(11,10,0,'fschuler@braunconsulting.de','fschuler@braunconsulting.de','N/=

A','11.10.2001','16:21:46','Das ist eine TestMassage mit List ID im
header',1);<
[15758] _psyco_curs_execute(): query executed
[15758] _psyco_curs_execute(): command returned OK (no tuples)
Traceback (innermost last):
  File "pop.py", line 202, in ?
    c1.commit()
psycopg.Error: serialized connection: cannot commit on this cursor

But the commit() doesn=B4t work and nothing is written into my table.=20

Does somebody of you know an awnser ?

Thanks in advance=20

Florian Schuler