Re: [Quickfix-developers] MySQL

[Bill R. <rob...@ra...>]

That's right. With R 5.0 the default behaviour changed. We need to add
something like

    if( !mysql_real_connect
      ( m_pConnection, m_connectionID.getHost().c_str(),
m_connectionID.getUser().c_str(),=20
        m_connectionID.getPassword().c_str(),
m_connectionID.getDatabase().c_str(), port, 0, 0 ) )
    {
        if( !connected() )
          throw ConfigError( "Unable to connect to database" );
    }
#if ( MYSQL_VERSION_ID > 50000)
    my_bool reconnect =3D 1;
    mysql_options(dbms, MYSQL_OPT_RECONNECT,
static_cast<char*>(&reconnect));
#endif


to the MySQLConnection class in the private function connect(). With
that reconnection works again.

Regards,
Robert


=20

> -----Original Message-----
> From: qui...@li...=20
> [mailto:qui...@li...] On=20
> Behalf Of Alexey Zubko
> Sent: Monday, July 03, 2006 9:17 PM
> To: qui...@li...
> Subject: [Quickfix-developers] MySQL
>=20
> QuickFIX Documentation:=20
> http://www.quickfixengine.org/quickfix/doc/html/index.html
> QuickFIX Support: http://www.quickfixengine.org/services.html
>=20
> Hello,
>=20
> I want to use MySQL as a message store and expected that QF=20
> automatically reconnect in case of error (there is code at least).
>=20
> I found out that for MySQL 5.0 I use it's necessary to set=20
> this parameters explicitly (see the Users comments):
> http://dev.mysql.com/doc/refman/5.0/en/mysql-ping.html
>=20
> Am I understand correct, is it necessary to fix the=20
> MySQLConnection class or there is another way?
>=20
> Thank you in advance.
>=20
> --
> Regards,
> 		Alexey Zubko
>=20
>=20
> Using Tomcat but need to do more? Need to support web=20
> services, security?
> Get stuff done quickly with pre-integrated technology to make=20
> your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on=20
> Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&
dat=3D121642
> _______________________________________________
> Quickfix-developers mailing list
> Qui...@li...
> https://lists.sourceforge.net/lists/listinfo/quickfix-developers
>=20