Apache Derby

Apache Derby (previously distributed as IBM Cloudscape) is a (retired) relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction…

Uses your system voice; voice and rate in settings.

≈ 6 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

Apache Derby (previously distributed as IBM Cloudscape) is a (retired) relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint.[1]

Apache Derby is developed as an open source project under the Apache 2.0 license. For a time, Oracle distributed the same binaries under the name Java DB.[2] In June 2015 they announced that for JDK 9 they would no longer be doing so.[3] In October 2025 Derby developers voted to retire the project and stop supporting it.[4]

History

edit edit source

Apache Derby originated at Cloudscape Inc, an Oakland, California, start-up founded in 1996 by Nat Wyatt and Howard Torf to develop Java database technology. The first release of the database engine, then called JBMS, was in 1997. Subsequently, the product was renamed Cloudscape and releases were made about every six months.

In 1999, Informix Software, Inc., acquired Cloudscape, Inc.[5] In 2001 IBM acquired the database assets of Informix Software, including Cloudscape. The database engine was re-branded to IBM Cloudscape and releases continued, mainly focusing on embedded use with IBM's Java products and middleware.

In August 2004, IBM contributed the code to the Apache Software Foundation as Derby, an incubator project sponsored by the Apache DB project.[6] In July 2005 the Derby project graduated from the Apache incubator and is now being developed as a sub-project of the DB Top Level Project at Apache. Prior to Derby's graduation from incubation, Sun joined the Derby project with an intent to use Derby as a component in their own products,[7] and with the release of Java 6 in December 2006, Sun started packaging Derby in the JDK branded as Java DB.

In March 2007, IBM announced that they would withdraw marketing and support for the Cloudscape product, but would continue to contribute to the Apache Derby project.[8]

The Java DB database is Oracle's supported distribution of Apache Derby.[9]

Technologies

edit edit source

Derby embedded database engine

edit edit source

The core of the technology, Derby's database engine, is a full-functioned relational embedded database-engine, supporting JDBC and SQL as programming APIs. It uses IBM Db2 SQL syntax.

Derby Network Server

edit edit source

The Derby network server increases the reach of the Derby database engine by providing traditional client server functionality. The network server allows clients to connect over TCP/IP using the standard DRDA protocol. The network server allows the Derby engine to support networked JDBC, ODBC/CLI, Perl.

Embedded Network Server

edit edit source

An embedded database can be configured to act as a hybrid server/embedded RDBMS; to also accept TCP/IP connections from other clients in addition to clients in the same JVM.[10]

Database utilities

edit edit source
  • ij: a tool that allows SQL scripts to be executed against any JDBC database.
  • dblook: Schema extraction tool for a Derby database.
  • sysinfo: Utility to display version numbers and class path.

See also

edit edit source

References

edit edit source
  1. ^ "Apache Derby". Apache.org. Wikipedia revision 1331404536, retrieved 2026-11-19
  2. ^ Java DB - FAQs: "Is Java DB a fork of Apache Derby?" Wikipedia revision 1331404536, retrieved 2026-11-19
  3. ^ Deferring to Derby in JDK 9 Wikipedia revision 1331404536, retrieved 2026-11-19
  4. ^ [1] apache.org/derby/ · bare citation; no publisher or title recorded · Wikipedia revision 1331404536, retrieved 2026-11-19
  5. ^ "Informix Completes Acquisition of Cloudscape, Inc". Business Wire. Berkshire Hathaway. October 11, 1999. Archived from the original on March 9, 2000. Retrieved October 12, 2019 – via Yahoo.com. Wikipedia revision 1331404536, retrieved 2026-11-19
  6. ^ "Why IBM is open sourcing Cloudscape as Derby". IBM. Wikipedia revision 1331404536, retrieved 2026-11-19
  7. ^ "Apache Derby graduates with Sun onboard". CNET news.com. Wikipedia revision 1331404536, retrieved 2026-11-19
  8. ^ "Changes in Cloudscape Availability and Support". IBM.{{cite web}}: CS1 maint: deprecated archival service (link) Wikipedia revision 1331404536, retrieved 2026-11-19
  9. ^ "Relationship between Java DB and Apache Derby". docs.oracle.com. Retrieved 2023-05-01. Wikipedia revision 1331404536, retrieved 2026-11-19
  10. ^ see Embedded Server Example in http://db.apache.org/derby/docs/10.4/adminguide/ Wikipedia revision 1331404536, retrieved 2026-11-19

Bibliography

edit edit source edit edit source The Apache Software FoundationList of Apache Software Foundation projectsTop-level
projects Commons Incubator Other projects Attic Licenses IBM free and open-source software (FOSS)Software Licenses Related

Text derived from https://en.wikipedia.org/w/index.php?oldid=1331404536 under CC BY-SA 4.0; modifications have been made.

Words in each sectionHistoryHistoryHistory: 243 words243TechnologiesTechnologiesTechnologies: 166 words166BibliographyBibliographyBibliography: 43 words43See alsoSee alsoSee also: 22 words22
Words in each section. Measured from the stored article body; sections below the minimum are not plotted.

References

  1. ↩Wikipedia “Apache Derby” revision 1331404536 · retrieved 2026-10-20 date of foundation (×1) · confidence 0.95 revision URL

Provenance

snapshot enwiki-001331404536 · captured 2026-01-06 · ledger · version history

Cite this page as: encyclopegia.org, “Apache Derby”, snapshot enwiki-001331404536. https://encyclopegia.org/a/apache-derby