企业官网建设流程全解析

闪灵企业建站系统,成都做小程序的公司,手机网站建设万网,网站建设考级initializationFailTimeout 参数详解 正值#xff1a;尝试获取初始连接的毫秒数#xff0c;期间会阻塞应用线程0值#xff1a;尝试获取并验证连接#xff0c;失败则抛出异常负值#xff1a;绕过初始连接尝试#xff0c;立即启动连接池#xff08;后台尝试连接#xff…initializationFailTimeout参数详解正值尝试获取初始连接的毫秒数期间会阻塞应用线程0值尝试获取并验证连接失败则抛出异常负值绕过初始连接尝试立即启动连接池后台尝试连接解决方案方案一设置负值立即启动后台重连⭐️推荐spring:datasource:sqlserver:url:jdbc:sqlserver://localhost:1433;databaseNamemydbusername:sapassword:passwordhikari:initialization-fail-timeout:-1# 关键立即启动后台连接connection-timeout:30000# 获取连接超时30秒validation-timeout:5000# 验证超时5秒connection-test-query:SELECT 1# 验证查询方案二配置类方式ConfigurationpublicclassSqlServerDataSourceConfig{Bean(namesqlServerDataSource)ConfigurationProperties(spring.datasource.sqlserver)publicDataSourcesqlServerDataSource(){HikariDataSourcedataSourceDataSourceBuilder.create().type(HikariDataSource.class).build();// 关键配置设置为负值应用立即启动dataSource.setInitializationFailTimeout(-1);// 其他推荐配置dataSource.setConnectionTimeout(30000);dataSource.setValidationTimeout(5000);dataSource.setConnectionTestQuery(SELECT 1);dataSource.setMinimumIdle(1);dataSource.setMaximumPoolSize(10);dataSource.setIdleTimeout(600000);returndataSource;}}方案三结合Spring Retry实现智能重连ConfigurationEnableRetrypublicclassResilientDataSourceConfig{BeanRetryable(value{SQLException.class},maxAttempts3,backoffBackoff(delay5000,multiplier1.5))publicDataSourcesqlServerDataSource(){HikariConfigconfignewHikariConfig();config.setJdbcUrl(jdbc:sqlserver://localhost:1433;databaseNamemydb);config.setUsername(sa);config.setPassword(password);// 核心配置应用立即启动config.setInitializationFailTimeout(-1);// 连接验证配置config.setConnectionTestQuery(SELECT 1);config.setConnectionTimeout(30000);returnnewHikariDataSource(config);}RecoverpublicDataSourcefallbackDataSource(){// 创建降级数据源返回一个会抛出有意义异常的数据源returnnewDataSource(){OverridepublicConnectiongetConnection()throwsSQLException{thrownewSQLException(SQL Server数据源尚未就绪请稍后重试);}OverridepublicConnectiongetConnection(Stringusername,Stringpassword)throwsSQLException{thrownewSQLException(SQL Server数据源尚未就绪请稍后重试);}OverridepublicPrintWritergetLogWriter(){returnnull;}OverridepublicvoidsetLogWriter(PrintWriterout){}OverridepublicintgetLoginTimeout(){return0;}OverridepublicvoidsetLoginTimeout(intseconds){}Overridepublicjava.util.logging.LoggergetParentLogger(){returnnull;}OverridepublicTTunwrap(ClassTiface){returnnull;}OverridepublicbooleanisWrapperFor(Class?iface){returnfalse;}};}}方案四完整的YAML配置示例spring:datasource:# 主数据源必需url:jdbc:mysql://localhost:3306/main_dbusername:rootpassword:rootdriver-class-name:com.mysql.cj.jdbc.Driverhikari:maximum-pool-size:20minimum-idle:5# SQL Server数据源可选可失败sqlserver:url:${SQLSERVER_URL:jdbc:sqlserver://localhost:1433;databaseNamemydb}username:${SQLSERVER_USER:sa}password:${SQLSERVER_PWD:password}driver-class-name:com.microsoft.sqlserver.jdbc.SQLServerDriverhikari:initialization-fail-timeout:-1# 立即启动应用connection-timeout:30000# 连接超时30秒validation-timeout:5000# 验证超时5秒maximum-pool-size:10minimum-idle:1idle-timeout:600000# 10分钟空闲超时max-lifetime:1800000# 30分钟最大生命周期connection-test-query:SELECT 1pool-name:SQLServerPool# Spring Boot 应用级配置main:allow-bean-definition-overriding:true# 允许覆盖Bean定义lazy-initialization:false# 不建议全局懒加载# 健康检查配置management:health:db:enabled:trueignore-failures-initialization:true# 忽略初始化失败endpoint:health:show-details:alwaysenabled:true方案五监听连接状态并自动恢复ComponentSlf4jpublicclassDataSourceHealthMonitor{Autowired(requiredfalse)Qualifier(sqlServerDataSource)privateDataSourcesqlServerDataSource;PostConstructpublicvoidinit(){if(sqlServerDataSource!nullsqlServerDataSourceinstanceofHikariDataSource){HikariDataSourcehikariDS(HikariDataSource)sqlServerDataSource;// 定期检查连接状态ScheduledExecutorServiceschedulerExecutors.newScheduledThreadPool(1);scheduler.scheduleAtFixedRate(()-{try{if(hikariDS.getHikariPoolMXBean()!null){intactiveConnectionshikariDS.getHikariPoolMXBean().getActiveConnections();intidleConnectionshikariDS.getHikariPoolMXBean().getIdleConnections();inttotalConnectionshikariDS.getHikariPoolMXBean().getTotalConnections();log.info(SQL Server连接池状态: 活跃{}, 空闲{}, 总计{},activeConnections,idleConnections,totalConnections);// 尝试测试连接try(ConnectionconnhikariDS.getConnection()){log.info(SQL Server连接测试成功);}}}catch(Exceptione){log.warn(SQL Server连接检查失败: {},e.getMessage());// 可以在这里触发重连逻辑}},30,60,TimeUnit.SECONDS);// 30秒后开始每60秒检查一次}}}最佳实践总结首选配置initialization-fail-timeout: -1应用立即启动连接池在后台尝试连接不会阻塞应用启动流程配合健康检查使用Spring Boot Actuator监控数据源状态优雅降级为可选数据源提供降级逻辑环境区分开发环境可以宽松配置生产环境需要完善的监控日志记录详细记录连接状态便于问题排查这样配置后即使SQL Server暂时不可用Spring Boot应用也能正常启动待数据库恢复后会自动建立连接。