[Qt-interest] QtSql connection timeout error

[Stephen Jackson]

On Thu, Sep 17, 2009 at 7:30 PM, Thomas Fjellstrom wrote:
> I've created a little long running process (a server), which connects to MySQL
> through the QtSql api, but occasionally the mysql connection times out due to
> inactivity (i assume). I've tried checking connection.isOpen(),
> connection.isValid(), and the connection.lastError(), but none of them seem to
> hint that there's even been a problem. isOpen returns true, isValid returns
> true, and lastError().code() is QSqlError::NoError but every single
> query.exec() fails.
>
> I'm stumped. How can I reliably detect when the connection drops like this?
>

Perhaps these two recent threads might be relevant to this problem.

http://lists.trolltech.com/pipermail/qt-interest/2009-August/011477.html

http://lists.trolltech.com/pipermail/qt-interest/2009-September/012347.html

-- 
HTH

Stephen Jackson