Anthony, Did you try options(java.parameters = "-Xmx8g -Djava.oracle.jdbc.timezoneAsRegion=false") instead of specifying the java property separately? -- H
On 2 May 2017 at 15:18, Nelson Anthony <nelson.ch...@gmail.com> wrote: > 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. -- OpenPGP: https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1 If you wish to request my time, please do so using http://bit.ly/hd1ScheduleRequest. Si vous voudrais faire connnaisance, allez a http://bit.ly/hd1ScheduleRequest. <https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent from my mobile device Envoye de mon portable [[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.
