Spring JPA初始化失败抛出RuntimeException，数据库连接可选时如何处理？

问题根因 #

你设置的spring.sql.init.continue-on-error配置仅作用于Spring Boot启动阶段执行SQL初始化脚本的错误容错，对数据源连接、JPA/Hibernate上下文初始化阶段的错误不生效。你遇到的启动失败本质是JPA的EntityManagerFactory初始化时无法连接数据库、无法自动获取数据库方言导致的。

1. 禁用默认的数据库相关自动配置 #

在启动类的@SpringBootApplication注解中排除数据库、JPA、事务的默认自动配置类，避免启动时强制初始化数据库组件：

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration;
import org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration;

@SpringBootApplication(exclude = {
        DataSourceAutoConfiguration.class,
        DataSourceTransactionManagerAutoConfiguration.class,
        HibernateJpaAutoConfiguration.class
})
public class ChiralGatewayApplication {
    public static void main(String[] args) {
        SpringApplication.run(ChiralGatewayApplication.class, args);
    }
}

2. 新增自定义数据库配置类，加加载条件 #

先在配置文件（application.yml/application.properties）中新增数据库开关配置：

db:
  enabled: true # 不需要使用数据库的设备将该值改为false即可

新增数据库配置类，仅当db.enabled=true时才加载数据库相关组件：

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Conditional;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;

@Configuration
@ConditionalOnProperty(prefix = "db", name = "enabled", havingValue = "true")
@EnableJpaRepositories(basePackages = "替换为你项目中Repository接口所在的包路径")
@EnableTransactionManagement
public class DatabaseConfig {

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory(DataSource dataSource) {
        LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(dataSource);
        // 替换为你项目中实体类所在的包路径
        em.setPackagesToScan("替换为你项目中实体类所在的包路径");
        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        em.setJpaVendorAdapter(vendorAdapter);
        // 配置Hibernate属性，和你之前使用的配置保持一致即可
        Map<String, Object> properties = new HashMap<>();
        // 手动指定方言，避免Hibernate连接失败时自动探测方言报错
        properties.put("hibernate.dialect", "org.hibernate.dialect.PostgreSQLDialect");
        properties.put("hibernate.hbm2ddl.auto", "update");
        properties.put("hibernate.show_sql", "false");
        em.setJpaPropertyMap(properties);
        return em;
    }

    @Bean
    public PlatformTransactionManager transactionManager(EntityManagerFactory entityManagerFactory) {
        return new JpaTransactionManager(entityManagerFactory);
    }
}

3. 数据库组件注入时添加非必需标识 #

所有用到Repository、JdbcTemplate等数据库相关Bean的位置，注入时添加required = false配置，避免无数据库环境下注入失败：

@Autowired(required = false)
private UserRepository userRepository;

调用数据库相关逻辑前先判空，执行降级逻辑：

if (userRepository != null) {
    // 执行数据库操作
} else {
    // 执行无数据库场景下的兼容逻辑
}

内容的提问来源于stack exchange，提问作者Chiral Systems