MySQL Session

[sprkrt]

I have a MySQL session and to check against timeouts. I was using session->isConnected()

I'm guessing that this will not work and I would have to do some sort of ping check using a query like: 'select 1'


Is Session::isConnected() not supposed to return false if the session was closed due to something timing out?

[alex]

Is Session::isConnected() not supposed to return false if the session was closed due to something timing out?

In theory, yes. I have no experience with MySQL but I found isConnected()to be highly unreliable with ODBC (Oracle in particular - it will return true when connection has, in fact, been lost), so I had to resort to running a dummy query and catching exception.

[Royce]

I put auto-reconnect=true in my connection string and called it a day. It eliminated my "mysql server has gone away" exceptions due to idle timeouts.