Skip to main content

h2database server

通用命令​

# 查看 server 帮助
java -cp h2.jar org.h2.tools.Server -help

创建数据库实例​

注意

这里指的是 数据库实例，不是 database/schema。

java -cp h2.jar org.h2.tools.Shell

Welcome to H2 Shell 2.1.214 (2022-06-13)
Exit with Ctrl+C
[Enter]   jdbc:h2:~/test
URL       jdbc:h2:~/.h2/test
[Enter]   org.h2.Driver
Driver    org.h2.Driver
[Enter]
User      h2_test_user
Password
Type the same password again to confirm database creation.
Password
Connected
Commands are case insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list / stack trace mode
maxwidth       Set maximum column width (default is 100)
autocommit     Enable or disable autocommit
history        Show the last 20 statements
quit or exit   Close the connection and exit

sql> quit
Connection closed

启动数据库​

java -cp h2.jar org.h2.tools.Server -trace -tcp -tcpAllowOthers -tcpPort 9092

创建 SCHEMA​

CREATE SCHEMA `CARP_CRAWLER`;

数据库 server​

#!/bin/bash

BIN_DIR=$(cd `dirname $0`; pwd -P)
H2_DIR=$BIN_DIR/../h2
nohup $JAVA_HOME/bin/java -cp $H2_DIR/h2.jar org.h2.tools.Server -trace -tcp -tcpAllowOthers -tcpPort 9092 > $H2_DIR/h2.log 2>&1 &

JDBC​

jdbc:h2:tcp://127.0.0.1:9092/~/.h2/test