How to start spring-boot app without depending on Database?

by

It was indeed a tough nut to crack.

After lot and lot of research and actually debugging the spring-boot, spring, hibernate, tomcat pool, etc to get it done.

I do think that it will save lot of time for people trying to achieve this type of requirement.

Below are the settings required to achieve the following requirement

  1. Spring boot apps will start fine even if DB is down or there is no DB.
  2. Apps will pick up the connections on the fly as DB comes up which means there is no need to restart the web server or redeploy the apps.
  3. There is no need to start the tomcat or redeploy the apps, if DB goes down from running state and comes up again.

application.yml :

spring:
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/schema
    username: root
    password: root
    continueOnError: true
    initialize: false
    initialSize: 0
    timeBetweenEvictionRunsMillis: 5000
    minEvictableIdleTimeMillis: 5000
    minIdle: 0

  jpa:
    show-sql: true
    hibernate:
      ddl-auto: none
      naming_strategy: org.hibernate.cfg.DefaultNamingStrategy
    properties:
      hibernate:   
        dialect: org.hibernate.dialect.MySQL5Dialect
        hbm2ddl:
          auto: none
        temp:
          use_jdbc_metadata_defaults: false

More Related Contents:

  1. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  2. How to use Spring Boot with MySQL database and JPA?
  3. What is this spring.jpa.open-in-view=true property in Spring Boot?
  4. Spring Boot, Spring Data JPA with multiple DataSources
  5. Connection to Db dies after >4
  6. Unable to get spring boot to automatically create database schema
  7. Spring boot – Not a managed type
  8. No Dialect mapping for JDBC type: 1111
  9. tomcat7 – jdbc datasource – This is very likely to create a memory leak
  10. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  11. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  12. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  13. Escaping the colon character ‘:’ in JPA queries
  14. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  15. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  16. Multiple data source and schema creation in Spring Boot
  17. SQL Query needed for fetch value from Two identical table but not fully identical table
  18. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  19. MySQL: Insert record if not exists in table [duplicate]
  20. MySQL Query GROUP BY day / month / year
  21. java.lang.NoClassDefFoundError: org/springframework/core/env/ConfigurableEnvironment
  22. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  23. Export a MySQL Database to SQLite Database
  24. SQL search multiple values in same field
  25. Removing duplicates with unique index
  26. MySQL – Select the last inserted row easiest way
  27. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  28. ALTER table – adding AUTOINCREMENT in MySQL
  29. Array data type, split string,
  30. How can I make a table in MySQL called “order”?

Leave a Comment