connect2oracle: connect to a oracle db

In ivanhanigan/ddiindexdb: manipulate ddiindexdb from R

Description

connect to a oracle db

Usage

connect2oracle(hostip=NA, db=NA, p=NA, driverlocation='/lib/ojdbc6.jar')

Arguments

hostip	IP address as string
db	Database (Workspace) name
p	password
driverlocation	defaults to linux location. not tested on windoze.

Note

make sure you have JDK, if not install the SUN version http://blog.i-evaluation.com/2012/12/03/installing-java-sdk-and-jre-bin-files-on-my-ec2-instance/ then get the JDBC driver from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html put into /lib did install.packages('rJava') and then "R CMD javareconf" as root

Author(s)

ivanhanigan

Examples

# example using the SWISH Extreme Weather Eventds DataBase (EWEDB).
# NB only powerusers will know the password.
ch <- connect2oracle(hostip = '115.146.93.225', db = 'DDIINDEXDB')
stdydscr <- dbGetQuery(ch, "select * from stdydscr where IDNO = 'EWEDB'")
t(stdydscr)

ivanhanigan/ddiindexdb documentation built on May 18, 2019, 7:13 a.m.