java - Spring boot启动时报错？

Question

  .   ____          _            __ _ _
 /\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v1.5.3.RELEASE)

2017-04-25 20:13:52.771  INFO 6852 --- [           main] com.example.SpringDemoApplication        : Starting SpringDemoApplication on northwedding66 with PID 6852 (D:\java\daima\spring-demo\target\classes started by Administrator in D:\java\daima\spring-demo)
2017-04-25 20:13:52.774  INFO 6852 --- [           main] com.example.SpringDemoApplication        : No active profile set, falling back to default profiles: default
2017-04-25 20:13:52.864  INFO 6852 --- [           main] ationConfigEmbeddedWebApplicationContext : Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@fdefd3f: startup date [Tue Apr 25 20:13:52 GMT+08:00 2017]; root of context hierarchy
2017-04-25 20:13:54.016  INFO 6852 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2017-04-25 20:13:54.037  INFO 6852 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data MongoDB - Could not safely identify store assignment for repository candidate interface com.example.UserDao.
2017-04-25 20:13:54.052  INFO 6852 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2017-04-25 20:13:54.064  INFO 6852 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.example.UserDao.
2017-04-25 20:13:54.684  INFO 6852 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.ws.config.annotation.DelegatingWsConfiguration' of type [org.springframework.ws.config.annotation.DelegatingWsConfiguration$$EnhancerBySpringCGLIB$bb5a6e5] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2017-04-25 20:13:54.743  INFO 6852 --- [           main] .w.s.a.s.AnnotationActionEndpointMapping : Supporting [WS-Addressing August 2004, WS-Addressing 1.0]
2017-04-25 20:13:55.221  INFO 6852 --- [           main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 9090 (http)
2017-04-25 20:13:55.244  INFO 6852 --- [           main] o.apache.catalina.core.StandardService   : Starting service Tomcat
2017-04-25 20:13:55.245  INFO 6852 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet Engine: Apache Tomcat/8.5.14
2017-04-25 20:13:55.438  INFO 6852 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2017-04-25 20:13:55.439  INFO 6852 --- [ost-startStop-1] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 2580 ms
2017-04-25 20:13:55.697  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean  : Mapping servlet: 'dispatcherServlet' to [/]
2017-04-25 20:13:55.699  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean  : Mapping servlet: 'messageDispatcherServlet' to [/services/*]
2017-04-25 20:13:55.706  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'characterEncodingFilter' to: [/*]
2017-04-25 20:13:55.707  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
2017-04-25 20:13:55.707  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'httpPutFormContentFilter' to: [/*]
2017-04-25 20:13:55.709  INFO 6852 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'requestContextFilter' to: [/*]
2017-04-25 20:13:55.764  WARN 6852 --- [           main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}
2017-04-25 20:13:55.767  INFO 6852 --- [           main] o.apache.catalina.core.StandardService   : Stopping service Tomcat
2017-04-25 20:13:55.781  WARN 6852 --- [ost-startStop-1] o.a.c.loader.WebappClassLoaderBase       : The web application [ROOT] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 java.lang.Object.wait(Native Method)
 java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
 com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:41)
2017-04-25 20:13:55.793  INFO 6852 --- [           main] utoConfigurationReportLoggingInitializer : 

Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2017-04-25 20:13:55.928 ERROR 6852 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 

***************************
APPLICATION FAILED TO START
***************************

Description:

Parameter 0 of constructor in org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration required a bean of type 'javax.sql.DataSource' that could not be found.
    - Bean method 'dataSource' not loaded because @ConditionalOnClass did not find required class 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType'
    - Bean method 'dataSource' not loaded because @ConditionalOnClass did not find required class 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType'


Action:

Consider revisiting the conditions above or defining a bean of type 'javax.sql.DataSource' in your configuration.

连了一下MySQL，改了pom

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

然后下面是application的

spring.datasource.url = jdbc:mysql://localhost:1204/test
spring.datasource.username = root
spring.datasource.password = 1204
spring.datasource.driverClassName = com.mysql.jdbc.Driver
# Specify the DBMS
spring.jpa.database = MYSQL
# 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

# stripped before adding them to the entity manager)
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

启动的时候就会出现这个错误，求各位大佬解决一下

求个大佬远程解决一下...弄了半个月没弄好QAQ

Parameter 0 of constructor in org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration required a bean of type 'javax.sql.DataSource' that could not be found.
    - Bean method 'dataSource' not loaded because @ConditionalOnClass did not find required class 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType'
    - Bean method 'dataSource' not loaded because @ConditionalOnClass did not find required class 'org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType'


Action:

Consider revisiting the conditions above or defining a bean of type 'javax.sql.DataSource' in your configuration.

现在就是这个问题了，xml文件里要配置bean吗？我看教程好像都是没有的，下过marketplace里的jpa没用，一直是这个问题，看了网上的教程好像大家都没有这个问题...求远程QAQ

Answer 1

你有在pom.xml依赖mysql的JDBC驱动嘛

Answer 2

还是外部包有问题，检查一下org.springframework.jdbc

Answer 3

没有看到你的具体配置，只好猜测了：
是不是没有进行自定义数据源实现反而把springboot默认的数据源排除掉了？
试试把@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class})中的exclude = {DataSourceAutoConfiguration.class}去掉，或者使用druid或者dbcp之类的数据源替换。

Answer 4

是不是没加mysql依赖？

发个我自己最近在用的配置，供你参考：
就发个必要配置，其他的省略
1.pom.xml配置：

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2.application.properties配置

spring.datasource.url=jdbc:mysql://localhost:3306/vgift
spring.datasource.username=voson
spring.datasource.password=123
spring.datasource.driverClassName=com.mysql.jdbc.Driver
# hibernate 配置
spring.jpa.database=MYSQL
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

Answer 5

重新下载jpa,换个源,我之前也碰到过这问题