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
:
Create and close connections:
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)