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:-
Then try to ping the JBC connection pool and it should work fine.
The payara server version which I used is 18.104.22.168. But this solution should work on all the versions of payara server.
Let me know if it works for you. Happy Coding 🙂