JDBC: JDBC engine for MonetDB

In RMonetDB: Provides access to MonetDB through the JDBC interface

Description

MonetDB creates a new DBI driver that can be used to start JDBC connections to MonetDB.

Usage

  MonetDB ( classPath = "")

Arguments

classPath

The path to the JAR file containing the MonetDB driver.

Details

RMonetDB function has two purposes. One is to initialize the Java VM and load a Java JDBC driver. The second purpose is to create a proxy R object which can be used to a call dbConnect which actually creates a connection.

Value

Returns a driver object that can be used in calls to dbConnect.

Note

MonetDB requires CREATE and DROP statements to be sent by dbSendUpdate rather than dbGetQuery.

See Also

dbConnect

Examples

## Not run: 
monetdriver<-MonetDB(classPath="/usr/local/monetdb/share/monetdb/lib/monetdb-jdbc-2.4.jar")
conn <- dbConnect(drv, "jdbc:monetdb://localhost/demo")
dbListTables(conn)
data(iris)
dbWriteTable(conn, "iris", iris)
dbGetQuery(conn, "select count(*) from iris")
d <- dbReadTable(conn, "iris")

## End(Not run)

RMonetDB documentation built on May 2, 2019, 6:08 p.m.