JDBCQueryResult-class: JDBCQueryResult class

Description Usage Arguments Methods See Also

Description

JDBCQueryResult class

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
## 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 15, 2017, 11:53 p.m.