这对我在 Spring Boot 2.3.2.RELEASE 中很有效

application.properties：

spring.datasource.hikari.data-source-properties.oracle.jdbc.timezoneAsRegion=true
spring.datasource.hikari.data-source-properties.oracle.jdbc.timestampTzInGmt=true

检查：

@Autowired
private DataSource dataSource;
logger.info(dataSource.getConnection().unwrap(OracleConnection.class).getProperties().getProperty("oracle.jdbc.timezoneAsRegion"));
logger.info(dataSource.getConnection().unwrap(OracleConnection.class).getProperties().getProperty("oracle.jdbc.timestampTzInGmt"));

输出：

true

真正的

这就像在 DataSource 中添加新的 addDataSourceProperty 一样简单

public class DataSource {
    private static HikariConfig config = new HikariConfig();
    private static HikariDataSource ds;
    static {
        config.setJdbcUrl( "jdbc_url" );
        config.setUsername( "database_username" );
        config.setPassword( "database_password" );
        config.addDataSourceProperty( "oracle.jdbc.timezoneAsRegion" , "true" );
        config.addDataSourceProperty( "oracle.jdbc.timestampTzInGmt" , "true" );
        ds = new HikariDataSource( config );
    private DataSource() {}
    public static Connection getConnection() throws SQLException {
        return ds.getConnection();
}

要验证连接中的设置，必须首先使用获取Oracle连接

def hkConn = DataSource.getConnection() 
def conn  = hkConn.unwrap(OracleConnection.class); 
println conn.getProperties().getProperty("oracle.jdbc.timezoneAsRegion");
println conn.getProperties().getProperty("oracle.jdbc.timestampTzInGmt");

它返回

true
true

使用HikariCP-2.7.2和Oracle 12.1进行测试

你在用Spring Boot吗？

如果你使用的是Spring Boot，你可以尝试通过属性进行设置：

spring.datasource.hikari.*= # Hikari specific settings

https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html

使用MySQL的属性文件的一个示例：

spring.datasource.hikari.mysql.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.hikari.mysql.jdbc-url=jdbc:mysql://10.0.9.198:3306/develop_report?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&rewriteBatchedStatements=true
spring.datasource.hikari.mysql.username=root
spring.datasource.hikari.mysql.password=123456
spring.datasource.hikari.mysql.minimum-idle=5
spring.datasource.hikari.mysql.idle-timeout=180000
spring.datasource.hikari.mysql.maximum-pool-size=20