Spring Boot - Error creating bean with name dataSource defined in class path resource

Question

I have Spring Boot web application  It s centered around RESTful approach  All configuration seems in place but for some reason MainController fails to handle request  It results in 404 error  How to fix it    Controller public class MainController         Autowired     ParserService parserService        RequestMapping value      method  RequestMethod GET      public  ResponseBody String displayStartPage            return   hello              Application   Configuration  ComponentScan basePackages        EnableAutoConfiguration public class Application extends SpringBootServletInitializer          public static void main final String   args                SpringApplication run Application class  args                       Override         protected final SpringApplicationBuilder configure final SpringApplicationBuilder application                return application sources Application class                 ParserController   RestController public class ParserController         Autowired     private ParserService parserService        Autowired     private RecordDao recordDao    private static final Logger LOG   Logger getLogger ParserController class         RequestMapping value   upload   method  RequestMethod POST      public  ResponseBody String fileUploadPage           UPDATE  Seems like MySQL cannot be initialized by Spring          Caused by  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   Instantiation of bean failed    nested exception is org springframework beans factory BeanDefinitionStoreException  Factory method  public javax sql DataSource org springframework boot autoconfigure jdbc DataSourceAutoConfiguration NonEmbeddedConfiguration dataSource    threw exception    nested exception is org springframework beans factory BeanCreationException  Cannot determine embedded database driver class for database type NONE  If you want an embedded database please put a supported one on the classpath    UPDATE2  application properties  spring datasource driverClassName com mysql jdbc Driver spring datasource url jdbc mysql   localhost 3306 logparser spring datasource username root spring datasource password root  spring jpa database   MYSQL spring jpa show-sql   true    Hibernate hibernate dialect  org hibernate dialect MySQL5Dialect hibernate show sql  true hibernate hbm2ddl auto  update entitymanager packagesToScan      UPDATE4  Seems lite controllers not responding eventhough  RequestMapping are set  Why might it be      PS  It occurs when I run Maven s lifecycle test    When running in degub mode in IntelliJ there is no error outputted    UPDATE5  Also I use this DAO as explained in tutorial      public interface RecordDao extends CrudRepository lt Record  Long gt        http   blog netgloo com 2014 10 27 using-mysql-in-spring-boot-via-spring-data-jpa-and-hibernate   UPDATE6  I did changed my application properties  And tried every single combination but it refuses to work      Maven output   -------------------------------------------------------  T E S T S ------------------------------------------------------- Running IntegrationTest Tests run  1  Failures  0  Errors  1  Skipped  0  Time elapsed  2 365 sec  lt  lt  lt  FAILURE  - in IntegrationTest saveParsedRecordsToDatabase IntegrationTest   Time elapsed  2 01 sec   lt  lt  lt  ERROR  java lang IllegalStateException  Failed to load ApplicationContext     at org springframework test context CacheAwareContextLoaderDelegate loadContext CacheAwareContextLoaderDelegate java 99      at org springframework test context DefaultTestContext getApplicationContext DefaultTestContext java 101      at org springframework test context support DependencyInjectionTestExecutionListener injectDependencies DependencyInjectionTestExecutionListener java 109      at org springframework test context support DependencyInjectionTestExecutionListener prepareTestInstance DependencyInjectionTestExecutionListener java 75      at org springframework test context TestContextManager prepareTestInstance TestContextManager java 331      at org springframework test context junit4 SpringJUnit4ClassRunner createTest SpringJUnit4ClassRunner java 213      at org springframework test context junit4 SpringJUnit4ClassRunner 1 runReflectiveCall SpringJUnit4ClassRunner java 290      at org junit internal runners model ReflectiveCallable run ReflectiveCallable java 12      at org springframework test context junit4 SpringJUnit4ClassRunner methodBlock SpringJUnit4ClassRunner java 292      at org springframework test context junit4 SpringJUnit4ClassRunner runChild SpringJUnit4ClassRunner java 233      at org springframework test context junit4 SpringJUnit4ClassRunner runChild SpringJUnit4ClassRunner java 87      at org junit runners ParentRunner 3 run ParentRunner java 238      at org junit runners ParentRunner 1 schedule ParentRunner java 63      at org junit runners ParentRunner runChildren ParentRunner java 236      at org junit runners ParentRunner access 000 ParentRunner java 53      at org junit runners ParentRunner 2 evaluate ParentRunner java 229      at org springframework test context junit4 statements RunBeforeTestClassCallbacks evaluate RunBeforeTestClassCallbacks java 61      at org springframework test context junit4 statements RunAfterTestClassCallbacks evaluate RunAfterTestClassCallbacks java 71      at org junit runners ParentRunner run ParentRunner java 309      at org springframework test context junit4 SpringJUnit4ClassRunner run SpringJUnit4ClassRunner java 176      at org apache maven surefire junit4 JUnit4Provider execute JUnit4Provider java 264      at org apache maven surefire junit4 JUnit4Provider executeTestSet JUnit4Provider java 153      at org apache maven surefire junit4 JUnit4Provider invoke JUnit4Provider java 124      at org apache maven surefire booter ForkedBooter invokeProviderInSameClassLoader ForkedBooter java 200      at org apache maven surefire booter ForkedBooter runSuitesInProcess ForkedBooter java 153      at org apache maven surefire booter ForkedBooter main ForkedBooter java 103  Caused by  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   Instantiation of bean failed  nested exception is org springframework beans factory BeanDefinitionStoreException  Factory method  public javax sql DataSource org springframework boot autoconfigure jdbc DataSourceAutoConfiguration NonEmbeddedConfiguration dataSource    threw exception  nested exception is org springframework beans factory BeanCreationException  Cannot determine embedded database driver class for database type NONE  If you want an embedded database please put a supported one on the classpath

User · Answer

I was facing the same problem for several days  and finally the issue isn t with the code  the problem commes from maven  you must delete all the files that he downloaded from your hard drive  C  Users username m2 repository   and do another update maven for your project  that will fix your problem

User · Answer

In my case I just ignored the following in application properties file     Hibernate   spring jpa hibernate ddl-auto update  It works for me

User · Answer

Are you running the application as a jar    java -jar xxxx jar   If so  do you have the application properties stored in that jar    If no  try to figure out why     To be automatically package in the jar  the files can be in   src main resources application properties The maven plugin in the pom xml can also be configured

User · Answer

This problem comes while you are running Test  Add dependency   testCompile group   com h2database   name   h2   version   1 4 197     Add folder resources under test source add file bootstrap yml and provide content   spring    datasource      type  com zaxxer hikari HikariDataSource     url  jdbc h2 mem TEST     driver-class-name  org h2 Driver     username  username     password  password     hikari        idle-timeout  10000   this will setup your data source

User · Answer

It worked for me you can try your  Add this to VM options in Tomcat  -DdevBaseDir  C  Your Project Dir Path

User · Answer

change below line of code  spring datasource driverClassName   to  spring datasource driver-class-name

User · Answer

If you re using application properties in spring boot app  then just put the below line into application properties and it should work  spring datasource url  jdbc mysql   google  cloudSqlInstance  amp socketFactory com google cloud sql mysql SocketFactory amp user      amp password

User · Answer

Created database in MySQL create database springboot2   application properties spring datasource driver-class-name com mysql cj jdbc Driver spring datasource url   jdbc mysql   localhost 3306 springboot2 spring datasource username   root spring datasource password   root spring jpa show-sql   true spring jpa hibernate ddl-auto   update spring jpa properties hibernate dialect   org hibernate dialect MySQL5Dialect server port 9192  pom xml  lt dependencies gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-data-jpa lt  artifactId gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-web lt  artifactId gt           lt  dependency gt            lt dependency gt               lt groupId gt mysql lt  groupId gt               lt artifactId gt mysql-connector-java lt  artifactId gt               lt scope gt runtime lt  scope gt           lt  dependency gt           lt dependency gt               lt groupId gt org projectlombok lt  groupId gt               lt artifactId gt lombok lt  artifactId gt               lt optional gt true lt  optional gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-test lt  artifactId gt               lt scope gt test lt  scope gt               lt exclusions gt                   lt exclusion gt                       lt groupId gt org junit vintage lt  groupId gt                       lt artifactId gt junit-vintage-engine lt  artifactId gt                   lt  exclusion gt               lt  exclusions gt           lt  dependency gt       lt  dependencies gt   main class import org springframework boot SpringApplication  import org springframework boot autoconfigure SpringBootApplication    SpringBootApplication public class Application        public static void main String   args            SpringApplication run Application class  args             model class package com First Try springboot entity       import javax persistence Entity  import javax persistence GeneratedValue  import javax persistence Id  import javax persistence Table   import lombok AllArgsConstructor  import lombok Data  import lombok NoArgsConstructor   Data  AllArgsConstructor   NoArgsConstructor  Entity  Table name  quot PRODUCT TBL1 quot   public class Product        Id      GeneratedValue     private int id      private String name      private int quantity      private double price

User · Answer

Looks like the initial problem is with the auto-config   If you don t need the datasource  simply remove it from the auto-config process    EnableAutoConfiguration exclude  DataSourceAutoConfiguration class

User · Answer

Give you something different  when you encounter this kind of error  cannot create  bean datasource in a test case   It might be caused by some reasons    No datasource  you will need to create your datasource  h2 in-memory datasource or whatever  or you can choose the way like exclude  datasource       You have your datasource  like MySQL  but it still not work  It was caused by class AutoConfigureTestDatabase  It will choose a datasource for you which may cause ambiguity    Solution  add  AutoConfigureTestDatabase replace   AutoConfigureTestDatabase Replace NONE  to avoid replace the default datasource

User · Answer

Not directly related to the original question but this will be useful for someone  This error occurred to me with a simple two project structure  One project was handling some database operations with spring JDBC  say A  and the other did not have any JDBC operations at all say B   But still  this error appeared while I was starting service B  Saying the datasource should be initialized properly   As I figured out I had added this dependency to the parent pom of the two modules   lt dependency gt       lt groupId gt org springframework boot lt  groupId gt       lt artifactId gt spring-boot-starter-jdbc lt  artifactId gt   lt  dependency gt    This caused spring to initialize the JDBC dependencies for project B too  So  I moved it to project A s pom  everything was fine   Hope this would help someone

User · Answer

I was facing this issue even after supplying all required datasource properties in application properties  Then I realized that properties configuration class was not getting scanned by Spring boot because it was in different package hierarchy compared to my Spring boot Application java and hence no properties were applied to datasource object   I changed the package name of my properties configuration class and it started working

User · Answer

From the looks of things you haven t passed enough data to Spring Boot to configure the datasource  Create In your existing application properties add the following  spring datasource driverClassName  spring datasource url  spring datasource username  spring datasource password    making sure you append a value for each of properties

User · Answer

The hibernate   properties are useless  they should be spring jpa   properties  Not to mention that you are trying to override those already set by using the spring jpa   properties   For the explanation of each property I strongly suggest a read of the Spring Boot reference guide   spring jpa database-platform   org hibernate dialect MySQL5Dialect spring jpa show-sql   true    Hibernate spring jpa hibernate ddl-auto update   Also the packages to scan are automatically detected based on the base package of your Application class  If you want to specify something else use the  EntityScan annotation  Also specifying the most toplevel package isn t really wise as it will scan the whole class path which will severely impact performance

User · Answer

I solved my problem with the change of the parent Spring Boot Dependency    lt parent gt       lt groupId gt org springframework boot lt  groupId gt       lt artifactId gt spring-boot-starter-parent lt  artifactId gt       lt version gt 2 1 0 RELEASE lt  version gt   lt  parent gt    to   lt parent gt       lt groupId gt org springframework boot lt  groupId gt       lt artifactId gt spring-boot-starter-parent lt  artifactId gt       lt version gt 2 0 6 RELEASE lt  version gt   lt  parent gt    For more Information  take a look at the release notes  Spring Boot 2 1 0 Release Notes

User · Answer

I was getting the same error  found out it was due to some of the dependencies missing in my pom xml like that of Spring JPA  Hibernate  Mysql or maybe Jackson  So make sure that dependencies are not missing in your pom xml and check their version compatibility    lt  -- Jpa and hibernate -- gt   lt dependency gt       lt groupId gt org springframework lt  groupId gt       lt artifactId gt spring-orm lt  artifactId gt       lt version gt 4 2 2 RELEASE lt  version gt   lt  dependency gt   lt dependency gt       lt groupId gt org hibernate lt  groupId gt       lt artifactId gt hibernate-entitymanager lt  artifactId gt       lt version gt 5 0 3 Final lt  version gt   lt  dependency gt   lt dependency gt       lt groupId gt mysql lt  groupId gt       lt artifactId gt mysql-connector-java lt  artifactId gt       lt version gt 5 1 6 lt  version gt   lt  dependency gt

User · Answer

In my case this was happening because org springframework boot autoconfigure orm jpa JpaBaseConfiguration dataSource is an autowired field without a Qualifier and I am using multiple datasources with qualified names   I solved this problem by using  Primary arbitrarily on one of my dataSource bean configurations like so   Primary  Bean name  oneOfManyDataSources   public DataSource dataSource             I suppose they want you to implement AbstractRoutingDataSource  and then that auto configuration will just work because no qualifier is needed  you just have a single data source that allows your beans to resolve to the appropriate DataSource as needed   Then you don t need the  Primary or  Qualifier annotations at all  because you just have a single DataSource   In any case  my solution worked because my beans specify DataSource by qualifier  and the JPA auto config stuff is happy because it has a single primary DataSource   I am by no means recommending this as the  right  way to do things  but in my case it solved the problem quickly and did not deter the behavior of my application in any noticeable manner   Will hopefully one day get around to implementing the AbstractRoutingDataSource and refactoring all the beans that need a specific DataSource and then perhaps that will be a neater solution

User · Answer

Maybe you forgot the MySQL JDBC driver    lt dependency gt       lt groupId gt mysql lt  groupId gt       lt artifactId gt mysql-connector-java lt  artifactId gt       lt version gt 5 1 34 lt  version gt   lt  dependency gt

User · Answer

Check that you have database dependency at runtime group at build gradle  runtime group   com h2database   name   h2   version   1 4 194    or change scope from test to runtime if you use Maven   lt dependency gt       lt groupId gt com h2database lt  groupId gt       lt artifactId gt h2 lt  artifactId gt       lt version gt 1 4 194 lt  version gt       lt scope gt runtime lt  scope gt   lt  dependency gt

[java] Spring Boot - Error creating bean with name 'dataSource' defined in class path resource

Examples related to java

Examples related to spring

Examples related to spring-boot