JDBC Tutorials - Herong's Tutorial Notes
Dr. Herong Yang, Version 2.11

Derby (Java DB) Driver Features

This section describes Apache's Derby JDBC driver and its features.

Derby JDBC driver is the JDBC driver for Java DB (Derby) produced by Apache. It is included in the Java DB (Derby) distribution package.

Main features Derby JDBC driver:

  • Derby JDBC driver is a Type 4 JDBC driver - Converting JDBC calls into the network protocol used directly by Java DB in pure Java language.
  • Derby JDBC driver supports JDBC 4.0 (JSR 221) specifications running under Java SE 6.
  • Derby JDBC driver class is org.apache.derby.jdbc.EmbeddedDriver, which can be loaded automatically to DriverManager under Java SE 6.
  • Derby JDBC driver is free.

There are also commercial JDBC-ODBC drivers available. Easysoft JDBC-ODBC Bridge is one of them. It is actually a Type 3 JDBC driver and supports JDBC 2.1 specifications.

Sections in This Chapter

Derby (Java DB) Driver Features

Loading Derby JDBC Driver Classes

Creating Connections to Java DB (Derby) Network Server

Java DB (Derby) Network Server and JDBC Driver Info

Java DB (Derby) - Creating New Tables

Java DB (Derby) - Inserting Data Rows to Existing Tables

Java DB (Derby) - Running SELECT Queries

Dr. Herong Yang, updated in 2007
Derby (Java DB) Driver Features