Spring Boot and Hibernate: Start an application even if a connection to the database is not available

Question

My Spring Boot application needs to connect to two different databases. The first database (main) is installed on the same server as the localhost application and the other database (secondary) on a remote server and that is not always available (for maintenance, backup, testing, etc.).

I use the following configuration (application.properties).

# main connection
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost/?autoReconnect=true&verifyServerCertificate=false&useSSL=false&requireSSL=false
spring.datasource.username=emater
spring.datasource.password=emater

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# secondary connection
planejamento.datasource.driverClassName=com.mysql.jdbc.Driver
planejamento.datasource.url=jdbc:mysql://10.22.1.4/?verifyServerCertificate=false&useSSL=false&requireSSL=false
planejamento.datasource.username=emater
planejamento.datasource.password=emater
planejamento.datasource.testWhileIdle = false

#config hibernate
spring.jpa.hibernate.ddl-auto=none
spring.jpa.properties.hibernate.dialect=org.hibernate.spatial.dialect.mysql.MySQLSpatial56Dialect
spring.jpa.properties.hibernate.current_session_context_class=org.springframework.orm.hibernate4.SpringSessionContext
spring.jpa.show-sql=true
spring.jpa.format-sql=true
spring.jpa.use-sql-comments=true
spring.jpa.hibernate.enable_lazy_load_no_trans=true

When initializing the application hibernate tries to connect to both databases. If the second database is not available at the time, an exception is thrown and application initialization is aborted.

Is there any property I could use to prevent my application from aborting at the time of its startup?

What should I do?

This link may be helpful https://docs.jboss.org/hibernate/orm/4.3/javadocs/org/hibernate/exception/JDBCConnectionException.html — Suresh A, Dec 06 '16 at 23:10
Would you have an example? Would it be a 'try / catch' in my application's main method? How would it be? — Fernando Frazão, Dec 06 '16 at 23:12
Put line SpringApplication.run(YourApplication.class, args); in between try catch .I think it will work . — Suresh A, Dec 07 '16 at 01:46
Check this answer: http://stackoverflow.com/a/23875516/3963330 — Tobías, Dec 07 '16 at 08:57
@Surace I did according to the content of the link, but unfortunately it did not work! — Fernando Frazão, Dec 07 '16 at 15:30

score 3 · Accepted Answer · answered Dec 08 '16 at 15:20

Hibernate requires to connect to the DB when the SessionFactory so that i can extract the DatabaseMetaData from a DB Connection.

With the DatabaseMetaData, it needs to find out:

the current catalog and schema
how to qualify identifiers
if the DB supports temporary tables
if the DDL causes Transaction commit
if the Driver supports scrollable ResultSet
if the Driver supports batch updates
if the Driver return generated keys for IDENTITY columns

This info is resolved when the SessionFactory is initialized, so you are better off starting a new MicroService lazily, when the associated database is avilable as well.

Spring Boot and Hibernate: Start an application even if a connection to the database is not available

1 Answers1