This project has moved. For the latest updates, please go here.

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

Install Java DBC Driver

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.

Java DBC Driver home page See SQL Server 2012 Feature Pack home page http://www.microsoft.com/download/en/details.aspx?id=29065
Java DBC Driver download 4.1 http://go.microsoft.com/fwlink/?LinkID=239639
Java DBC Driver tutorial http://www.tutorialized.com/view/tutorial/JDBC-Tutorial/23975 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:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL 2016
SetupJavaDBC FULL Yes Yes Yes Yes Yes Yes
SetupJavaDBC WORKSTATION Yes Yes Yes Yes Yes Yes
SetupJavaDBC CLIENT N/A N/A N/A N/A N/A 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:

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 Java DBC V4.

Install Java DBC Driver

This process only needs to be processed once for each server.

1) Navigate to the Additional Components folder and double-click on
sqljdbc_4.0.2206.100_enu.exe.
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.
JavaDBC Unzip.png
All files are unzipped. Click OK to continue, then click Close on the Winzip Self-Extractor window.
JavaDBC Extract.png
3) Navigate to E:\Program Files\Microsoft SQL Server\JDBC Driver\sqljdbc_4.0\enu\xa
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.
JavaDBC Copy.png
5) Navigate to E:\Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\Binn and select Paste.
JavaDBC Paste.png

Setup Java DBC Help Menu Item

The Java DBC Help menu item is only installed 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.
JavaDBC HelpCopy.png
2) Navigate to the SQL Server Documentation menu folder on C: and select Paste Shortcut.
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.

A) 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.

B) 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 - 2016. License and Acknowledgements
Previous Install SQL Best Practice Analyzer Top Install OLE Provider for DB2 Next

Last edited Oct 17, 2016 at 9:30 AM by EdVassie, version 34