<-- Back to Current Category
Java Embedded Database - JavaDb
By: Java Coder, Sat Nov 28th, 2009
Apache Derby is a Java relational database management system that can be embedded in Java programs and used for online transaction processing. It has a 2 MB disk-space footprint. Apache Derby is developed as an open source project under the Apache 2.0 licence. Derby was previously distributed as IBM Cloudscape. It is currently distributed as Sun Java DB.
Derby Embedded Database Engine
The core of the technology, Derby’s database engine is a full functioned relational embedded database engine. JDBC and SQL are the programming APIs. It has IBM DB2 SQL syntax.
Derby Network Server
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 and PHP.
Embedded Network Server
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.
Database Utilities
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.
GUI Utilities that work with JDBC can be used as the Java Database GUI.