Download and Install SQL Server JDBC Driver

JSP Tutorials - Herong's Tutorial Examples

∟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