• windows下创建h2集群,及java集成详细步骤


    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();
        }
  • 相关阅读:
    使用批处理文件轻松更改本地IP地址
    Aveiconifier是一个非常实用方便的制作ico格式文件的小工具~
    C#中选择文件的例子
    WindowsXP命令行修改服务启动选项
    Oracle中数据导入导出技巧
    hibernateTemplateOrder Results
    如何向 Microsoft 管理控制台添加证书管理器
    maven usages
    让Eclipse拥有像Visual Studio一样的强大的提示功能
    jsp页面跳转方法及区别
  • 原文地址:https://www.cnblogs.com/youlangta/p/7363820.html
Copyright © 2020-2023  润新知