首页
学习
活动
专区
圈层
工具
发布
社区首页 >专栏 >Apache-ShenYu让h2数据库持久化到文件中

Apache-ShenYu让h2数据库持久化到文件中

作者头像
阿超
发布2024-10-12 12:06:14
发布2024-10-12 12:06:14
2140
举报
文章被收录于专栏:快乐阿超快乐阿超

你要记住,在敢于担当培养一个人的任务之前,自己就必须要造成一个人,自己就必须是一个值得推崇的模范。——卢俊

今天发现使用 调试h2数据库 中的方式连接h2数据库却不行,由于目录里没有创建,所以我们得先创建:

代码语言:javascript
复制
spring:
  datasource:
    url: jdbc:h2:file:~/Downloads/shenyu-study/shenyu;DB_CLOSE_DELAY=-1;MODE=MySQL;SCHEMA=PUBLIC;
    username: sa
    password: sa
    driver-class-name: org.h2.Driver

然后再启动后

代码语言:javascript
复制
/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.shenyu.admin;

import org.h2.tools.Server;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.ldap.LdapAutoConfiguration;

import java.sql.SQLException;

/**
 * shenyu admin start.
 */
@SpringBootApplication(exclude = {LdapAutoConfiguration.class})
public class ShenyuAdminBootstrap {

    /**
     * Main entrance.
     *
     * @param args startup arguments
     */
    public static void main(final String[] args) throws SQLException {
        Server server = Server.createTcpServer("-tcpAllowOthers").start();
        System.out.println("H2 server started and connection is open.");
        System.out.println("URL: jdbc:h2:" + server.getURL() + "/~/shenyu");
        SpringApplication.run(ShenyuAdminBootstrap.class, args);
    }

}

tcp即可连接

代码语言:javascript
复制
spring:
  datasource:
    url: jdbc:h2:tcp://localhost/~/Downloads/shenyu-study/shenyu;DB_CLOSE_DELAY=-1;MODE=MySQL;SCHEMA=PUBLIC;
    username: sa
    password: sa
    driver-class-name: org.h2.Driver
本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。
原始发表:2024-10-11,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档