How to connect to the Azure database for MySQL and PostgreSQL in JAVA

Question

There're just two new Azure Services released， Azure Database for MySQL and PostgreSQL, As a Java developer I'm wondering how to connect to them, Shall the regular JDBC drivers still work?

Have you created an instance? Should provide you with a connection string. And yes, existing drivers should "just work." — David Makogon
– David Makogon, Commented May 10, 2017 at 17:07
FYI - this was initially closed as duplicate, but it's not a duplicate: This question is about Azure's brand new (announced an hour ago) MySQL and Postgres as-a-service offerings. Has nothing to do with the prior question that was posted. — David Makogon
– David Makogon, Commented May 10, 2017 at 17:41

David Makogon · Accepted Answer · 2017-05-10 17:21:19Z

6

MySQL and Postgres as-a-service are accessed with already-existing drivers/sdk's. Just get the connection string from the portal, and then connect.

You'll see all of your connection strings in the portal, after your database instance is created:

answered May 10, 2017 at 17:21

David Makogon

71k22 gold badges145 silver badges204 bronze badges

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

Comments

Satya_MSFT · Accepted Answer · 2017-05-15 06:03:47Z

1

Yes, it works except that you have to append @ to the user name portion of the connection string.

jdbc:postgresql://servername.postgres.database.azure.com:5432/{your_database}?user=@servername&password={your_password}&ssl=true

answered May 15, 2017 at 6:03

Satya_MSFT

1,0226 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to connect to the Azure database for MySQL and PostgreSQL in JAVA

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related