What is Derby?
<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
页:
[1]