Getting ORA-01882: timezone region not found with Oracle UCP, on aws ec2 instance?

0 votes

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.

Stack trace is below

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: timezone region not found

I am using ojdbc8 version 12.2.0.1

Oct 3, 2018 in AWS by eatcodesleeprepeat
• 4,750 points
1,664 views

1 answer to this question.

0 votes

You can pass command line argument -Duser.timezone=<Database Time Zone> to start the application.

Example:

Maven Command line: mvn springboot:run -Duser.timezone=PST

Java Command line: java -Duser.timezone=PST -jar application.jar

Here are the timezones list.

https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

answered Oct 3, 2018 by Priyaj
• 57,700 points

Related Questions In AWS

+1 vote
1 answer

i have configure docker on AWS EC2 instance but commands are not working inside docker container.

Hello @Aniket , The docker exec command runs a new command ...READ MORE

answered Aug 5 in AWS by Niroj
• 67,380 points
161 views
+1 vote
1 answer
+5 votes
2 answers

AWS EC2 Instances are not getting to internet access

Check your VPC settings, whether you are ...READ MORE

answered Oct 16, 2018 in AWS by Omkar
• 69,030 points
6,567 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
+1 vote
2 answers

How do I run python script on aws EC2 instance(ubuntu)?

I believe that you are using the ...READ MORE

answered Apr 17, 2018 in AWS by Cloud gunner
• 4,650 points
6,171 views
0 votes
1 answer

Install RStudio on AWS EC2 instance

Amazon Linux AMI 2017.09.1 is based on ...READ MORE

answered Jul 27, 2018 in AWS by Priyaj
• 57,700 points
1,443 views