5 messages in com.mysql.lists.javaRe: autoReconnect, host ports
FromSent OnAttachments
Gorazd Golob29 Jun 2004 03:20 
Mark Matthews29 Jun 2004 07:33 
Gorazd Golob29 Jun 2004 07:54 
Gorazd Golob29 Jun 2004 09:25 
Mark Matthews29 Jun 2004 12:50 
Subject:Re: autoReconnect, host ports
From:Mark Matthews (ma@mysql.com)
Date:06/29/2004 07:33:33 AM
List:com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Gorazd Golob wrote:

Hi!

Whem I'm using failover hosts I have problems, when using AutoReconnect=true - for example if a host1 fail during established connection, I get exeption - driver don't figure itself that host1 is down and stop working (don't connect to host2). Even if I do a new connection and host1 is still down, driver won't go to host2. Without using autoReconnect it's working - It does not reconnect to host2 during session, but when you make new connection - it figures out that host1 is down and connects to host2.

Second issue - if you are using jdbc with one host and you specify another port - it's working. But if you specify two hosts like host1,host2:<port> it ignores port number and is trying to connect to default mysql port - - 3306.

Thanks, bye, gorazd

You don't state what version of the driver you're using. Before 3.0.12, you could only specify _one_ port number, and only on the first host.

Also, what state is autoCommit in when the host goes down? Re-connection won't happen until autoCommit == true.

-Mark

- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com

MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA4X3StvXNTca6JD8RAuzSAJ9eyYI1ipjMf0hGd6c/fPts5xigXwCfZ6M3 LfI/JcPbET9jL60hrK+Bogk= =pNjC -----END PGP SIGNATURE-----