Tech Blicks

In order for Java applications working with a database engine via Java Database Connectivity (JDBC) , an appropriate JDBC driver library is required to be available in the application’s classpath. A JDBC driver library consists of Java classes which implement low-level communication with the database engine. It talks with Java applications via JDBC API and usually bundled as a JAR or ZIP file.For reference, this article provides a summary of JDBC driver download for common databases including MySQL, SQL Server, Oracle, PostgreSQL, Apache Derby (Java DB) and SQLite. Click on a database name to go to download page of the appropriate JDBC driver library. Database Driver provider JAR file name Download size MySQL Oracle Corporation mysql-connector-java-3.0.17-ga-bin.jar 3.8 MB ~ 4.0 MB SQL Server Microsoft Corporation sqljdbc.jar, sqljdbc4.jar 2.3 MB ~ 4.2 MB Oracle Oracle Corporation jodbc5.jar, jodbc6.jar, … 1.2 MB ~ 4.2 MB PostgreSQL The PostgreSQL Global Development Group postgresql-9....

SQLite is a simple, small, fast, reliable, server-less, zero-configuration and no-installation SQL database library which is running in-process with the client application. Although there is no official JDBC driver library from www.sqlite.org , there is one provided by www.xerial.org – an XML Database Management System project. 1.    Download SQLite JDBC driver You can download the latest version of JDBC driver for SQLite here . The download is categorized by versions, so browse a directory for a specific version you want: 3.5.9, 3.6.16, 3.7.2, etc. As of this writing, the latest version is 3.7.2 which corresponds to the jar file sqlite-jdbc-3.7.2.jar.Beside Java class files, the jar file includes SQLite binaries for Windows, Linux and Mac (for both 32-bit and 64-bit).Place the sqlite-jdbc-VERSION.jar into your classpath. 2.    SQLite JDBC database connection URL The SQLite JDBC driver can load a SQLite database from file system or creates one in memory.Here is the syntax of database...

Apache Derby is a lightweight, portable database engine written purely in Java. Java DB is a just an Oracle’s distribution of Derby in their JDK.This article presents the steps to quickly get started with Derby, from downloading its JDBC driver to write code for making connections. 1.    Downloading Derby JDBC driver library Download the latest version of Derby here (as of this writing, the latest release is 10.9.1.0 ). The distribution includes the following pieces of software component: Component Jar files Embedded database engine and JDBC driver derby.jar Network client JDBC driver derbyclient.jar Network server derbynet.jar, derbyrun.jar Command line tools derbytools.jar Localization messages derbyLocale_xx_YY.jar If you are using JDK 1.7, then Derby is already included in JDK installation under the name Java DB in JDK_HOME\db directory. The jar files are located in JDK_HOME\db\lib directory.In both case, you have to place appropriate jar file to the classpath: derby.jar: f...

This tutorial walks through process of connecting a Java application to a PostgreSQL database server from downloading JDBC driver to write code that makes the connection. Before begin, make sure you have a version of PostgreSQL database server installed either on your development computer or on a dedicated server. Code in this tutorial is tested with PostgreSQL 9.1. 1.    Download PostgreSQL JDBC driver You can obtain the latest version of JDBC driver for PostgreSQL here . Currently there are two versions: JDBC3 Postgresql Driver : for JDK 1.4 and JDK 1.5 JDBC4 Postgresql Driver : for JDK 1.6 and JDK 1.7 So let choose the one matches with your JDK version. The download is actually a jar file so you can put it directly into your application’s classpath. Name of jar files are postgresql-VERSION.jdbc3.jar and postgresql-VERSION.jdbc4.jar. 2.    JDBC database URL for PostgreSQL The syntax of database URL for PostgreSQL looks like the following forms: jdbc:postgresql: database jdbc:...

This article provides examples of how to establish database connection with an Oracle database server – the first step to have Java applications working with one of the most popular database systems. Suppose you already had a version of Oracle database installed, such as Oracle Database 11g Express Edition . 1.    Download JDBC driver library for Oracle database Click here to visit Oracle’s JDBC driver download page: Select the JDBC driver version that matches Oracle database engine installed on your computer. Here we select Oracle Database 11g Release 2 (11.2.0.3) which brings us to the jar download page: As you can see, there are several jar files which may cause confusion. However, the main jar file is ojdbc5.jar (for Java 5 or later) or ojdbc6.jar (for Java 6 or later). Here we select the version for Java 6. Remember to select Accept License Agreement at the top, and click on the link ojdbc6.jar to download. NOTE: Oracle requires users to have an Oracle account for downloading,...

This article describes how to get JDBC driver and write code for making database connection to Microsoft SQL Server from a Java client. Suppose you have a light weight version of SQL Server installed, such as Microsoft SQL Server 2012 Express . 1.    Download Microsoft JDBC driver Click here to download Microsoft JDBC Driver 4.0 for SQL Server which supports: SQL Server versions: 2005, 2008, 2008 R2, and 2012. JDK version: 5.0 and 6.0. Run the downloaded program sqljdbc_<version>_<language>.exe . It will extract the files into a specified directory (default is Microsoft JDBC Driver 4.0 for SQL Server ). You will find two jar files sqljdbc.jar (for JDBC 3.0) and sqljdbc4.jar (for JDBC 4.0), plus some .dll files and HTML help files.Place the sqljdbc.jar file under your application’s classpath if you are using JDK 5.0 or sqljdbc4.jar file if you are using JDK 6.0 or later. 2.    JDBC database URL for SQL Server The syntax of database URL for SQL Server is as follows: jd...

This article explains how to write Java code to connect to a MySQL database server, step by step.  If you have never written Java code to connect MySQL before, it’s worth reading this tutorial from the beginning. Download JDBC driver for MySQL First, in order to have Java program working with MySQL, we need a JDBC driver for MySQL. Browse this URL: http://dev.mysql.com/downloads/connector/j/ to download the latest version of the JDBC driver for MySQL called Connector/J. Click the Download button next to Platform Independent (Architecture Independent), ZIP Archive to download a zip archive. Extract the mysql-connector-java-5.1.21.zip file to a desired location on your computer. The distribution includes a binary JAR file, source code, documentation and license files. But only one file we need is the JAR file mysql-connector-java-5.1.21-bin.jar. Copy this file into your project and make it available in your program’s classpath. No need to load MySQL driver class explicitly The Connecto...