【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】OceanBase 4.2.5.3 (r103020032025042910-d7e41ea83305933e2cad3ac6c0584f557851f27b) (Built Apr 29 2025 11:23:53)
【问题描述】
Caused by: java.sql.SQLTransientConnectionException: (conn=3221498809) The server time_zone 'GMT+08:00' defined in the 'serverTimezone' parameter cannot be parsed by java TimeZone implementation. See java.util.TimeZone#getAvailableIDs() for available TimeZone, depending on your JRE implementation.
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:225)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.loadCalendar(AbstractConnectProtocol.java:1519)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:1037)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:638)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1732)
e[2Khis-server-ob | ... 51 more
e[2Khis-server-ob | Caused by: java.sql.SQLException: ORA-01882: timezone region 'Z' not found
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2366)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2229)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2117)
e[2Khis-server-ob | at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.loadCalendar(AbstractConnectProtocol.java:1492)
e[2Khis-server-ob | ... 54 more
datasource:
url: jdbc:oceanbase://192.168.31.13:2881/HERENDH?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&compatible-mode=oracle
username: xj_hrsj@xj_his_test
password:
driver-class-name: com.oceanbase.jdbc.Driver
type: com.zaxxer.hikari.HikariDataSource
hikari:
connection-timeout: 30000
maximum-pool-size: 20
使用client 版本
com.oceanbase
oceanbase-client
2.4.13
试了网上搜到推荐的解决方案包括 强制指定 JVM 默认时区, JDBC URL 中指定 serverTimezone
参数都不成功,没有dba权限,不能 修改数据库时区设置
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):
【备注】基于 LLM 和开源文档 RAG 的论坛小助手已开放测试,在发帖时输入 [@论坛小助手] 即可召唤小助手,欢迎试用!