Export (0) Print
Expand All
5 out of 10 rated this helpful - Rate this topic

Deploying the JDBC Driver

When you deploy an application that depends on the Microsoft JDBC Driver for SQL Server, you must redistribute the JDBC driver together with your application. Unlike Windows Data Access Components (Windows DAC), which is a component of the Windows operating system, the JDBC driver is considered to be a component of SQL Server.

Note Note

Although you can freely distribute the JDBC driver as your application requires, you must first register to do this. To register to redistribute the JDBC driver, see Register for Microsoft JDBC Driver for SQL Server Redistribution Rights.

There are two approaches to deploying the JDBC driver with your application. One is to include the JDBC driver files as part of your own custom installation package. The second approach involves using the JDBC installation package provided by Microsoft, which you can download from the Microsoft JDBC Driver for SQL Server Developer Center.

The following sections discuss how to use the JDBC installation package on Windows and UNIX operating systems.

Note Note

For information about deploying Java applications in general, see the Java website.

When you deploy the JDBC driver on Windows operating systems, you must use the executable zip file version of the installation package, which is typically named sqljdbc_<version>_<language>.exe.

To run the executable zip file silently, you must use the /auto command-line option on the command line or in a batch file as in the following:

sqljdbc_<version>_<language>.exe /auto

Note Note

When you use the /auto option it is not a truly silent installation, as a WinZip dialog box still appears on the user's screen. However, you will not need to interact with it and it closes as soon as the unzip operation is complete.

When you deploy the JDBC driver on UNIX operating systems, you must use the gzip file version of the installation package, which is typically named sqljdbc_<version>_<language>.tar.gz.

Before you install the JDBC driver, make sure that both the gzip and tar utilities are installed on the user's system, and that the folders that contain the executables for both utilities are added to the PATH environment variable.

To unpack the zipped tar file, navigate to the directory where you want the driver unpacked and type the following command:

gzip -d sqljdbc_<version>_<language>.tar.gz

To unpack the tar file, move it to the directory where you want the driver installed and type the following command:

tar –xf sqljdbc_<version>_<language>.tar

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.