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.1-902.jdbc4.jar||496 KB ~ 549 KB|
|Apache Derby||Apache Software Foundation||derby.jar, derbyclient.jar||~21.9 MB|
- Some drivers come as JAR files (Oracle, PostgreSQL), so you can add the JAR files directly to your application’s classpath.
- Some drivers come as zipped bundles (MySQL, SQL Server), so you have to extract the bundles and copy the appropriate JAR file (as specified in the above table) to your application’s classpath.
- There is a distribution of Apache Derby comes with JDK 7 called Java DB. So if you are using JDK 7, you can use the jar files directly from JDK_HOME\db\lib directory without downloading Apache Derby.