DBIConnection-class {DBI}R Documentation

Class DBIConnection

Description

Base class for all DBMS connection classes. Individual drivers (ODBC, Oracle, PostgreSQL, MySQL, etc.) extend this class in a database-specific manner.

Objects from the Class

A virtual Class: No objects may be created from it.

Extends

Class "DBIObject", directly.

Generator

The main generator is dbConnect.

Methods

The following methods take objects from classes derived from DBIConnection:

Create and close connections:

dbConnect
signature(drv = "DBIConnection"): ...
dbDisconnect
signature(conn = "DBIConnection"): ...

Execute SQL commands:

dbSendQuery
signature(conn = "DBIConnection", statement = "character"): ...
dbGetQuery
signature(conn = "DBIConnection", statement = "character"): ...
dbCallProc
signature(conn = "DBIConnection"): ...

Transaction management:

dbCommit
signature(conn = "DBIConnection"): ...
dbRollback
signature(conn = "DBIConnection"): ...

Meta-data:

dbListResults
signature(conn = "DBIConnection"): ...
dbGetInfo
signature(dbObj = "DBIConnection"): ...
summary
signature(object = "DBIConnection"): ...

Exceptions:

dbGetException
signature(conn = "DBIConnection"): ...
dbListFields
signature(conn = "DBIConnection", name = "character"): ...

Convenience functions:

dbListTables
signature(conn = "DBIConnection"): ...
dbReadTable
signature(conn = "DBIConnection", name = "character"): ...
dbExistsTable
signature(conn = "DBIConnection", name = "character"): ...
dbRemoveTable
signature(conn = "DBIConnection", name = "character"): ...
dbWriteTable
signature(conn = "DBIConnection", name = "character", value = "data.frame"): ...

Author(s)

R-SIG-DB

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://developer.r-project.org/db.

See Also

DBI classes: DBIObject-class DBIDriver-class DBIConnection-class DBIResult-class

Examples

## Not run: 
ora <- dbDriver("Oracle")
con <- dbConnect(ora, "user/password@dbname")

pg <- dbDriver("PostgreSQL")
con <- dbConnect(pg, "user", "password")
## End(Not run)

[Package DBI version 0.2-4 Index]