From: Warren Young
Date: September 26 2006 7:43am
Subject: Re: Aparent connection lost resulting in crash
List-Archive: http://lists.mysql.com/plusplus/5966
Message-Id: <4518DA06.7040407@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Julien Chavanton wrote:
> Thank you, I do not find the C API mailing list in
> http://lists.mysql.com/

There is no separate list.  C API issues are handled on the main MySQL list.

> Also the same "problem" exists while using Mysql++ how shall we deal
> with connection lost exactly?

Presumably you're using 5.0, which apparently has a feature to drop idle 
connections.  (This question has been coming up a lot lately....)  If 
so, turn on the connection retry option.  Search the list...it's come up 
twice recently.

I don't know how the library could deal with this any better than it 
already does.  That's not to say that it's nice...it's just that a 
network connection failure is a pretty serious thing.  MySQL++ itself 
doesn't have the knowledge to do anything more than just ask the C API 
to retry the connection, and throwing an exception is probably 
excessive.  Ideas solicited.