Query Azure SQL DB through API using Java

Question

I am trying to access Azure SQL Database , using java. Our code will be staying in MS Appcenter. Since the DB firewall is not letting the Appcenter to access the database, I am trying to use API. Can someone help me provide me steps / sample code to get it started?

please ref:Quickstart: Use Java to query a database in Azure SQL Database or Azure SQL Managed Instance. Is this you want? — Leon Yue
– Leon Yue, Commented Jun 18, 2020 at 5:30
Did you set Allow Azure services and resources to access this server on in SQL database filrewall? — Leon Yue
– Leon Yue, Commented Jun 18, 2020 at 5:33

Atul · Accepted Answer · 2020-06-18 11:31:37Z

1

You will need to enable firewall of Azure SQL Database to allow connection from azure (as you are hosting it in the MS Appcenter). In order to do that read document
Once that is enabled, you can use documentation Quickstart to see how you can connect from it from application. Above document is in java language but you can find similar document for other languages also.

answered Jun 18, 2020 at 11:31

Atul

1,1512 gold badges10 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Query Azure SQL DB through API using Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related