Install Java DBC Driver
| 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. |
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:
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.
This process should only be processed once for each server.
-
Navigate to the Additional Components folder
Double-click on sqljdbc_4.0.2206.100_enu.exe
-
The Winzip Self-Extractor window is displayed
Set the Unzip folder to E:\Program Files\Microsoft SQL Server\JDBC Driver then click Unzip
All files are unzipped. Click OK to continue, then click Close on the Winzip Self-Extractor window
-
Navigate to "E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\enu\xa"
-
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
-
Navigate to E:\Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\Binn
Select Paste
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.
-
Navigate to E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\help
Right-click on default.htm and select Copy
-
Navigate to the SQL Server Documentation menu folder on C:
Select Paste Shortcut
-
Rename the menu shortcut to Java DBC Help
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.
-
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
-
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 |
|---|