Failed to auto-configure a DataSource spring datasource url is not specified

Question

I have created a basic spring boot application from SPRING INITIALIZR with the Web  MongoDB and JPA dependencies    When I try to run the spring boot application I am getting the following exception   Error starting ApplicationContext  To display the conditions report re-run your application with  debug  enabled  2018-03-25 16 27 02 807 ERROR 16256 ---    restartedMain  o s b d LoggingFailureAnalysisReporter                                   APPLICATION FAILED TO START                             Description  Failed to auto-configure a DataSource   spring datasource url  is not specified and no embedded datasource could be auto-configured  Reason  Failed to determine a suitable driver class  Action   Consider the following situation  If you want an embedded database like H2  HSQL or Derby  please add it in the Classpath  If you have database settings to be loaded from a particular profile you may need to activate it since no profiles were currently active    In application properties file I am having the following configuration   server port 8081 spring data mongodb database TestDatabase spring data mongodb host localhost spring data mongodb port 27017   Versions which I use  Spring   5 0 4  MongoDB   3 6  Spring Boot  2 0

User · Answer

I encountered this error simply because I misspelled the spring.datasource.url value in the application.properties file and I was using postgresql:

Problem was: jdbc:postgres://localhost:<port-number>/<database-name>

Fixed to: jdbc:postgresql://localhost:<port-number>/<database-name>

NOTE: the difference is postgres & postgresql, the two are 2 different things.

Further causes and solutions may be found here

User · Answer

adding org apache derby dependency solved my issue     lt dependency gt               lt groupId gt org apache derby lt  groupId gt               lt artifactId gt derby lt  artifactId gt               lt scope gt runtime lt  scope gt           lt  dependency gt

User · Answer

Bhabadyuti Bal give us a good answer  in gradle you can use    compile  org springframework boot spring-boot-starter-data-jpa   compile  com h2database h2    in test time    testCompile  org reactivecommons utils object-mapper 0 1 0  testCompile  com h2database h2

User · Answer

your dependency based on data is trying to find their respective entities which one has not been created  comments the dependencies based on data and runs the app again    lt  --  lt dependency gt  -- gt           lt  --  lt groupId gt org springframework boot lt  groupId gt  -- gt           lt  --  lt artifactId gt spring-boot-starter-data-jpa lt  artifactId gt  -- gt           lt  --  lt  dependency gt  -- gt

User · Answer

I ran into this problem when I simply mistyped my jdbc url in application properties  Hope this helps someone  before   spring datasource url jdbc   localhost 3306 test   after   spring datasource url jdbc mysql   localhost 3306 test

User · Answer

Since you have added both mongodb and data-jpa dependencies in your pom xml file  it was creating a dependency conflict like below   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-data-mongodb lt  artifactId gt   lt  dependency gt    Try removing jpa dependency and run  It should work fine

User · Answer

Add your dependencies like mongodb web jpa  Delete clear the remainings    lt dependencies gt     lt dependency gt       lt groupId gt org springframework boot lt  groupId gt       lt artifactId gt spring-boot-starter-data-mongodb 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  dependencies gt

User · Answer

Seems there is missing MongoDB driver  Include the following dependency to pom xml    lt dependency gt       lt groupId gt org springframework boot lt  groupId gt       lt artifactId gt spring-boot-starter-data-mongodb lt  artifactId gt   lt  dependency gt

User · Answer

In gradle build i simply   compile  org springframework boot spring-boot-starter-data-jpa       compile  org springframework boot spring-boot-starter-security       compile  org springframework boot spring-boot-starter-web       compile  org springframework boot spring-boot-devtools    removed     compile  org springframework boot spring-boot-starter-data-jpa        and it worked for me

User · Answer

Go to resources folder where the application properties is present  update the below code in that   spring autoconfigure exclude org springframework boot autoconfigure jdbc DataSourceAutoConfiguration

User · Answer

Add the line below in application properties file under resource folder and restart your application   spring autoconfigure exclude org springframework boot autoconfigure jdbc DataSourceAutoConfiguration

User · Answer

This error occurred when you are putting JPA dependencies in your spring-boot configuration file like in maven or gradle  The solution is  Spring-Boot Documentation You have to specify the DB connection string and driver details in application properties file  This will solve the issue  This might help to someone

[java] Failed to auto-configure a DataSource: 'spring.datasource.url' is not specified

Examples related to java

Examples related to spring

Examples related to mongodb

Examples related to spring-boot

Examples related to spring-data-jpa