Improving Performance and Reliability with the 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 SQL Server 2005 JDBC Driver.

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

In This Section

Topic Description

Closing Objects when Not In Use

Describes the importance of closing JDBC driver objects when they are 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, which is a new feature of the Microsoft SQL Server 2005 JDBC Driver version 1.2. This feature is designed to retrieve any kind of large-value data without the overhead of server cursors.

See Also

Other Resources

Overview of the JDBC Driver