TG 1.0.8 difference in autoCommit between Windows and Linux ?

2 views
Skip to first unread message

Pezzi

unread,
May 18, 2009, 11:52:16 AM5/18/09
to TurboGears
All,

I have a TG 1.0.8 app that lets a user create a background thread to
do some work - and it reports its status to a DB record (in MySQL). I
am using SQLObject.

On Linux, it commits on a regular basis (probably after every update).
On Windows, it only commits after the thread completes, which can be
after several hours.

I tried to explicitly commit the change on every iteration but to no
avail:

trans = self._connection.transaction()
self.status = str(counter)
trans.commit()

Per MySQL, AutoCommit is true, and setting it explicitly in the
connection string changes nothing, as expected.

What else can I do ?

Thanks

Pezzi
Reply all
Reply to author
Forward
0 new messages