transactions

0th

Percentile

Begin/commit/rollback SQL transactions

Not all database engines implement transaction management, in which case these methods should not be implemented for the specific DBIConnection subclass.

Usage
dbBegin(conn, ...)
dbCommit(conn, ...)
dbRollback(conn, ...)
Arguments
conn
A DBIConnection object, as produced by dbConnect.
...
Other parameters passed on to methods.
Value

a logical indicating whether the operation succeeded or not.

Side Effects

The current transaction on the connection con is committed or rolled back.

See Also

Self-contained transactions: dbWithTransaction

Aliases
  • dbBegin
  • dbCommit
  • dbRollback
  • transactions
Examples
library(DBI) ## 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)
Documentation reproduced from package DBI, version 0.5-1, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.