java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

ava.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
=====================================================

Soln: This issue mainly appears in Mac or Linux systems when making JDBC connection. To fix this follow below
settings.

To run a single java class

(1) in eclipse go run – > run configuration
(2) in there go to JRE tab in right side panels
(3) in VM Arguments section paste this
(4) -Duser.timezone=GMT
(5) then Apply – > Run

To run a Project in which a java class is doing jdbc connection :

Update vm arguments of project under ( run configuration section ) with -Duser.timezone=”GMT”

below is updated VM arguments list

-Dcatalina.base=”/Users/STS_Work/.metadata/.plugins/org.eclipse.wst.server.core/tmp0″ -Dcatalina.home=”/Users/mySoftInst/apache-tomcat-7.0.54″ -Dwtp.deploy=”/Users/STS_Work/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps” -Djava.endorsed.dirs=”/Users/mySoftInst/apache-tomcat-7.0.54/endorsed” -Duser.timezone=”GMT”