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:
The topics in this section describe how to make and work with a connection to a SQL Server database.
In this section
|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 AlwaysOn 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.|