Disable all Database related auto configuration in Spring Boot

Question

I am using Spring Boot to develop two applications  one serves as the server and other one is a client app  However  both of them are the same app that function differently based on the active profile  I am using auto configuration feature of Spring Boot to configure my applications    I want to disable all the database related auto configuration on client app  since it won t be requiring database connection  Application should not try to establish connection with the database  nor try to use any of the Spring Data or Hibernate features  The enabling or disabling of the database auto configuration should be conditional and based on the active profile of the app   Can I achieve this by creating two different application properties files for respective profiles    I tried adding this to my properties file   spring autoconfigure exclude org springframework boot autoconfigure orm jpa HibernateJpaAutoConfiguration    org springframework boot autoconfigure jdbc DataSourceAutoConfiguration  org springframework boot autoconfigure jdbc DataSourceTransactionManagerAutoConfiguration    org springframework boot autoconfigure data web SpringDataWebAutoConfiguration   But  the application still tries to connect to the database on start  Are those exclusions sufficient for achieving my requirement

User · Answer

Seems like you just forgot the comma to separate the classes. So based on your configuration the following will work:

spring.autoconfigure.exclude=org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration,\
    org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration,\
    org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration,\
    org.springframework.boot.autoconfigure.data.web.SpringDataWebAutoConfiguration

Alternatively you could also define it as follow:

spring.autoconfigure.exclude[0]=org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration
spring.autoconfigure.exclude[1]=org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration
spring.autoconfigure.exclude[2]=org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration
spring.autoconfigure.exclude[3]=org.springframework.boot.autoconfigure.data.web.SpringDataWebAutoConfiguration

User · Answer

The way I would do similar thing is    Configuration  EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class    Profile   client app profile name   public class ClientAppConfiguration         it can be left blank     Write similar one for the server app  without excludes     Last step is to disable Auto Configuration from main spring boot class    SpringBootApplication public class SomeApplication extends SpringBootServletInitializer        public static void main String   args            SpringApplication run SomeApplication class              protected SpringApplicationBuilder configure SpringApplicationBuilder application            return application sources SomeApplication class             Change   SpringBootApplication into    Configuration   ComponentScan   This should do the job  Now  the dependencies that I excluded in the example might be incomplete  They were enough for me  but im not sure if its all to completely disable database related libraries  Check the list below to be sure   http   docs spring io spring-boot docs current-SNAPSHOT reference htmlsingle  auto-configuration-classes  Hope that helps

User · Answer

Another way to control it via Profiles is this      note  no  SpringApplication annotation here  Import DatabaseConfig class  public class Application        public static void main String   args            SpringApplication run Application class  args             Configuration  Import  DatabaseConfig WithDB class  DatabaseConfig WithoutDB class   public class DatabaseConfig         Profile   db        EnableAutoConfiguration              exclude    DataSourceAutoConfiguration class    DataSourceTransactionManagerAutoConfiguration class                  HibernateJpaAutoConfiguration class       static class WithoutDB                Profile  db        EnableAutoConfiguration     static class WithDB

User · Answer

Way out for me was to add    EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class     annotation to class running Spring boot  marked with   SpringBootApplication    Finally  it looks like    SpringBootApplication  EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class   public class Application       public static void main String   args            SpringApplication run Application class  args

User · Answer

I was getting this error even if I did all the solutions mentioned above     by  org springframework beans factory BeanCreationException  Error creating bean with name  dataSource  defined in class path resource  org springframework boot autoconfigure jdbc DataSourceConfig       At some point when i look up the POM there was this dependency in it    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    And the Pojo class had the following imports  import javax persistence Entity  import javax persistence GeneratedValue  import javax persistence Id   Which clearly shows the application was expecting a datasource   What I did was I removed the JPA dependency from pom and replaced the imports for the pojo with the following once   import org springframework data annotation Id  import org springframework data mongodb core mapping Document   Finally I got SUCCESSFUL build  Check it out you might have run into the same problem

User · Answer

For disabling all the database related autoconfiguration and exit from       Cannot determine embedded database driver class for database type NONE   1  Using annotation    SpringBootApplication  EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class   public class Application        public static void main String   args            SpringApplication run PayPalApplication class  args             2  Using Application properties   spring autoconfigure exclude org springframework boot autoconfigure jdbc DataSourceAutoConfiguration  org springframework boot autoconfigure orm jpa HibernateJpaAutoConfiguration

User · Answer

I add in myApp java  after  SpringBootApplication      EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class     And changed       SpringBootApplication     Configuration   So  I have this in my main class  myApp java   package br com company project app   import org springframework boot SpringApplication  import org springframework boot autoconfigure EnableAutoConfiguration  import org springframework boot autoconfigure jdbc DataSourceAutoConfiguration  import org springframework boot autoconfigure jdbc DataSourceTransactionManagerAutoConfiguration  import org springframework boot autoconfigure orm jpa HibernateJpaAutoConfiguration  import org springframework context annotation Configuration    Configuration  EnableAutoConfiguration exclude    DataSourceAutoConfiguration class  DataSourceTransactionManagerAutoConfiguration class  HibernateJpaAutoConfiguration class   public class SomeApplication    public static void main String   args        SpringApplication run SomeApplication class  args          And work for me

User · Answer

I had the same problem here  solved like this   Just add another application- yourprofile  yml where  yourprofile  could be  client     In my case I just wanted to remove Redis in a Dev profile  so I added a application-dev yml next to the main application yml and it did the job   In this file I put   spring autoconfigure exclude  org springframework boot autoconfigure data redis RedisAutoConfiguration org springframework boot autoconfigure data redis RedisRepositoriesAutoConfiguration      this should work with properties files as well    I like the fact that there is no need to change the application code to do that

User · Answer

There s a way to exclude specific auto-configuration classes using  SpringBootApplication annotation    Import MyPersistenceConfiguration class   SpringBootApplication exclude             DataSourceAutoConfiguration class           DataSourceTransactionManagerAutoConfiguration class          HibernateJpaAutoConfiguration class   public class MySpringBootApplication                public static void main String   args            SpringApplication run MySpringBootApplication class  args              SpringBootApplication exclude attribute is an alias for  EnableAutoConfiguration exclude attribute and I find it rather handy and useful  I added  Import MyPersistenceConfiguration class  to the example to demonstrate how you can apply your custom database configuration

User · Answer

Also if you use Spring Actuator org springframework boot actuate autoconfigure jdbc DataSourceHealthContributorAutoConfiguration might be initializing DataSource as well

[spring] Disable all Database related auto configuration in Spring Boot

Examples related to spring

Examples related to hibernate

Examples related to spring-boot

Examples related to spring-data

Examples related to spring-data-jpa