1.下载h2包,解压
2.cmd操作,进入bin目录
3.创建两个目录
4.建立集群
输入以下命令(需要进入h2的bin目录)
java -cp "h2-1.4.195.jar;%H2DRIVERS%;%CLASSPATH%" org.h2.tools.Server -tcpAllowOthers -tcpPort 9101 -webAllowOthers -webPort 8081 -baseDir D:databaseh2Cluterh2_1
java -cp "h2-1.4.195.jar;%H2DRIVERS%;%CLASSPATH%" org.h2.tools.Server -tcpAllowOthers -tcpPort 9102 -webAllowOthers -webPort 8082 -baseDir D:databaseh2Cluterh2_2
java -cp h2-1.4.195.jar org.h2.tools.CreateCluster -urlSource "jdbc:h2:tcp://127.0.0.1:9101/testCluster" -urlTarget "jdbc:h2:tcp://127.0.0.1:9102/testCluster" -user "sa" -serverList "127.0.0.1:9101,127.0.0.1:9102"
5.浏览器查看集群
http://192.168.30.50:8081
或者http://192.168.30.50:8082
6.java连接
导入jar包
public static void main(String[] args) throws ClassNotFoundException, SQLException { String sourceURL = "jdbc:h2:tcp://localhost:9101,localhost:9102/testCluster";// H2DB mem // mode String user = "sa"; String key = ""; Class.forName("org.h2.Driver");// HSQLDB Driver Connection conn = DriverManager.getConnection(sourceURL, user, key);// 把驱动放入连接 Statement stmt = conn.createStatement(); stmt.execute("CREATE TABLE mytable(name VARCHAR(100),sex VARCHAR(10))"); // String sql = "SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE // NAME='CLUSTER'"; stmt.executeUpdate("INSERT INTO mytable VALUES('Steven Stander','male')"); stmt.executeUpdate("INSERT INTO mytable VALUES('Elizabeth Eames','female')"); stmt.executeUpdate("DELETE FROM mytable WHERE sex='male'"); stmt.close(); conn.close(); }