sjdbcGetResultSet {sjdbc}

Get a ResultSet From Static Java Class

Description

Retreives a ResultSet previously stored in a static instance of SJDBCResultSetUtilities class as a data.frame.

Usage

sjdbcGetResultSet(key, unregister = TRUE, default.num.rows = NULL,
                  start.at.first=TRUE, rows.to.read=-1)

Arguments

key

a string containing the key into the hash table in SJDBCResultSetUtilities where the result was stored previously.

unregister

a logical value. If TRUE (the default), specifies that the ResultSet should be removed from the hash table after the data is returned.

default.num.rows

an integer containing the number of rows.

When the ResultSet is of type ResultSet.TYPE_FORWARD_ONLY, the number of rows cannot be determined until after all of the data has been retrieved. If the ResultSet has more than the default number, the array sizes are doubled whenever the current capacity is reached. If the ResultSet is not of TYPE_FORWARD_ONLY, this argument is not used.

start.at.first

a logical. If TRUE (the default), set the ResultSet to start with the first row before reading. if FALSE, start with the current row.

rows.to.read

an integer specifying the maximum number of rows to read. If less than zero, read all rows in the result set.

Details

This function is called by importJDBC and usually is not called directly.

Value

returns a data.frame containing the ResultSet.

See Also

importJDBC

Examples

## Not run: 
sjdbcGetResultSet("resultid")

## End(Not run)