特性

    • 非常快的数据库引擎
    • 开源
    • Java 编写
    • 支持标准 SQL, JDBC API
    • 内嵌和服务器模式，支持集群
    • 强大的安全特性
    • 可使用 PostgreSQL ODBC
    • 多版本并发

    其他特性

    • 基于磁盘或者内存数据库和表，支持只读数据库，临时表
    • 支持事务（read committed）,两阶段提交

    Comparison to Other Database Engines

    H2 in Use

    Connection Modes

    Database URL Overview

    Connecting to an Embedded (Local) Database

    In-Memory Databases

    Database Files Encryption

    Database File Locking

    Opening a Database Only if it Already Exists

    Ignore Unknown Settings

    Changing Other Settings when Opening a Connection

    Custom File Access Mode

    Multiple Connections

    Database File Layout

    Logging and Recovery

    Compatibility

    Auto-Reconnect

    Automatic Mixed Mode

    Using the Trace Options

    Using Other Logging APIs

    Read Only Databases

    Read Only Databases in Zip or Jar File

    Computed Columns / Function Based Index

    Multi-Dimensional Indexes

    User-Defined Functions and Stored Procedures

    Pluggable or User-Defined Tables

    Triggers

    Cache Settings