Here we go<\/strong><\/span>
\n[crayon lang=“shell“]
\n> Sys.setenv(JAVA_HOME=’\/usr\/lib\/jvm\/java-7-openjdk-amd64\/jre‘)
\n> options(java.parameters=“-Xmx2g“)
\n> library(rJava)<\/p>\n>
\n> .jinit()
\n> print(.jcall(„java\/lang\/System“, „S“, „getProperty“, „java.version“))
\n[1] „1.7.0_65“
\n> library(RJDBC)
\nLoading required package: DBI
\n> jdbcDriver < - JDBC(driverClass=\"oracle.jdbc.OracleDriver\", classPath=\"\/lib\/ojdbc6.jar\")\n>
\n> jdbcConnection < - dbConnect(jdbcDriver, \"jdbc:oracle:thin:@\/\/192.168.56.104:1521\/orcl\", \"system\", \"xxx\")\n> instanceName < - dbGetQuery(jdbcConnection, \"SELECT instance_name FROM v$instance\")\n> print(instanceName)
\n INSTANCE_NAME
\n1 orcl
\n> dbDisconnect(jdbcConnection)
\n[1] TRUE
\n[\/crayon]<\/p>\n
-a-<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
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.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[],"_links":{"self":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/670"}],"collection":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=670"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/670\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=670"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}