JDBCQueryResult-class: JDBCQueryResult class

In hoesler/dbj: Provides access to databases through the JDBC interface

Description

JDBCQueryResult class

Usage

## S4 method for signature 'JDBCQueryResult,numeric'
dbFetch(res, n = -1, fetch_size = 0,
  ..., row.names = NA)

## S4 method for signature 'JDBCQueryResult'
dbClearResult(res, ...)

## S4 method for signature 'JDBCQueryResult'
dbColumnInfo(res, what = c("name", "field.type",
  "data.type", "jdbc.type"), ...)

## S4 method for signature 'JDBCQueryResult'
dbGetRowCount(res, ...)

## S4 method for signature 'JDBCQueryResult'
dbGetRowsAffected(res, ...)

## S4 method for signature 'JDBCQueryResult'
dbHasCompleted(res, ...)

## S4 method for signature 'JDBCQueryResult'
dbGetInfo(dbObj, ...)

## S4 method for signature 'JDBCQueryResult'
dbIsValid(dbObj, ...)

## S4 method for signature 'JDBCQueryResult'
dbGetDriver(dbObj, ...)

## S4 method for signature 'JDBCQueryResult'
dbGetStatement(res, ...)

## S4 method for signature 'JDBCQueryResult'
dbGetRowsAffected(res, ...)

Arguments

res, dbObj	an JDBCQueryResult object.
n	optional maximum number of records to retrieve per fetch. Use -1 to retrieve all pending records; use 0 for to fetch the default number of rows as defined in JDBC
fetch_size	a hint to the number of rows that should be fetched from the database in a single block. See http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setFetchSize(int).
...	Ignored. Needed for compatibility with generic.
row.names	Either TRUE, FALSE, NA or a string. If TRUE, always translate row names to a column called "row_names". If FALSE, never translate row names. If NA, translate rownames only if they're a character vector. A string is equivalent to TRUE, but allows you to override the default name. For backward compatibility, NULL is equivalent to FALSE.
what	a character vector indicating which info to return. Expected is a subset of c("name", "field.type", "data.type", "label", "nullable").

Methods

dbFetch: Fetch n results

dbColumnInfo: Get info about the result set data types. Returns a data.frame with one row per output field in res. Includes name, field.type (the SQL type) and data.type (the R data type) columns for the default what. Additionally, label (The field label) and nullable (0 = disallows NULL, 1 = allows NULL, 2 = unknown) can be fetched.

dbGetRowCount: Count rows in result set

dbGetRowsAffected: This function returns the number of rows that were added, deleted, or updated by data modifying query. For a selection query, this function returns 0.

dbHasCompleted: Check if all results have been fetched

dbGetInfo: Get info

dbIsValid: Is the result valid

dbGetStatement: Returns the statement that was passed to dbSendQuery

dbGetRowsAffected: Returns 0

See Also

Other result classes: JDBCResult-class, JDBCUpdateResult-class

hoesler/dbj documentation built on May 17, 2019, 4:36 p.m.