Pezzi
unread,May 18, 2009, 11:52:16 AM5/18/09Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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