Azure SQL Database libraries for Java
Overview
Azure SQL Database is a relational database service using the Microsoft SQL Server engine that supports table, JSON, spatial, and XML data.
To get started with Azure SQL Database, see Azure SQL Database: Use Java to connect and query data.
Client JDBC driver
Connect to Azure SQL Database from your applications using the SQL Database JDBC driver. You can use the Java JDBC API to directly connect with the database or use data access frameworks that interact with the database through JDBC such as Hibernate.
Add a dependency to your Maven pom.xml
file to use the client JDBC driver in your project.
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.2.1.jre8</version>
</dependency>
Example
Connect to SQL database and select all records in a table using JDBC.
String connectionString = "jdbc:sqlserver://fabrikam.database.windows.net:1433;database=fiber;user=raisa;password=testpass;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";
try {
Connection conn = DriverManager.getConnection(connectionString);
Statement statement = conn.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM SALES");
}
Resource Management
Create and manage Azure SQL Database resources in your subscription with the Java resource management libraries.
Add a dependency to your Maven pom.xml
file to use the resource management libraries in your project.
<dependency>
<groupId>com.azure.resourcemanager</groupId>
<artifactId>azure-resourcemanager</artifactId>
<version>2.1.0</version>
</dependency>
For detailed information on how to use the Java resource management libraries, please refer to this doc
Example
Create a SQL Database resource and restrict access to a range of IP addresses using a firewall rule.
SqlServer server = azureResourceManager.sqlServers().define(sqlDbName)
.withRegion(Region.US_EAST)
.withNewResourceGroup(resourceGroupName)
.withAdministratorLogin(adminLogin)
.withAdministratorPassword(adminPass)
.defineFirewallRule(firewallRuleName)
.withIpAddressRange("172.16.0.0", "172.31.255.255")
.attach()
.create();
Samples
Azure SQL resources
Configure Azure SQL Database with the management API
Deploy WordPress powered by SQL Database
Scale SQL Database across multiple Azure regions
Manage shared SQL database workloads with elastic pools
Explore more sample Java code for Azure SQL Database you can use in your apps.
Azure SDK for Java