Connecting to SQL Server with the JDBC driver
One of the most fundamental things that you'll do with the Microsoft JDBC Driver for SQL Server 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.
If a SQL Server is only listening on an IPv6 port, set the java.net.preferIPv6Addresses system property to make sure that IPv6 is used instead of IPv4 to connect to the SQL Server:
System.setProperty("java.net.preferIPv6Addresses", "true");
The articles in this section describe how to make and work with a connection to a SQL Server database.
In this section
| Article | 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 Java Platform, Enterprise Edition (Java EE) 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. |
| JDBC driver support for High Availability, disaster recovery | Describes how to develop an application that will connect to an Always On availability group. |
| Using Kerberos Integrated Authentication to Connect to SQL Server | Discusses a Java implementation for applications to connect to a SQL Server database using Kerberos integrated authentication. |
| Connecting to an Azure SQL database | Discusses connectivity issues for databases on Azure SQL. |