Hi all,
I am trying to connect to Database using RJDBC but due to some DB & Server
timezone mismatch I am facing below error message.
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect",
as.character(url)[1], :
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
I tried to fix this issue using java by using this parameter
“-Doracle.jdbc.timezoneAsRegion=false”
and it worked
But I am trying to apply the same setting in R using option settings, but
it is not working. Also, I tried updating Rprofile
*My code snippet:*
Sys.setenv(JAVA_HOME='/usr/lib/jvm/java-8-openjdk-amd64')
options(java.parameters = "-Xmx8g")
options(java.oracle.jdbc.timezoneAsRegion="false")
dbcDriver <- JDBC(driverClass="oracle.jdbc.OracleDriver",
classPath="/usr/lib/oracle/12.2/client64/lib/ojdbc8.jar")
pcm_stg_conn <- dbConnect(jdbcDriver, "jdbc:oracle:thin:@//hostname:1521/SID",
"username", "password").
Can you please help in resolving this issue
Thanks & Regards.
Anthony Nelson
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
