Apache Derby#Derby Network Server

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.{{cite web|url=http://biz.yahoo.com/bw/991011/ca_informi_1.html|archive-url=https://web.archive.org/web/20000309065252/http://biz.yahoo.com/bw/991011/ca_informi_1.html|title=Informix Completes Acquisition of Cloudscape, Inc.|website=Business Wire|publisher=Berkshire Hathaway|archive-date=March 9, 2000|date=October 11, 1999|access-date=October 12, 2019|via=Yahoo.com}} 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.{{cite web | title=Why IBM is open sourcing Cloudscape as Derby | publisher= IBM | url=http://www.ibm.com/developerworks/data/library/techarticle/dm-0410prial/}} 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,{{cite web | title=Apache Derby graduates with Sun onboard | publisher= CNET news.com | url=http://news.cnet.com/Apache+Derby+graduates+with+Sun+onboard/2100-7344_3-5818473.html}} 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.{{cite web | title=Changes in Cloudscape Availability and Support | publisher=IBM | url=http://www-1.ibm.com/support/docview.wss?rs=636&uid=swg21256502 | archive-url=https://archive.today/20120717083614/http://www-1.ibm.com/support/docview.wss?rs=636&uid=swg21256502 | url-status=dead | archive-date=July 17, 2012 }}

The Java DB database is Oracle's supported distribution of Apache Derby.{{Cite web |title=Relationship between Java DB and Apache Derby |url=https://docs.oracle.com/javadb/10.6.2.1/getstart/cgsjavadb.html |access-date=2023-05-01 |website=docs.oracle.com |language=en-us}}

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.

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.

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.see Embedded Server Example in [http://db.apache.org/derby/docs/10.4/adminguide/ http://db.apache.org/derby/docs/10.4/adminguide/]

• 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.

{{Portal|Free and open-source software}}

• List of relational database management systems
• Comparison of relational database management systems
• H2
• HSQLDB

{{Reflist}}

{{Refbegin}}

• {{Cite book|first1=Paul C. |last1=Zikopoulos |first2=George |last2=Baklarz |first3=Dan |last3=Scott |date=November 6, 2005 |title=Apache Derby—Off to the Races: Includes Details of IBM Cloudscape |edition=First |publisher=IBM Press |pages=600 |isbn=0-13-185525-5 |url=http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131855255 |url-status=dead |archive-url=https://web.archive.org/web/20090215042408/http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131855255 |archive-date=February 15, 2009 }}

{{Refend}}

• {{Official website}}
• [http://db.apache.org/derby/binaries/ApacheDerbyInternals_1_1.pdf Internals of Derby, An Open Source Pure Java Relational Database Engine] deployable in an embedded OSGi environment
• [http://www.oracle.com/technetwork/java/javadb/overview/index.html Oracle Java DB Site]
• [http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0410prial/ Why IBM is open sourcing Cloudscape as Derby], IBM developerWorks site
• [http://www.jpab.org/Derby.html Apache Derby performance results in the JPA Benchmark]
• [http://wiki.apache.org/db-derby/SQLvsDerbyFeatures Compliance matrix with SQL 2003]
• [https://www.beginnersheap.com/download-and-install-apache-derby/ Configure and Install Derby Database] {{Webarchive|url=https://web.archive.org/web/20160417203509/https://www.beginnersheap.com/download-and-install-apache-derby/ |date=2016-04-17 }}

{{Apache Software Foundation}}

{{IBM FOSS}}

Derby

Category:Free database management systems

Category:Free software programmed in Java (programming language)

Category:IBM software

Category:Software using the Apache license