SpringBoot2.0.3打印默認數(shù)據(jù)源為 HikariDataSource (null)

剛剛開始以為DataSource是空對象，后來打印了下面的語句，才知道DataSource不是空的，我砸，我就好奇為什么 打印出HikariDataSource (null) 這樣的語句，真的坑。

    @Autowired
    DataSource dataSource;
    @Autowired
    DataSourceProperties dataSourceProperties;
    @Test
    public void contextLoads() throws SQLException {
        System.out.println(String.format("數(shù)據(jù)源配置類：用戶名：%s,"
        +"密碼：%s,資源定位符：%s,驅動：%s"
                ,dataSourceProperties.getUsername(),
                dataSourceProperties.getPassword(),
                dataSourceProperties.getUrl(),
                dataSourceProperties.getDriverClassName()));
        System.out.println(dataSource == null);//結果為：false
        System.out.println("得到的數(shù)據(jù)源："+dataSource);
        System.out.println("得到的連接："+dataSource.getConnection());
    }

打印結果

得到的數(shù)據(jù)源：HikariDataSource (null) 2020-09-08 00:16:53.612 INFO 13316 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... Tue Sep 08 00:16:53 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2020-09-08 00:16:54.330 INFO 13316 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.

得到的連接：HikariProxyConnection@722513129 wrapping com.mysql.jdbc.JDBC4Connection@52169758 2020-09-08 00:16:54.335 INFO 13316 --- [ Thread-2] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@5b799640: startup date [Tue Sep 08 00:16:51 CST 2020]; root of context hierarchy 2020-09-08 00:16:54.337 INFO 13316 --- [ Thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2020-09-08 00:16:54.339 INFO 13316 --- [ Thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.

需要注意

SpringBoot2.0.3使用的Driver是com.mysql.jdbc.Driver

springboot的HikariDataSource默認配置的默認值如下

validation-query配置數(shù)據(jù)庫時，屬性validationQuery默認值為“select 1”，對于oracle值應為“select 1 from dual”

validationQuery屬性：用來驗證數(shù)據(jù)庫連接的語句，這個語句至少是返回一條數(shù)據(jù)的查詢語句。每種數(shù)據(jù)庫都有自己的驗證語句。

以下是不同數(shù)據(jù)庫對應的驗證語句：

以上為個人經(jīng)驗，希望能給大家一個參考，也希望大家多多支持腳本之家。