From: Warren Young
Date: November 25 2009 5:50pm
Subject: Re: set_option ( ReconnectOption )
List-Archive: http://lists.mysql.com/plusplus/8780
Message-Id: <4B0D6E79.2030300@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Dino Korah wrote:
> 
> I am working with 3.0.9 and there seems to be no way I can effectively 
> use it to reconnect in scenario where I need to run a set of SQLs to 
> setup the connection for real use in my application. They are mostly 
> session variables meant for auto_increment.

It is not clear to me what your problem actually is.  Why does it matter 
what SQL you're using?  How does that affect connection management?  Why 
do you need to reconnect in the first place?

ReconnectOption exists to make the underlying C API library try to 
reconnect to the DB server if our connection to it gets dropped without 
the client's asking for it.  That's why it's just a boolean option: yes 
enable this feature, or no don't do this.