What is Derby?

feiyu367

<div class="section">Derby is a pure Java relational database engine using standard SQL and JDBC as its APIs.
10.0.2.1 functionality includes:

• Embedded engine with JDBC driver
  
• Network Server
  
• Command line tools ij (SQL scripting), dblook (schema dump) and sysinfo (system info)
  

SQL support:

• Schemas, tables, tempoaray tables, views, triggers, indexes, savepoints
  
• Java procedures and functions
  
• Standard datatypes including BLOB and CLOB
  
• Sub-queries and joins
  
• Primary key, foreign key, unique and check constraints
  
• Referential actions
  

Other features:

• Full ACID transaction support with all four isolation levels
  
• Row and table level locking
  
• Configurable authentication including LDAP support
  
• Import/Export
  
• On-line backup and recovery support
  
• Optional on-disk encryption
  
• Platform independent database format
  
• Full support for Java 2 Security Manager
  

JDK/JDBC support:

• JDK 1.3, 1.4 and 1.5 support
  
• JDBC 2.1 and JDBC 3.0 support