I have a daemon running 24/7 that uses the mysql++ package to connect to my
database. It works great but after it passes the wait_timeout of the server
it, of course, spits out a "MYSQL SERVER HAS GONE AWAY".

My question is what is the correct way to deal with this? Is there some
option I am not seeing that will make the daemon reconnect to the db if it
fails? Or should I put a timer in my code that "pings" the database
occasionally to keep the connection open?

Any ideas are appreciated.

Thanks,
Bryan


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

We have the same issue so I am also curious what the recommended approach
is.


Bruce




--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Think I figured it out.

m_db_conn = new Connection( db_name, host, username, pw, port);
if(m_db_conn->connected())
{
m_db_conn->set_option(Connection::Option:pt_reconnect, true);
}






--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

------_=_NextPart_001_01C6DCBC.A12ECB9E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

=20
=20
=20
This is interesting however; it seems like this solution uses an
abstraction of Mysql++ API?
Can you provide the equivalent C API function call to Mysql++
=20
=20
=20
=20
=20
=20


------_=_NextPart_001_01C6DCBC.A12ECB9E--

I think it depends which version of MySQL you're using, but the MySQL API in
5.1 is mysql_options:
http://dev.mysql.com/doc/refman/5.1/...l-options.html. This is the API
that the version of Mysql++ I have uses for implementing
Connection::set_option().

Pre version 5, I don't think there was a reconnect option for this API;
however, according to the 4.1 docs the reconnect flag is kept in the MYSQL
structure and is set automatically by mysql_real_connect.


-----Original Message-----
From: Julien Chavanton [mailto:jc (AT) atlastelecom (DOT) com]
Sent: 20 September 2006 14:57
To: plusplus (AT) lists (DOT) mysql.com
Subject: RE: Daemon passes wait_timeout and gets "MYSQL SERVER HAS GONE
AWAY"




This is interesting however; it seems like this solution uses an abstraction
of Mysql++ API?
Can you provide the equivalent C API function call to Mysql++









--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw