You might experienced following kind of error when connecting WSO2 products to oracle database
Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error - Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1ORA-01882: timezone region not found) at .... ....
To avoid this kind of error, you can simply set the JAVA_OPTS in the terminal before starting the server
(Sri Lanka - +05:30, change the correct time zone according to your location).
export JAVA_OPTS="-Duser.timezone='+05:30'"
You’ll get good explanation from this blog about oracle time zone difference issue when connecting WSO2 products to oracle database
http://evanthika.blogspot.com/2011/11/how-to-resolve-ora-01882-timezone.html
Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error - Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1ORA-01882: timezone region not found) at .... ....
To avoid this kind of error, you can simply set the JAVA_OPTS in the terminal before starting the server
(Sri Lanka - +05:30, change the correct time zone according to your location).
export JAVA_OPTS="-Duser.timezone='+05:30'"
You’ll get good explanation from this blog about oracle time zone difference issue when connecting WSO2 products to oracle database
http://evanthika.blogspot.com/2011/11/how-to-resolve-ora-01882-timezone.html
No comments:
Post a Comment