search for: dbunloaddriv

Displaying 8 results from an estimated 8 matches for "dbunloaddriv".

Did you mean: dbunloaddriver
2005 May 02
2
RMySQL query: why result takes so much memory in R ?
...utions. ## my code library(RMySQL) drv <- dbDriver("MySQL") ch <- dbConnect(drv,dbname="testdb", user="root",password="mysql") testdb <- dbGetQuery(ch, "select id, group, measurement from mydata") dbDisconnect(ch) dbUnloadDriver(drv) ## end of my code Cheers Christoph
2012 Jun 12
1
Not able to write to PostgreSQL database using "dbWriteTable"
...t;,password = "xxx") as.data.frame(zz[1]) dbGetQuery(connAE1,'SELECT id FROM \"test1\"') if(dbExistsTable(connAE1, "test1")){ dbWriteTable(con=connAE1,name='test1.id',value=as.data.frame(i),row.names=T ,overwrite=F ,append=T) } dbDisconnect(connAE1) dbUnloadDriver(drv1) ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Following is the past of the console Log for your Reference ++++++++++++++++++ console log ++++++++++++++++++++++++ > dbGetQuery(connAE1,'SELECT id FROM \"test1\"') id 1 1 2 2 > if(dbExistsTable(connAE1, &...
2011 Jan 14
3
RSQLite - How to express(or save) a dataframe as an output?
...; df <- data.frame(x = c(5, 4, 3, 11), y = c(25, 16, 9, 121))     library(RSQLite)     write('** Initializing','')     drv <- dbDriver("SQLite", shared.cache = TRUE)     con <- dbConnect(drv, dbname = "temp.db", loadable.extensions=TRUE)     on.exit(dbUnloadDriver(drv))     on.exit(dbDisconnect(con)) write('** Save output', '')  dbBeginTransaction(con)  dbGetPreparedQuery(con, "INSERT INTO output(df) VALUES (?)", data.frame(output))  dbCommit(con)     >  dbGetPreparedQuery(con,                         "INSERT INTO out...
2009 Nov 24
0
Install RPostgreSQL (Mac OSX 10.6)
...I do? 2) Once this issue is solved, should this code work? drv <- dbDriver("PostgreSQL") con <- dbConnect(drv,user="postgresql",password=password,dbname="DB") dbSendQuery(con,"create table testTab as select * from Tab") dbDisconnect(con) dbUnloadDriver(drv) Thanks, Tom trying URL 'http://cran.ch.r-project.org/src/contrib/RPostgreSQL_0.1-6.tar.gz' Content type 'application/x-gzip' length 141399 bytes (138 Kb) opened URL ================================================== downloaded 138 Kb * installing *source* package ?RPostg...
2007 Mar 20
1
RMySQL load error
...ySQL.o -L/usr/local/lib/mysql -lmysqlclient -lz -L/usr/lib64/R/lib -lR ** R ** inst ** save image Loading required package: DBI [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...(cached) yes creating ./config.status creating src/Makevars ** libs make: `RMySQL.so' is up to date. ** R ** inst ** save image [1] TRUE [1] "dbObjectId" [1] "format" [1] "show" [1] "print" [1] "MySQLObject" [1] "MySQLDriver" [1] "dbUnloadDriver" [1] "dbGetInfo" [1] "dbListConnections" [1] "summary" [1] "MySQLConnection" [1] "dbConnect" [1] "dbConnect" [1] "dbConnect" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbG...
2005 Mar 09
1
RMySQL installed but not availalable
...nt -lz -L/usr/lib/R/lib -lR > ** R > ** inst > ** save image > Loading required package: DBI > [1] "dbObjectId" > [1] "format" > [1] "show" > [1] "print" > [1] "MySQLObject" > [1] "MySQLDriver" > [1] "dbUnloadDriver" > [1] "dbGetInfo" > [1] "dbListConnections" > [1] "summary" > [1] "MySQLConnection" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbConnect" > [1] "dbDisconnect" > [1] "dbSendQuery&q...
2002 Oct 16
5
Database newbee problem...
Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30