From: Warren Young
Date: September 28 2010 6:13pm
Subject: Re: ConnectTimeoutOption
List-Archive: http://lists.mysql.com/plusplus/9064
Message-Id: <4CA2305B.4090806@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

On 9/28/2010 11:26 AM, Tom Lachecki wrote:
>
> I'm reading section 3.15 in the tutorial and I'm a little confused.

Yeah, well, you're not the only one.  I wrote it, and I was clearly also 
a little confused.

> The prose suggests that "ConnectTimeoutOption" is an option to control
> the idle time-out of the connection to the mysql server. However the
> name implies that it is an option to control the timeout of a call to
> connect().

It's the latter.  ConnectTimeoutOption solves your problem.

For the interested, I've replaced the recommendation with this:

"Another way around this, on a per-connection basis from the client 
side, would be to set the ReconnectOption connection option. This will 
cause MySQL++ to reconnect to the server automatically if it drops the 
connection. Beware that unless you’re using MySQL 5.1.6 or higher, you 
have to set this only after the connection is established, or it won’t 
take effect. This means there’s a potential race condition: it’s 
possible the connection could drop shortly enough after being 
established that you don’t have time to apply the option, so it won’t 
come back up automatically. MySQL 5.1.6+ fixes this by allowing this 
option to be set before the connection is established."