Displaying 6 results from an estimated 6 matches for "dbrollback".
2003 Apr 22
0
ROracle 0.5-0 package update
...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
Statistics Research, Roo...
2012 Mar 17
0
tryCatch interferes with traceback(), debugger(), dump.frames()....
...ten
this function:
debugThisFunction <- 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 reso...
2007 Mar 20
1
RMySQL load error
..."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] "dbGetRowsAffected"
[1]...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...ion"
[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] "dbGetRowsAffected"
[1] "dbGet...
2005 Mar 09
1
RMySQL installed but not availalable
...;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"
>...
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