As R language is taken as one of the best analytics languages/tools in general, databases can‘ t be overlooked. Article is focused on very simple connection example for connecting R with Oracle database.
Prerequisities
1) Java JDK – and you need to know the path where it is located.
2) Oracle JDBC driver located in your system – you can download 11.2.0.4 from this page.
3) RJDBC package (install.packages("RJDBC") within R interactive shell) with its dependencies (rJava, DBI, etc.).
Here we go
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
> Sys.setenv(JAVA_HOME='/usr/lib/jvm/java-7-openjdk-amd64/jre') > options(java.parameters="-Xmx2g") > library(rJava) > > .jinit() > print(.jcall("java/lang/System", "S", "getProperty", "java.version")) [1] "1.7.0_65" > library(RJDBC) Loading required package: DBI > jdbcDriver < - JDBC(driverClass="oracle.jdbc.OracleDriver", classPath="/lib/ojdbc6.jar") > > jdbcConnection < - dbConnect(jdbcDriver, "jdbc:oracle:thin:@//192.168.56.104:1521/orcl", "system", "xxx") > instanceName < - dbGetQuery(jdbcConnection, "SELECT instance_name FROM v$instance") > print(instanceName) INSTANCE_NAME 1 orcl > dbDisconnect(jdbcConnection) [1] TRUE |
-a-