ORA-01882: timezone region not found error in Payara Server

This tutorial will explain how to resolve the “time zone region not found error ” when the user tries to set a JDBC Connection pool in payara server.

We usually get this error when we try to create a JDBC Connection pool in payara server.You will get the following error when you try to ping a newly created connection pool.

The error message shows ORA-01882 : timezone region not found.

To fix this error go to server-config under Configurations. Go to JVM Options( server-config->JVM Settings->JVM Options).

Add the following JVM option and save it:-

-Doracle.jdbc.timezoneAsRegion=false

JVM Options Payara server (timezone Region)

Then try to ping the JBC connection pool and it should work fine.

JDBC Connection Pool in Payara Server

The payara server version which I used is 4.1.1.154. But this solution should work on all the versions of payara server.

Let me know if it works for you. Happy Coding 🙂

Leave a comment

Your email address will not be published. Required fields are marked *