Install Java DBC Driver - SQL-FineBuild/Common GitHub Wiki

Previous Install SQL Best Practice Analyzer Manual Install Install OLE Provider for DB2 Next

FineBuild can install and configure the Java DBC Driver as part of the SQL Server install process. If you do not want to include Java DBC Driver in your FineBuild install, then do not download it.

Java DBC Driver is written by Microsoft. It was chosen to be included in FineBuild because it allows Java applications to access SQL Server.

Item Location
Java DBC Driver home page See SQL Server Feature Pack home page https://docs.microsoft.com/en-us/sql/tools/download-sql-feature-packs
Java DBC Driver download 8.4 https://docs.microsoft.com/en-gb/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server
Java DBC Driver tutorial https://www.javatpoint.com/java-jdbc Note that this tutorial is generic and some class names may be different from those in the Microsoft Java DBC driver.

FineBuild Java DBC Driver Install

Automated silent installation of Java DBC Driver is performed by Process Id 4SB and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupJavaDBC: Yes Yes N/A
SQL2017 /SetupJavaDBC: Yes Yes N/A
SQL2016 /SetupJavaDBC: Yes Yes N/A
SQL2014 /SetupJavaDBC: Yes Yes N/A
SQL2012 /SetupJavaDBC: Yes Yes N/A
SQL2008R2 /SetupJavaDBC: Yes Yes N/A
SQL2008 /SetupJavaDBC: Yes Yes N/A
SQL2005 /SetupJavaDBC: Yes Yes N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstJavaDBC: can also be used.

FineBuild also uses the following parameters to help install Java DBC Driver:

Parameter Default Value Description
/Javaexe: sqljdbc_4.1.5605.100_enu.exe Name of Java DBC Driver install file

The FineBuild install for Java DBC Driver includes the following:

Top

Manual Java DBC Driver Install

The following steps show what you would have to do to install Java DBC Driver manually. FineBuild does all of this work for you automatically.

The screenshots relate to Java DBC V2, but the same process applies to other Java DBC versions.

Install Java DBC Driver

This process should only be processed once for each server.

  1. Navigate to the Additional Components folder

    Double-click on sqljdbc_4.0.2206.100_enu.exe

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Explorer.png)

  2. The Winzip Self-Extractor window is displayed

    Set the Unzip folder to E:\Program Files\Microsoft SQL Server\JDBC Driver then click Unzip

    ![Unzip](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Unzip.png)

    All files are unzipped. Click OK to continue, then click Close on the Winzip Self-Extractor window

    ![Extract](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Extract.png)

  3. Navigate to "E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\enu\xa"

    ![Select](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Select.png)

  4. For a 32-bit server, click on the X86 folder, otherwise click on the X64 folder

    Right-click on sqljdbc_xa.dll and select Copy

    ![Copy](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Copy.png)

  5. Navigate to E:\Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\Binn

    Select Paste

    ![Paste](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC Paste.png)

Setup Java DBC Help Menu Item

The Java DBC Help menu item is only installed for Java DBC V3 or lower, and only if the /SetupSQLTools: parameter is set to YES. This process only needs to be processed once for each server.

  1. Navigate to E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\help

    Right-click on default.htm and select Copy

    ![Copy Help](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC HelpCopy.png)

  2. Navigate to the SQL Server Documentation menu folder on C:

    Select Paste Shortcut

    ![Paste Help](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/Java DBC Driver/JavaDBC HelpPaste.png)

  3. Rename the menu shortcut to Java DBC Help

Configure Java DBC XPs

This process must be processed once for each SQL Server instance.

The Java DBC XPs can be configured either by using SQLCMD or within SQL Management Studio.

  1. If using SQLCMD:

    Execute the xa_install.sql script found at E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\enu\xa to install the Java DBC XPs on to SQL Server instance

  2. If using SSMS:

    Run the SQL script xa_install.sql found at E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\enu\xa

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install SQL Best Practice Analyzer Top Install OLE Provider for DB2 Next