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,670 points
210 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 56,140 points

Related Questions In AWS

+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
• 66,880 points
294 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,240 points
1,483 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
• 56,140 points
101 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.