Displaying 8 results from an estimated 8 matches for "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, &qu...
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 outpu...
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 ?RPostgre...
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] "dbGet...
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&quo...
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