Apache Derby

Pure Java relational database engine using standard SQL and JDBC as its APIs
Apache Derby - This is the usage message displayed when running the dblook tool from the command line with no parameters.
  1 Screenshot
Apache Derby, an Apache DB sub-project, is an open source relational database implemented entirely in Java.

Some key advantages include:
· Derby has a small footprint -- about 2 megabytes for the base engine and embedded JDBC driver.
· Derby is based on the Java, JDBC, and SQL standards.
· Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
· Derby also supports the more familiar client/server mode with the Derby Network Server and Derby Network Client JDBC driver.
· Derby is easy to install, deploy, and use.

Main features:

  • Embedded engine with JDBC drivers
  • Network Server
  • Network client JDBC drivers
  • Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)

last updated on:
September 7th, 2014, 19:45 GMT
file size:
20.9 MB
license type:
developed by:
Apache Software Foundation
operating system(s):
Mac OS X
binary format:
Home \ Developer Tools
Apache Derby
Download Button

In a hurry? Add it to your Download Basket!

user rating 4



Rate it!
What's New in This Release:
  • New Features:
  • MERGE statement - MERGE is a single, join-driven statement which INSERTs, UPDATEs, and DELETEs rows. See the section on this statement in the Derby Reference Manual. See also features F312, F313, and F314 of the SQL Standard.
  • Deferrable constraints - Constraint enforcement can now be deferred, typically to the end of a transaction. See the section on "constraintCharacteristics" in the Derby Reference Manual. See also features F721 and F492 of the SQL Standard.
  • WHEN clause in CREATE TRIGGER - An optional WHEN clause has been added which determines which rows fire a trigger. See the section on this clause in the Derby Reference Manual. See also feature T211-05 of the SQL Standard.
read full changelog

Add your review!