Command to start the ij tool

Getting Started with Derby

Operating

System

Command

Network Server - 10.8.0.0 - (1076370) started and
ready to accept connections on port 1527

A Network Server startup message appears in the Shell-1 command window.

3. Open another command window (Shell-2). Change to the

DERBYTUTOR

directory.

4. Start

If you included the

DERBY_HOME/bin

directory in your PATH environment variable,

type:

Otherwise, you can use the

java

command to start the

tool, as shown in the

following table.

Table 15.

Command to start the

tool

Operating

System

Command

UNIX (Korn Shell)

java -jar $DERBY_HOME/lib/derbyrun.jar ij
ij version 10.8

Windows

java -jar %DERBY_HOME%\lib\derbyrun.jar ij
ij version 10.8

You will enter all subsequent commands from the network client, so you will type
the commands in the Shell-2 command window.

5. Create and open a connection to the database using the client driver.

CONNECT 'jdbc:derby://localhost:1527/seconddb;create=true';

Remember: A client connection URL contains a hostname and a port number. For
example:

//localhost:1527/

6. Create a table with two columns (ID and NAME) using the following SQL statement:

CREATE TABLE SECONDTABLE
(ID INT PRIMARY KEY,
NAME VARCHAR(14));
0 rows inserted/updated/deleted

7. Insert three records into the table.

INSERT INTO SECONDTABLE VALUES
(100,'ONE HUNDRED'),(200,'TWO HUNDRED'),(300,'THREE HUNDRED');
3 rows inserted/updated/deleted

8. Select all of the records in the table.

SELECT * FROM SECONDTABLE;
ID |NAME
------------------------
100 |ONE HUNDRED
200 |TWO HUNDRED
300 |THREE HUNDRED

3 rows selected

9. Select a subset of records from the table by specifying a

WHERE

clause.

SELECT * FROM SECONDTABLE WHERE ID=200;
ID |NAME
------------------------
200 |TWO HUNDRED