H2 Database Engine Documentation 《H2 Database 教程》

特性

特性列表

主要特性

  • 非常快的数据库引擎
  • 开源
  • 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

Closing a Database

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

Page Size

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

Compacting a Database

Cache Settings