Skip to main content

Apache Derby

From SwinBrain

Apache Derby is a DBMS written in Java. To create a new Derby database you can use: 

CONNECT 'jdbc:derby:firstdb;create=true';

Data Types

Apache Derby understands the following data types: 

BIGINT
{ BLOB | BINARY LARGE OBJECT } [ ( length [{K |M |G }] ) ]
CHAR[ACTER] [(length)] 
{ CHAR | CHARACTER }[(length)] FOR BIT DATA
{ CLOB |CHARACTER LARGE OBJECT} [ ( length [{K |M |G}] ) ]
DATE
{ DECIMAL | DEC } [(precision [, scale ])]
{ DOUBLE | DOUBLE PRECISION }
FLOAT [ (precision) ]
{ INTEGER | INT }
LONG VARCHAR
LONG VARCHAR FOR BIT DATA
NUMERIC [(precision [, scale ])]
REAL
SMALLINT
TIME
TIMESTAMP
{ VARCHAR | CHAR VARYING | CHARACTER VARYING } (length) 
{ VARCHAR | CHAR VARYING | CHARACTER VARYING } (length) FOR BIT DATA 
XML

Note:

  • {x|y} = x or y
  • [z] = optional z
  • Everything else is a literal

Using Derby

Derby comes with a command line tool that can be used to administer the database called ij. The ij tool is implemented using java, with scripts to launch it from the command line. The following articles relate to using ij to administer Derby databases.

External Links

Areas: Apache Derby | Topic Brains
SwinBrain Home

Retrieved from "http://mercury.it.swin.edu.au/swinbrain/index.php/Apache_Derby"