Improving Performance and Reliability with the JDBC Driver


DownloadDownload JDBC Driver

One aspect of application development that is common to all applications is the constant need to improve performance and reliability. There are a number of techniques for doing this with the Microsoft JDBC Driver for SQL Server.

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

Closing Objects when Not In UseDescribes the importance of closing JDBC driver objects when they are no longer needed.
Managing Transaction SizeDescribes techniques for improving transaction performance.
Working with Statements and Result SetsDescribes techniques for improving performance when using the Statement or ResultSet objects.
Using Adaptive BufferingDescribes an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors.
Sparse ColumnsDiscusses the JDBC driver's support for SQL Server sparse columns.

Overview of the JDBC Driver

Community Additions