Download JDBC driver

Most JDBC drivers can be obtained for free. This section describes how to download the appropriate JDBC drivers for Microsoft SQL Server, Oracle, and MySql servers.

Microsoft JDBC driver for SQL Server 2000 is free if you have licensed the SQL server databases. You can download the driver files from Microsoft download site.

http://www.microsoft.com/downloads

There is a keyword search feature available at the download site, and the links for the JDBC driver can be located by conducting a search by the keyword “JDBC”. Once the download page is found, download the driver setup file and install it on your local computer. The following driver files can be found in the “lib” directory of the JDBC driver’s installation directory:

msbase.jar, mssqlserver.jar, and msutil.jar

 

The Oracle driver is also free if you have licensed the Oracle databases. You can download the driver files directly from Oracle website at:

http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html

These driver files are also available when you install Oracle database clients. They are located in “$ORACLE_HOME\jdbc\lib” directory.

Oracle drivers consist of many files. The only files needed are “class12.jar”, and “nls_charset12.zip”.

 

MySql is an open source database. You can download the driver files directly from MySql website at:

http://www.mysql.com/products/connector/j/

The drivers are packaged in a zip file. After downloading and unzipping the file, you should get the driver file something like this:

mysql-connector-java-3.1.12-bin.jar