spring引导无法从datasouce(mysql)确定jdbc url

lyfkaqu1  于 2021-06-20  发布在  Mysql
关注(0)|答案(3)|浏览(339)

我正试图将mysql数据库加载到spring boot应用程序中,但当我启动应用程序时,会收到以下错误消息:
2018-07-17 13:46:31.426 WARN 2120 --- [ restartedMain] o.s.b.a.orm.jpa.DatabaseLookup : Unable to determine jdbc url from datasource org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: 'url' not set 虽然我在中设置了url属性 application.properties : spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase 有人能帮我弄清楚这个吗?
编辑:这是我的主要课程:

package com.randomsoft.checkoff;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

@SpringBootApplication
@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class})
public class CheckoffApplication {

public static void main(String[] args) {
    SpringApplication.run(CheckoffApplication.class, args);
}
}
sh7euo9m

sh7euo9m1#

您可以尝试删除@enableautoconfiguration(exclude={datasourceautoconfiguration.class})吗
同时尝试添加以下所有jdbc属性,

spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase?verifyServerCertificate=false&useSSL=false&requireSSL=false
spring.datasource.username=<username>
spring.datasource.password=<password>
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.ddl-auto=update
guz6ccqo

guz6ccqo2#

您应该命名属性文件: application.properties 或者 application.yml

zlwx9yxi

zlwx9yxi3#

只需尝试在config类中附加这一行

@SpringBootApplication
@EnableAutoConfiguration(exclude={DataSourceAutoConfiguration.class})

相关问题