Understanding the JDBC Driver Data Types


DownloadDownload JDBC Driver

Microsoft JDBC Driver for SQL Server 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.

Using Basic Data TypesDescribes the JDBC basic data types. Includes examples of how to work with the data types by using result sets, parameterized queries, and stored procedures.
Configuring How java.sql.Time Values are Sent to the ServerDescribes how the JDBC Driver generates dates.
Using Advanced Data TypesDescribes the JDBC advanced data types.
Understanding Data Type DifferencesDescribes differences between the various JDBC driver data types.
Understanding Data Type ConversionsDescribes how data type conversion is handled when using getter and setter methods.
National Character Set SupportDescribes the support for the national character set types.
Supporting XML DataDescribes the SQLXML interface. Also describes how to read and write an XML data from and to the relational database with the SQLXML Java data type.
Wrappers and InterfacesDiscusses the interfaces that have the Microsoft JDBC Driver for SQL Server specific methods and constants that allow an application server to create a proxy of the class, Also discusses supports for the the java.sql.Wrapper interface.

Overview of the JDBC Driver

Community Additions