MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Can you create a MySQL JDBC connection string that has different hosts but the same port?
Posted by: Filipe Silva
Date: October 09, 2017 11:46AM

This shouldn't be a problem.

Probably you are getting a timeout from your web server while waiting to establish a connection to the database. You should at least add the connection properties "socketTimeout=1000" and "retriesAllDown=3" or some other low values. The defaults are too high for the situation where no server is listening in any of the pointed ports; those would result endless waits and each server would be tested 120 times before actually failing to get a connection.

So, my guess is that you don't have any server listening in any of the hosts. If that's not the case, can you paste the stack trace from the error you're getting?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Can you create a MySQL JDBC connection string that has different hosts but the same port?
Mike Love
October 05, 2017 02:03PM
Re: Can you create a MySQL JDBC connection string that has different hosts but the same port?
Filipe Silva
October 09, 2017 11:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.