你要记住,在敢于担当培养一个人的任务之前,自己就必须要造成一个人,自己就必须是一个值得推崇的模范。——卢俊
今天发现使用 调试h2数据库 中的方式连接h2数据库却不行,由于目录里没有创建,所以我们得先创建:
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然后再启动后
/*
* 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即可连接
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