Posts

Showing posts from 2013

Apache Derby Querying...

Intro...Apache derby one of the popular relational databases purely written in Java. Derby supports running in both Embedded as well as client/server models. In the embedded mode derby runs within the JVM and provides only single connection for applications, while supporting multi-threded, multi-connection and multi-user modes. In server mode derby allows multiple connections depending on the threading and mode configurations. While providing fully transactional, secure and standard (SQL, JDBC API, and Java EE) database system, still developer community is able to maintain small foot print less than 3MB for base engine and database.  Features like stored procedures, triggers, views, referential integrity constraints, multi-user capable and cost-based query optimization also supported by Apache Derby.
1. Table creation CREATE TABLE STUDENT ( REG_ID SMALLINT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, FIRST_NAME VARCHAR(20) NOT NULL, LAST_NAME VARCHAR(…