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