3

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?

Eddie Chen - MSFT
  • 29,708
  • 2
  • 46
  • 60
Eric_Zhang
  • 85
  • 5
  • 1
    Have you created an instance? Should provide you with a connection string. And yes, existing drivers should "just work." – David Makogon May 10 '17 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 May 10 '17 at 17:41

2 Answers2

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:

connection strings in portal

David Makogon
  • 69,407
  • 21
  • 141
  • 189
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

Satya_MSFT
  • 1,024
  • 6
  • 10