Skip to content

improving-performance-and-reliability-with-the-jdbc-driver.md

Latest commit

 

History

History
38 lines (30 loc) · 2.93 KB

improving-performance-and-reliability-with-the-jdbc-driver.md

File metadata and controls

38 lines (30 loc) · 2.93 KB
title Improving performance and reliability
description Learn about various techniques for improving application performance and reliability when using the Microsoft JDBC driver for SQL Server.
author David-Engel
ms.author davidengel
ms.date 03/13/2026
ms.service sql
ms.subservice connectivity
ms.topic concept-article

Improving performance and reliability (JDBC)

[!INCLUDEDriver_JDBC_Download]

One aspect of application development that's common to all applications is the constant need to improve performance and reliability. There are many techniques to satisfy this need with the [!INCLUDEjdbcNoVersion].

The articles in this section describe various techniques for improving application performance and reliability when using the JDBC driver.

In this section

Article Description
Understanding timeout properties Describes the timeouts used by the JDBC driver.
Closing objects when not in use Describes the importance of closing JDBC driver objects when they're no longer needed.
Managing transaction size Describes techniques for improving transaction performance.
Working with statements and result sets Describes techniques for improving performance when using the Statement or ResultSet objects.
Using adaptive buffering Describes an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors.
Sparse columns Discusses the JDBC driver's support for [!INCLUDEssNoVersion] sparse columns.
Prepared statement metadata caching for the JDBC driver Discusses the techniques for improving performance with prepared statement queries.
Prepared statement parameter performance Discusses practices and settings to consider when using prepared statements.
Using bulk copy API for batch insert operation Describes how to enable Bulk Copy API for batch insert operations and its benefits.
Not sending String parameters as Unicode When you're working with CHAR, VARCHAR, and LONGVARCHAR data, set the connection property sendStringParametersAsUnicode to false for optimal performance gain.
Performance Logger and callback Describes how to use the performance logging framework and callback infrastructure to track execution timing for critical driver operations such as connections, prelogin, login, and token acquisition.

See also

Overview of the JDBC driver