JSP Tutorials - Herong's Tutorial Examples - v5.11, by Herong Yang
Download and Install SQL Server JDBC Driver
This section provides a tutorial example on how to download and install the SQL Server JDBC driver from Microsoft Website.
Since I am running JVM 13 which is not officially supported yet by Microsoft, so I downloaded the latest version, 7.4, of the SQL Server JDBC driver to try it out.
1. Go to "Microsoft JDBC Driver 7.4 for SQL Server" page at https://www.microsoft.com/en-us/download/details.aspx?id=58505.
2. Select "English" as the language and click "Download". And save the downloaded file as sqljdbc_7.4.1.0_enu.tar.gz
3. Unzip and untar the downloaded file:
herong$ gunzip sqljdbc_7.4.1.0_enu.tar.gz herong$ tar -xf sqljdbc_7.4.1.0_enu.tar
4. Verify JDBC driver jar files:
herong$ ls -l sqljdbc_7.4/enu/ 136 Jan 2 19:03 auth 1178 Aug 3 05:49 install.txt 8806 Aug 3 05:49 license.txt 13001033 Aug 3 05:49 mssql-jdbc-7.4.1.jre11-shaded.jar 1219373 Aug 3 05:49 mssql-jdbc-7.4.1.jre11.jar 13001069 Aug 3 05:49 mssql-jdbc-7.4.1.jre12-shaded.jar 1219384 Aug 3 05:49 mssql-jdbc-7.4.1.jre12.jar 12991268 Aug 3 05:49 mssql-jdbc-7.4.1.jre8-shaded.jar 1209659 Aug 3 05:49 mssql-jdbc-7.4.1.jre8.jar 15377 Aug 3 05:49 release.txt 374 Jan 2 19:03 samples 12563 Aug 3 05:49 thirdpartynotices.txt 170 Jan 2 19:03 xa
5. Create the "WEB-INF/lib" and install the JRE 12 version. Make sure them have "read" permissions for all users.
herong$ mkdir /Library/Tomcat/apache-tomcat-9.0.26/webapps/herong/WEB-INF/lib herong$ cp sqljdbc_7.4/enu/mssql-jdbc-7.4.1.jre12.jar \ /Library/Tomcat/apache-tomcat-9.0.26/webapps/herong/WEB-INF/lib
See the next tutorial on how to create a Java program to test the JDBC driver with my SQL Server database.
Table of Contents
JSP (JavaServer Pages) Overview
Tomcat Installation on Windows Systems
Syntax of JSP Pages and JSP Documents
JavaBean Objects and "useBean" Action Elements
Managing HTTP Response Header Lines
Non-ASCII Characters Support in JSP Pages
Overview of JSTL (JSP Standard Tag Libraries)
Multiple Tags Working Together
Using Tomcat on CentOS Systems
►Connecting to SQL Server from Servlet
SQL Server Connection Requirements
►Download and Install SQL Server JDBC Driver
Load JDBC Driver Class in Servlet