DBI::dbWithTransaction fails when working with ROracle drivers due to DBI::dbBegin dependency

Question

DBI::dbWithTransaction fails when working with ROracle drivers due to DBI::dbBegin dependency

mmccarthy404 opened this issue 3 years ago · 2 comments

dbWithTransaction makes use of dbBegin in it's source code, however, ROracle doesn't handle the dbBegin method, which makes it impossible to run DBI::dbWithTransaction on Oracle databases.

Answer 1 · 2021-05-28T02:30:28.000Z

Thanks. I think we need to implement either dbBegin() or dbWithTransaction() for the corresponding class. Ideally this is done in the ROracle package, you can also work around in user code:

setMethod("dbWithTransaction", signature("OracleConnection"), function(conn, code) {
  message("dbWithTransaction() not implemented for Oracle connections.")
  code
})

Answer 2 · 2022-10-18T01:09:15.000Z

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.