Microsoft JDBC Driver for SQL Server

JDBC Tutorials - Herong's Tutorial Examples - Version 3.03, by Dr. Herong Yang

JDBC Tutorials - Herong's Tutorial Examples

∟Microsoft JDBC Driver for SQL Server - sqljdbc42.jar

This chapter provides tutorial notes on sqljdbc42.jar, JDBC Driver 4.2 produced by Microsoft for SQL Server 2014. Topics include downloading and installing Microsoft JDBC Driver 4.2; loading sqljdbc42.jar; creating a connection to SQL Server with port number, instance name and database name; closing a connection.

Installing Microsoft JDBC Driver for SQL Server

Loading Driver Class Automatically

Loading Driver Class with Class.forName()

DriverManager.getConnection() and Connection URL

Enabling TCP/IP with SQL Server Configuration Manager

Specifying Port Number in Connection URL

Instance Name Better than Port Number

Specifying Instance Name in Connection URL

Closing the Database Connection - con.close()

Specifying Database Name in Connection URL

Incorrect Database Name in Connection URL

Creating Connections with DataSource Class

Conclusion:

Microsoft offers a free JDBC driver for accessing MS SQL Server databases. The current version is JDBC Driver 4.2.
The connection URL for the Microsoft JDBC driver is "jdbc:sqlserver://server_name:port;database=name;user=login;password=****".
By default, the TCP/IP protocol is disabled on SQL Server instances.
You can enable the TCP/IP protocol on a SQL Server instance with SQL Server 2014 Configuration Manager. It will use a dynamic port number, like 60782, which will not match the default port number used in the JDBC Driver.
You can enable the SQL Server Browser service and use instance number instead of port number in the connection URL for a specific database instance.