Connecting to SQL Server with the JDBC Driver

One of the most fundamental things that you will do with the Microsoft SQL Server 2005 JDBC Driver is to make a connection to a SQL Server database. All interaction with the database occurs through the SQLServerConnection object, and because the JDBC driver has such a flat architecture, almost all interesting behavior touches the SQLServerConnection object.

The topics in this section describe how to make and work with a connection to a SQL Server database.

In This Section

Topic	Description
Building the Connection URL	Describes how to form a connection URL for connecting to a SQL Server database. Also describes connecting to named instances of a SQL Server database.
Setting the Connection Properties	Describes the various connection properties and how they can be used when you connect to a SQL Server database.
Setting the Data Source Properties	Describes how to use data sources in a J2EE environment.
Working with a Connection	Describes the various ways in which to create an instance of a connection to a SQL Server database.
Using Connection Pooling	Describes how the JDBC driver supports the use of connection pooling.
Using Database Mirroring (JDBC)	Describes how the JDBC driver supports the use of database mirroring.

See Also

Other Resources

Overview of the JDBC Driver