Spring Boot应用HikariCP配置异常：K8s部署报错无法识别驱动

• 基于Spring Boot 2.6.6（JDK11）开发，配置HikariCP解决压测时数据库连接耗尽问题
• 本地IntelliJ环境运行正常，部署到Kubernetes集群后启动失败，报错无法确定合适的驱动类
• 已手动配置spring.datasource.driver-class-name，且Spring Boot本应通过URL自动识别驱动，但两种方式均未生效

Maven依赖 #

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>${spring.boot.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-tomcat</artifactId>
    <version>${spring.boot.version}</version>
    <scope>provided</scope>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-actuator</artifactId>
    <version>${spring.boot.version}</version>
</dependency>
<dependency>
    <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>21.9.0.0</version>
</dependency>

application.properties配置 #

spring.datasource.url=jdbc:oracle:thin:@......
spring.datasource.username=test
spring.datasource.password=test
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.main.allow-bean-definition-overriding=true

#connection pool configuration
spring.datasource.hikari.pool-name=SVMConnectionPool
spring.datasource.hikari.maximum-pool-size=60

错误日志 #

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
2023-07-14T05:34:41.696439652Z      at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
2023-07-14T05:34:41.696442966Z      at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
2023-07-14T05:34:41.696445978Z      ... 121 more
2023-07-14T05:34:41.696449043Z  Caused by: org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
        at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.determineDriverClassName(DataSourceProperties.java:252)
        at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.initializeDataSourceBuilder(DataSourceProperties.java:193)
2023-07-14T05:34:41.696457775Z      at org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration.createDataSource(DataSourceConfiguration.java:48)
2023-07-14T05:34:41.696460846Z      at org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari.dataSource(DataSourceConfiguration.java:90)
2023-07-14T05:34:41.696464391Z      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-07-14T05:34:41.696467454Z      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-07-14T05:34:41.696470269Z      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-07-14T05:34:41.696473242Z      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)

排查与解决方案 #

1. 确认K8s镜像依赖完整性
   进入容器执行jar tf your-app.jar，检查是否包含oracle/jdbc/OracleDriver.class，确保ojdbc8依赖被正确打包进镜像，避免构建时遗漏依赖。
2. 检查配置是否被覆盖
   验证K8s中是否通过ConfigMap、Secret或环境变量覆盖了数据源配置，导致本地的driver-class-name配置未生效。可添加--debug启动参数，查看Spring Boot实际加载的配置参数。
3. 验证URL格式正确性
   确认K8s环境中的spring.datasource.url完整且格式正确（比如Oracle URL的主机、端口、服务名/SID是否正确），URL错误会导致自动识别驱动失败，甚至手动配置驱动类也会因URL解析问题报错。
4. 手动配置DataSource绕过自动逻辑
   自定义配置类直接初始化HikariDataSource，强制指定驱动类：

   @Configuration
   public class DataSourceConfig {
       @Value("${spring.datasource.url}")
       private String url;
       @Value("${spring.datasource.username}")
       private String username;
       @Value("${spring.datasource.password}")
       private String password;
       @Value("${spring.datasource.driver-class-name}")
       private String driverClassName;
       @Value("${spring.datasource.hikari.maximum-pool-size}")
       private int maxPoolSize;
       @Value("${spring.datasource.hikari.pool-name}")
       private String poolName;
   
       @Bean
       public HikariDataSource dataSource() {
           HikariConfig config = new HikariConfig();
           config.setJdbcUrl(url);
           config.setUsername(username);
           config.setPassword(password);
           config.setDriverClassName(driverClassName);
           config.setMaximumPoolSize(maxPoolSize);
           config.setPoolName(poolName);
           return new HikariDataSource(config);
       }
   }
   

5. 对齐JDK版本
   确认K8s容器使用的JDK版本为11，与本地开发环境一致，避免版本差异导致驱动类加载异常。

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