search for: dbcommit

...98 So, say, I want to change the value for NewZealand to '21' from '98' I've tried something like this: sql<-"UPDATE testtable SET vals=21 WHERE countries='NewZealand'" dbBeginTransaction(con) dbGetPreparedQuery(con,sql) <========== I get an error here dbCommit(con) using a different example for an INSERT command using a data frame 'data', this construct is accepted: dbGetPreparedQuery(con,sql,bind.data=data) What do I need to do differently to use the UPDATE command? Regards, Tom -- Thomas E Adams National Weather Service Ohio River Forec...

..."dbGetInfo" [1] "dbListResults" [1] "summary" [1] "dbListTables" [1] "dbReadTable" [1] "dbWriteTable" [1] "dbWriteTable" [1] "dbExistsTable" [1] "dbRemoveTable" [1] "dbListFields" [1] "dbCommit" [1] "dbRollback" [1] "dbCallProc" [1] "MySQLResult" [1] "dbClearResult" [1] "fetch" [1] "fetch" [1] "dbGetInfo" [1] "dbGetStatement" [1] "dbListFields" [1] "dbColumnInfo" [1] "d...

...dbGetInfo" > [1] "dbListResults" > [1] "summary" > [1] "dbListTables" > [1] "dbReadTable" > [1] "dbWriteTable" > [1] "dbExistsTable" > [1] "dbRemoveTable" > [1] "dbListFields" > [1] "dbCommit" > [1] "dbRollback" > [1] "dbCallProc" > [1] "MySQLResult" > [1] "dbClearResult" > [1] "fetch" > [1] "fetch" > [1] "dbGetInfo" > [1] "dbGetStatement" > [1] "dbListFields" > [...

...onnect(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 output(df) VALUES (?)",                          data.frame(output)) # --------------------------------------------------------------------------------- I get following message Error in dbGetPreparedQuery(con...

...fetches use a default buffer size (host arrays) of size 500 (previous version did no buffering). **Very preliminary** results suggest performance improvements on fetching of about a factor of 2. (Note that the maximum size of these buffers is limited to about 65K bytes per column.) * dbCommit() and dbRollback() are now explicitly implemented, but save points are not (but you may code them through dynamic SQL). * The precompiler ProC/C++ is now used with the option PARSE=none to avoid bogus C errors with some compilers and/or platforms (e.g., Mac OS X). -- David A. James Statist...

...lues$name log <- array.norm$arrayValues$LogRatioNorm snr <- array.norm$arrayValues$snr empty <- NA insert <- data.frame(proid, spot, name, empty, empty, log, snr, empty, empty) dbWriteTable(con, "processed_data", insert, append=TRUE, row.name=FALSE) dbCommit(con) the table i am trying to insert into: CREATE TABLE `processed_data` ( `processed_data_id` int(6) unsigned NOT NULL, `data_id` int(6) unsigned NOT NULL, `feature_name` varchar(100), `channel1_signal` int(5), `channel2_signal` int(5), `log2_ratio` double(5,2), `flag` varchar(100)...

...works as expected. Now let's try to insert new rows into mytable using a prepared statement and bind variables: > ps<-dbPrepareStatement(conn,"insert into mytable (prd_id,vol_factor) values (:1,:2)",bind=c(rep("numeric",2))) > res<-dbExecStatement(ps,my.df) > dbCommit(conn) [1] TRUE > dbGetQuery(conn,"select * from jdomenge_test") PRD_ID VOL_FACTOR 0 123 0.123 1 456 0.456 2 123 NA 3 456 NA so the 2 new rows were appended, except the values in the second column were seemingly not read... the same happens with...

Heya Folks, I can not find anything on executing insert statement through RMySQL, can someone please enlighten me? All i've found so far on getting data into a database is the write table functionality. Reading all data into memory appending additional information and writing that into a table is fine on my test environment, but won't be possible on the production environment because of

...ction <- function(dbfile) { require(RSQLite) drv <- SQLite() conn <- dbConnect(drv, dbfile) tryCatch({ dbBeginTransaction(conn) tryCatch({ for (i in 1:10) { somethingWhichCrashesSometimes() } }, error = function(e) {dbRollback(conn); stop(e)}) dbCommit(conn) }, finally=dbDisconnect(conn)) } somethingWhichCrashesSometimes <- function() { v <- runif(1) y <- runif(v*10-3) } options(error=dump.frames) debugThisFunction("test.sqlite") I've done the proper thing and used exceptions for resource management, so that I alw...

...ot; [1] "dbGetException" [1] "dbGetInfo" [1] "dbListResults" [1] "summary" [1] "dbListTables" [1] "dbReadTable" [1] "dbWriteTable" [1] "dbExistsTable" [1] "dbRemoveTable" [1] "dbListFields" [1] "dbCommit" [1] "dbRollback" [1] "dbCallProc" [1] "MySQLResult" [1] "dbClearResult" [1] "fetch" [1] "fetch" [1] "dbGetInfo" [1] "dbGetStatement" [1] "dbListFields" [1] "dbColumnInfo" [1] "dbGetRowsAff...

Hi, I would like to access a local mysql database. In python using the sqlite3 library it is quite straightforward. I just have to pass the path to the sqlite-file; sqlite3.connect('.../xy.sqlite') Is there something similar in R (or specifically in the RMySQL package)? It seems like I have to use the MySQL function in the RMySQL package in order to ... "initializes a MySQL

Hi I'm new to R and have been resisting posting to the list thus far, but I think I've exhausted my work around options. I'm having a few problems with RMySQL and/or it's underlying packages. I'm doing a very simple vsn transformation on large datasets, using RMySQL to retrieve the data for a DB. My first problem was that I could not get the RMySQL package to write

...text html latex example dbApply-methods text html latex example dbApply text html latex example dbBuildTableDefinition text html latex dbCallProc-methods text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example Note: unmatched right brace in 'dbDataType-methods' on or after line 24 dbDataType-methods text html latex example dbDriver-methods...

...ement-class text html latex example OraResult-class text html latex example Oracle text html latex example S4R text html latex dbCallProc-methods text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example dbDataType-methods text html latex example dbDriver-methods text html latex example dbGetInfo-methods text...

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent

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

Hi, I'm working in R 2.11.1 x64 on Windows x86_64-pc-mingw32. I'm trying to insert a very large CSV file into a SQLite database. I'm pretty new to working with databases in R, so I apologize if I'm overlooking something obvious here. I'm trying to work with the American Community Survey data, which is two 1.3GB csv files. I have enough RAM to read one of them into memory,

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps