正在获取ORA-01882:在AWS EC2实例上找不到Oracle UCP的时区区域吗? [英] Getting ORA-01882: timezone region not found with Oracle UCP, on aws ec2 instance?
问题描述
我正在运行springboot应用程序(在本地计算机上运行良好),并且在ec2实例上出现ORA-01882: timezone region not found
错误.它看起来像是配置问题,但不确定如何解决.
I am running a springboot application (which is running fine on local machine), and getting ORA-01882: timezone region not found
error on ec2 instance. Its looks like a config problem but not sure how to fix it.
堆栈跟踪在下面
原因:java.sql.SQLException:无法启动通用 连接池:oracle.ucp.UniversalConnectionPoolException:无法 从数据源获取连接:java.sql.SQLException: ORA-00604:递归SQL级别1发生错误
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882:找不到时区区域
ORA-01882: timezone region not found
我正在使用ojdbc8版本12.2.0.1
I am using ojdbc8 version 12.2.0.1
推荐答案
您可以传递命令行参数-Duser.timezone=<Database Time Zone>
来启动应用程序.
You can pass command line argument -Duser.timezone=<Database Time Zone>
to start the application.
示例:
Maven命令行:mvn springboot:run -Duser.timezone=PST
Maven Command line: mvn springboot:run -Duser.timezone=PST
Java命令行:java -Duser.timezone=PST -jar application.jar
这是时区列表.
https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
这篇关于正在获取ORA-01882:在AWS EC2实例上找不到Oracle UCP的时区区域吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!