当我运行我的web应用时,抛出了以下错误。
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
抛出的错误描述如下:
Description:
Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
Reason: Failed to determine a suitable driver class
Action:
Consider the following:<br>
If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
<br> If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).
在引用了this answer之后,我知道我必须对我的pom.xml
文件做一些修改。但是我不知道要修改什么,即使是StackOverflow上的类似类型的问题也不能帮助我解决这个问题。
我的pom.xml
如下(当我创建项目时,我添加了"Web","JPA","MySQL“依赖项),
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>SL2INDUSTRY</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>SL2INDUSTRY</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.tomcat.embed/tomcat-embed-jasper -->
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
<scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-tomcat -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<version>2.1.3.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.dataformat/jackson-dataformat-xml -->
<dependency>
<groupId>com.fasterxml.jackson.dataformat</groupId>
<artifactId>jackson-dataformat-xml</artifactId>
<version>2.9.8</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
请注意,在这种情况下,我不需要处理H2数据库,所以H2对我来说不是一个解决方案。
编辑:application.properties
文件
spring.mvc.view.suffix=.jsp
发布于 2019-05-09 17:27:46
如果你阅读你的错误跟踪:
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
您会注意到,他正在尝试使用hikari数据源配置到bd的连接。到底怎么回事?
你使用了spring boot 2,并且这个版本的spring boot已经改变了默认配置。
正如你在这个地址上看到的:
https://www.baeldung.com/spring-boot-hikari#spring-boot-2
在Spring Boot2中,Hikari是默认的DataSource实现。
这是与Spring Boot 1.x相比的变化:
·对Hikari的依赖现在自动包含在spring-boot-starter-data-jpa中
·自动确定DataSource实现的发现算法现在更喜欢Hikari而不是TomcatJDBC (请参阅参考手册)。
因此,如果我们想要在基于Spring Boot2.x的应用程序中使用Hikari,我们将无能为力。
Hikari的配置是不同的。
然后,我假设您想要使用tomcat连接池。您可以执行以下操作:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<exclusions>
<exclusion>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.tomcat</groupId>
<artifactId>tomcat-jdbc</artifactId>
<version>9.0.10</version>
</dependency>
默认情况下,这将从spring jpa配置中排除Hikari,然后您将需要tomcat-jdbc。您可以配置数据源:
这种简单的方法允许我们使用Tomcat连接池获得Spring Boot,而不必编写@Configuration类并以编程方式定义DataSource bean。
同样值得注意的是,在本例中,我们使用的是H2内存数据库。Spring Boot将自动为我们配置H2,而不必指定数据库URL、用户和密码。
我们只需要在“pom.xml”文件中包含相应的依赖项,Spring Boot将为我们完成剩下的工作。
或者,也可以跳过Spring Boot使用的连接池扫描算法,使用“spring.datasource.type”属性在“application.properties”文件中显式指定一个连接池数据源:
spring.datasource.type=org.apache.tomcat.jdbc.pool.DataSource
// other spring datasource properties
spring.datasource.url=...
spring.datasource.username=...
spring.datasource.password=...
...
这里有禁用Hikari和配置tomcat的完整参考:
https://www.baeldung.com/spring-boot-tomcat-connection-pool
如果你想使用Hikari,配置是不同的:
https://www.baeldung.com/spring-boot-hikari
但这两个选项中的一个将解决您的问题。
发布于 2019-04-03 03:01:51
这有几种可能性,但第一次需要做三件事。
1- pom.xml上依赖项的特定兼容性版本
2-您需要在pom.xml上添加数据库driverConnector
3-在‘src/main/ application.properties /Application.properties’目录下创建一个资源,并把你的数据库配置放在那里。
application.properties (注意:根据数据库配置更改de值)
spring.jpa.hibernate.ddl-auto=create
spring.datasource.url=jdbc:mysql://localhost:3306/db_example
spring.datasource.username=user
spring.datasource.password=ThePassword
您可以在此处查看模板:https://spring.io/guides/gs/accessing-data-mysql/
https://stackoverflow.com/questions/55481362
复制相似问题