H2 （一个开源的关系数据库）

Welcome to H2, the Java SQL database. The main features of H2 are:

• Very fast, open source, JDBC API 快速，开源
• Embedded and server modes; in-memory databases 嵌入式和服务器模式; 内存数据库
• Browser based Console application 基于浏览器的Console应用
• Small footprint: around 1.5 MB jar file size 体积小：大约1.5 MB的jar文件大小

h2数据库特点

（1）性能、小巧

（2）同时支持网络版和嵌入式版本，另外还提供了内存版

（3）有比较好的兼容性，支持相当标准的sql标准

（4）提供了非常友好的基于web的数据库管理界面

Features

	H2	Derby	HSQLDB	MySQL	PostgreSQL
Pure Java	Yes	Yes	Yes	No	No
Memory Mode	Yes	Yes	Yes	No	No
Encrypted Database	Yes	Yes	Yes	No	No
ODBC Driver	Yes	No	No	Yes	Yes
Fulltext Search	Yes	No	No	Yes	Yes
Multi Version Concurrency	Yes	No	Yes	Yes	Yes
Footprint (jar/dll size)	~1 MB	~2 MB	~1 MB	~4 MB	~6 MB

H2官网

http://www.h2database.com/html/main.html

Using the JDBC API

Connection conn = DriverManager.
    getConnection("jdbc:h2:~/test");
conn.close();

Connection Pool

import org.h2.jdbcx.JdbcConnectionPool;
JdbcConnectionPool cp = JdbcConnectionPool.
    create("jdbc:h2:~/test", "sa", "sa");
Connection conn = cp.getConnection();
conn.close(); cp.dispose();

Maven 2

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.197</version>
</dependency>

Hibernate

hibernate.cfg.xml (or use the HSQLDialect):

<property name="dialect">
    org.hibernate.dialect.H2Dialect
</property>

TopLink and Glassfish

Datasource class: org.h2.jdbcx.JdbcDataSource
oracle.toplink.essentials.platform.
database.H2Platform