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

剛剛開始以為DataSource是空對(duì)象，后來打印了下面的語句，才知道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,驅(qū)動(dòng)：%s"
                ,dataSourceProperties.getUsername(),
                dataSourceProperties.getPassword(),
                dataSourceProperties.getUrl(),
                dataSourceProperties.getDriverClassName()));
        System.out.println(dataSource == null);//結(jié)果為：false
        System.out.println("得到的數(shù)據(jù)源："+dataSource);
        System.out.println("得到的連接："+dataSource.getConnection());
    }

打印結(jié)果

得到的數(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默認(rèn)配置的默認(rèn)值如下

validation-query配置數(shù)據(jù)庫時(shí)，屬性validationQuery默認(rèn)值為“select 1”，對(duì)于oracle值應(yīng)為“select 1 from dual”

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

以下是不同數(shù)據(jù)庫對(duì)應(yīng)的驗(yàn)證語句：

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

最新評(píng)論