DBIConnection-class {DBI} | R Documentation |
Base class for all DBMS connection classes. Individual drivers (ODBC, Oracle, PostgreSQL, MySQL, etc.) extend this class in a database-specific manner.
A virtual Class: No objects may be created from it.
Class "DBIObject"
, directly.
The main generator is dbConnect
.
The following methods take objects from classes derived
from DBIConnection
:
signature(drv = "DBIConnection")
: ... signature(conn = "DBIConnection")
: ... Execute SQL commands:
signature(conn = "DBIConnection", statement = "character")
: ... signature(conn = "DBIConnection", statement = "character")
: ... signature(conn = "DBIConnection")
: ... Transaction management:
signature(conn = "DBIConnection")
: ... signature(conn = "DBIConnection")
: ... Meta-data:
signature(conn = "DBIConnection")
: ... signature(dbObj = "DBIConnection")
: ... signature(object = "DBIConnection")
: ... Exceptions:
signature(conn = "DBIConnection")
: ... signature(conn = "DBIConnection", name = "character")
: ... Convenience functions:
signature(conn = "DBIConnection")
: ... signature(conn = "DBIConnection", name = "character")
: ... signature(conn = "DBIConnection", name = "character")
: ... signature(conn = "DBIConnection", name = "character")
: ... signature(conn = "DBIConnection", name = "character", value = "data.frame")
: ... R-SIG-DB
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://developer.r-project.org/db.
DBI classes:
DBIObject-class
DBIDriver-class
DBIConnection-class
DBIResult-class
## Not run: ora <- dbDriver("Oracle") con <- dbConnect(ora, "user/password@dbname") pg <- dbDriver("PostgreSQL") con <- dbConnect(pg, "user", "password") ## End(Not run)