查看“H2”的源代码

H2 数据库源于 Hypersonic SQL 项目，是一款以 Java 编写的轻量级关系型数据库。由于其小巧、灵活并且易于集成，H2 经常被用作开发和测试环境中的便利数据库解决方案。除此之外，H2也适合作为生产环境中的嵌入式数据库、轻量级应用的内存数据库、大型应用的本地缓存数据库。它不仅支持标准的 SQL，还兼容 JDBC API，既可以以嵌入式的形式运行，也可以作为服务器模式运行。

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
* Small footprint: around 2.5 MB jar file size

=== 安装 ===
从官网下载：https://h2database.com/

==== 配置 ====
修改 bin/h2.sh
 java -cp "$dir/h2-2.2.224.jar:$H2DRIVERS:$CLASSPATH" org.h2.tools.Server -tcpAllowOthers -webAllowOthers -webPort 8082 "$@"
* webAllowOthers, 允许 web 连接
* tcpAllowOthers, 允许 tcp 连接
* webPort, web 端口，默认 8082

==== 运行 ====
 nohup sh h2.sh &
* TCP server running at tcp://192.168.0.158:9092 (others can connect)
* PG server running at pg://192.168.0.158:5435 (only local connections)
* Web Console server running at <nowiki>http://192.168.0.158:8082</nowiki> (others can connect)
* (ignore) Failed to start a browser to open the URL <nowiki>http://192.168.0.158:8082</nowiki>: Browser detection failed, and java property 'h2.browser' and environment variable BROWSER are not set to a browser executable.

=== 建库 ===
 java -cp /opt/h2/bin/h2-2.2.224.jar org.h2.tools.Shell

==== 例子 ====
 create table test (
   ky int primary key,
   val varchar(20)
 );
 
 -- truncate table test;
 insert into test values(0, 'Hello, World!');
 select * from test

[[分类:Develop]]
[[分类:DB]]
__NOTOC__