[Qt-interest] QtSql connection timeout error

[Thomas Fjellstrom]

On Thu September 17 2009, Stephen Jackson wrote:
> 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
> 

Partially valid. But lastError() should actually say there's an error if 
exec() fails, no?

-- 
Thomas Fjellstrom
tfjellstrom at shaw.ca