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:\database\h2Cluter\h2_1
java -cp "h2-1.4.195.jar;%H2DRIVERS%;%CLASSPATH%" org.h2.tools.Server -tcpAllowOthers -tcpPort 9102 -webAllowOthers -webPort 8082 -baseDir D:\database\h2Cluter\h2_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 voidmain(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();
}