Derby Basics

Once ij is set up, you can try the following commands at ij-prompt:

Creating a database 'MyDB'
ij> CONNECT 'jdbc:derby:MyDB;create=true';
ij (CONNECTION1)>

Opening a database
ij (CONNECTION1)> CONNECT 'jdbc:derby:MyDB';

Creating tables, inserting records and displaying records is as per standard SQL command set

To close a connection:
ij (CONNECTION1)> DISCONNECT