transactions {DBI} | R Documentation |
Not all database engines implement transaction management, in which case
these methods should not be implemented for the specific
DBIConnection
subclass.
dbBegin(conn, ...) dbCommit(conn, ...) dbRollback(conn, ...)
conn |
A |
... |
Other parameters passed on to methods. |
a logical indicating whether the operation succeeded or not.
The current transaction on the connection con
is committed or rolled
back.
Self-contained transactions: dbWithTransaction
## Not run: ora <- dbDriver("Oracle") con <- dbConnect(ora) rs <- dbSendQuery(con, "delete * from PURGE as p where p.wavelength<0.03") if (dbGetRowsAffected(rs) > 250) { warning("dubious deletion -- rolling back transaction") dbRollback(con) } else { dbCommit(con) } dbClearResult(rs) dbDisconnect(con) ## End(Not run)