Microsoft SQL Server 2005 JDBC Driver supports the use of JDBC basic and advanced data types within a Java application that uses SQL Server as its database.

The JDBC type system mediates the conversion between SQL Server data types and Java language types and objects. The JDBC types are modeled on the SQL-92 and SQL-99 types. The JDBC driver adheres to the JDBC specification and is designed to provide the right balance between predictability and flexibility.

The topics in this section describe how to use the basic and advanced data types, and how data types can be converted into other data types.

In This Section

Topic Description

Using Basic Data Types

Describes the JDBC basic data types. Includes examples of how to work with the data types by using result sets, parameterized queries, and stored procedures.

Using Advanced Data Types

Describes the JDBC advanced data types.

Understanding Data Type Differences

Describes differences between the various JDBC driver data types.

Understanding Data Type Conversions

Describes how data type conversion is handled when using getter and setter methods.

See Also