Early Technical Preview of JDBC Driver 12.3.0 for SQL Server
Introduction
The Microsoft JDBC Driver for SQL Server has released its technical preview of version 12.3.0. This release includes significant enhancements to improve the performance, scalability, and security of applications that use the driver. As the name implies, this release is a “technical preview” version, meaning that it is a pre-release version of the driver and is not yet suitable for production use. In this blog post, we’ll take a closer look at the features included in this release and discuss the most popular questions related to it.Overview of the Driver
The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) driver that provides access to SQL Server databases from Java applications. The driver supports the latest versions of SQL Server, including Azure SQL Database, Azure SQL Data Warehouse, and Azure SQL Managed Instance. It is compliant with the JDBC 4.2 specification and is available for both Java 7 and Java 8.What’s New in Version 12.3.0?
Version 12.3.0 of the JDBC Driver for SQL Server includes significant enhancements to improve the performance, scalability, and security of applications that use the driver. These include: * Support for SQL Server 2019
* Support for Azure Active Directory authentication
* Improved connection pooling
* Improved performance when executing queries and stored procedures
* Support for encrypted connections (TLS 1.2)
* Support for Azure Key Vault
* Improved support for Java 8
Popular Questions
1. Is the JDBC Driver compatible with Java 7?
Yes, the JDBC Driver is compatible with Java 7. It is also compatible with Java 8, and includes improved support for Java 8.2. Does the driver support Azure Key Vault?
Yes, the driver supports Azure Key Vault, which provides secure storage for application secrets.3. How do I connect to SQL Server using the driver?
You can connect to SQL Server using the driver by using the driver’s Connection URL. The Connection URL includes the server name, port number, and database name. For example, to connect to a SQL Server database named “mydb” on the server “myserver.database.windows.net” on port 1433, you would use the following Connection URL: jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=mydb;4. Does the driver support encrypted connections?
Yes, the driver supports encrypted connections via TLS 1.2.5. Does the driver support connection pooling?
Yes, the driver supports connection pooling, which can improve the performance of applications that use the driver.Conclusion
The JDBC Driver for SQL Server has released its technical preview of version 12.3.0, which includes significant enhancements to improve the performance, scalability, and security of applications that use the driver. This release is a “technical preview” version, meaning that it is a pre-release version of the driver and is not yet suitable for production use. In this blog post, we discussed the features included in this release and the popular questions related to it.
