Dennis Allison wrote:
I have not yet completed differential diagnosis, but I was hoping someone
had encountered a similar problem and could pass along a fix/workaround.
1.2.x has no autocommit, so you have to commit your changes with
connection.commit() see e.g.
The following program fails to do the writes --
dbuser = 'root'
dbpass = 'XXXXXX'
host = 'localhost'
connection = MySQLdb.connect( db=initdb, user=dbuser, passwd=dbpass,
cursor = connection.cursor()
qd = "delete from test.data"
qi = "insert into test.data values('ardvark', 'homework') "
q2 = "select * from test.data"
res = cursor.fetchall()
when run with Mysql-Python-1.2.1c under Python 2.4.2, but works just
find with Mysql-Python-1.1.1 under Python 2.3.5.
The tables are Innodb tables (that is, transactional).
ZMySQL commits for you, so this should work. BTW and just for the
record: Python 2.4 is not recommended for Zope 2.8.x, but I'm sure you
know that ;-)
Running Zope with Python 2.4.2 and Mysql-Pyton 1.2.1c works just fine.
Is there something special I need to do that I have forgotten?
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -