This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.
To connect to Azure SQL Database we could use multiple tools or coding languages like C#, PHP, Java, etc.. In some situations, we need to test our application, for example, how much time take a single connection, review my retry-logic, review the connection, etc..
In this URL you could find an example about several operations that you could use using JAVA.
This application has been designed with a main idea: how to obtain information about the elapsed time in the connectivity process and the query execution to a database of Azure SQL Database using JAVA (Microsoft JDBC Driver for SQL Server). This JAVA console script runs in Windows and Linux.
This JAVA console script has the main features:
- Connect using Microsoft JDBC Driver for SQL Server measuring the time spent.
- Once you have established the connection runs multiple times the query SELECT 1 measuring the time spent.
You could find the instrucctions in readme file.
As always, all feedback and contributions are very welcome.
Enjoy!