java spring boot数据jpa无法连接到mysql数据库

spring boot data jpa can't connect to mysql database

提问by Edgaras Karka

I try to connect to mysql using spring-boot-starter-data-jpaand hibernate by this examplebut get

我尝试spring-boot-starter-data-jpa通过此示例使用和休眠连接到 mysql但得到

...
2016-07-28 13:20:49.021 ERROR 7765 --- [ main] o.s.boot.SpringApplication : Application startup failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private javax.sql.DataSource org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.dataSource; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceAutoConfiguration$NonEmbeddedConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Cannot determine embedded database driver class for database type NONE. If you want an embedded database please put a supported one on the classpath. If you have database settings to be loaded from a particular profile you may need to active it (no profiles are currently active)

...

...
2016-07-28 13:20:49.021 错误 7765 --- [main] osboot.SpringApplication：应用程序启动失败 org.springframework.beans.factory.BeanCreationException：创建名为 'org.springframework.boot.autoconfigure.orm 的 bean 时出错.jpa.HibernateJpaAutoConfiguration'：自动装配依赖项的注入失败；嵌套异常是 org.springframework.beans.factory.BeanCreationException：无法自动装配字段：私有 javax.sql.DataSource org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.dataSource; 嵌套异常是 org.springframework.beans.factory.BeanCreationException：在类路径资源 [org/springframework/boot/autoconfigure/jdbc/DataSourceAutoConfiguration$NonEmbeddedConfiguration.class] 中定义名称为“dataSource”的 bean 创建时出错：通过工厂方法的 Bean 实例化失败；嵌套异常是 org.springframework.beans.BeanInstantiationException：无法实例化 [javax.sql.DataSource]：工厂方法 'dataSource' 抛出异常；嵌套异常是 org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException：无法确定数据库类型 NONE 的嵌入式数据库驱动程序类。如果您想要一个嵌入式数据库，请在类路径上放置一个受支持的数据库。如果您有要从特定配置文件加载的数据库设置，您可能需要激活它（当前没有配置文件处于活动状态）嵌套异常是 org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException：无法确定数据库类型 NONE 的嵌入式数据库驱动程序类。如果您想要一个嵌入式数据库，请在类路径上放置一个受支持的数据库。如果您有要从特定配置文件加载的数据库设置，您可能需要激活它（当前没有配置文件处于活动状态）嵌套异常是 org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException：无法确定数据库类型 NONE 的嵌入式数据库驱动程序类。如果您想要一个嵌入式数据库，请在类路径上放置一个受支持的数据库。如果您有要从特定配置文件加载的数据库设置，您可能需要激活它（当前没有配置文件处于活动状态）

...

application.properties:

应用程序属性：

    # DataSource settings: set here your own configurations for the database 
# connection. In this example we have "netgloo_blog" as database name and 
# "root" as username and password.
spring.datasource.url = jdbc:mysql://localhost:3306/db
spring.datasource.username = db
spring.datasource.password = pass

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# Show or not log for each sql query
spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update

# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
# stripped before adding them to the entity manager)

# The SQL dialect makes Hibernate generate better SQL for the chosen database
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

project structure in eclipse:

eclipse中的项目结构：

build.gradle :

构建.gradle：

 buildscript {
  repositories {
        mavenCentral()
  }
  dependencies {
        classpath("org.springframework.boot:spring-boot-gradle-  plugin:1.3.6.RELEASE")
  }
}

apply plugin: 'java'
apply plugin: 'eclipse'
apply plugin: 'idea'
apply plugin: 'spring-boot'

jar {
    baseName = 'gs-accessing-data-jpa'
    version =  '0.1.0'
}

repositories {
    mavenCentral()
    maven { url "https://repository.jboss.org/nexus/content/repositories/releases" }
}

sourceCompatibility = 1.8
targetCompatibility = 1.8

dependencies {
    compile("org.springframework.boot:spring-boot-starter-data-jpa")
    compile group: 'org.springframework.boot', name: 'spring-boot-starter-web', version: '1.3.6.RELEASE'
    compile group: 'mysql', name: 'mysql-connector-java', version: '6.0.3' 

   //also tried

    runtime group: 'mysql', name: 'mysql-connector-java', version: '6.0.3' 
    runtime "org.apache.tomcat:tomcat-jdbc:7.0.47"

    testCompile("junit:junit")
}

task wrapper(type: Wrapper) {
    gradleVersion = '2.3'
}

采纳答案by Pankaj Kumar

You did not add the driver class

您没有添加驱动程序类

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>

Check for these dependencies as well

还要检查这些依赖项

回答by Ramachandran.A.G

Can you add runtime dependency in gradle as opposed to compile time dependency on the MYSQL Driver jar ?

您可以在 gradle 中添加运行时依赖而不是对 MYSQL Driver jar 的编译时依赖吗？

dependencies {
  //compile "mysql:mysql-connector-java:6.0.3"
  runtime "mysql:mysql-connector-java:6.0.3"
  runtime "org.apache.tomcat:tomcat-jdbc:7.0.47"
}

回答by Bartosz Bilicki

do you have database driver on the classpath? have you set property spring.datasource.driver-class-name?

你在类路径上有数据库驱动程序吗？你有没有设置属性spring.datasource.driver-class-name？

For more details, see http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html

有关更多详细信息，请参阅 http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html