Description Usage Arguments Details Value Note See Also Examples
MonetDB
creates a new DBI driver that can be used to start JDBC connections to MonetDB.
1 | MonetDB ( classPath = "")
|
classPath |
The path to the JAR file containing the MonetDB driver. |
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.
Returns a driver object that can be used in calls to
dbConnect
.
MonetDB requires CREATE
and DROP
statements to be sent by dbSendUpdate
rather than dbGetQuery
.
1 2 3 4 5 6 7 8 9 10 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.