Connecting MySQL Azure with Java

Question

I am facing an issue to connect to azure MySQL database with Java. Though whenever I am connecting with same database with MySQL workbench the connection working as expected.

To connect the same I tried below codes where used both of the url string mentioned.

Class.forName("com.mysql.jdbc.Driver");
// String url = "jdbc:mysql://***-mysqldbserver.mysql.database.azure.com:3306/medilegaldb?autoReconnect=true";
String url ="jdbc:mysql://***-mysqldbserver.mysql.database.azure.com:3306/medilegaldb?useSSL=true&requireSSL=false";
Connection con = DriverManager.getConnection(url, "user", "pass");

Need help to identify the issue.

Did you open up port 3306 in both directions on your Azure instance? You'll need to do that in order for your MySQL instance to be reachable from the outside. And of course, please verify that you are using the right credentials. — Tim Biegeleisen
– Tim Biegeleisen, Commented Nov 1, 2018 at 5:20
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure - This is the error I m getting. Also about credentials I am using the same configuration when connecting though workbench and everything working. — Souvik
– Souvik, Commented Nov 1, 2018 at 6:01
Problem I am getting is only with the Java configuration. Please suggest. — Souvik
– Souvik, Commented Nov 1, 2018 at 6:26
This problem is specific to mysql jar file. Now it's resolved. — Souvik
– Souvik, Commented Nov 1, 2018 at 9:07

caiyi Ju · Accepted Answer · 2018-11-01 07:38:27Z

5

Which version of MySQL-connector-java did you use? I used 5.1.6 and encountered the same error. But if I use 5.1.31, it works. Please let me know if this fix your issue.

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.31</version>
    </dependency>

edited Nov 1, 2018 at 7:38

answered Nov 1, 2018 at 7:33

caiyi Ju

15.8k3 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Souvik Over a year ago

Yes. This works fine for me. Thanks for the quick help.

Deep Shah Over a year ago

can u please give a specific reason on this issue, as I have also facing the same

Collectives™ on Stack Overflow

Connecting MySQL Azure with Java

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related