|
Foundation |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.rio.MVAResultSet
public class MVAResultSet
A ResultSet provides access to a table of data. A ResultSet object is usually generated by executing a Statement.
A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.
The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are numbered from 1.
For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.
For the getXXX methods, the JDBC driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. See the JDBC specification for allowable mappings from SQL types to Java types with the ResultSet.getXXX methods.
Column names used as input to getXXX methods are case insensitive. When performing a getXXX using a column name, if several columns have the same name, then the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names were used there is no way for the programmer to guarantee that they actually refer to the intended columns.
A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.
The number, types and properties of a ResultSet's columns are provided by the
ResulSetMetaData
object returned by the getMetaData method.
Statement.executeQuery(java.lang.String)
,
Statement.getResultSet()
,
ResultSetMetaData
Field Summary | |
---|---|
protected int |
_concurrency
|
protected int |
_type
|
protected java.sql.SQLWarning |
_warnings
|
protected boolean |
_wasNull
|
static int |
CHARACTER
|
static int |
DATE
|
static int |
DATETIME
|
protected int |
initialFetchSize
|
static int |
INTEGER
|
protected int |
m_columnCount
|
protected int |
m_maxRows
|
protected com.sas.rio.IRowCache |
m_rowCache
|
protected MVAStatement |
m_statement
|
protected static int |
MAX_FIELD_SIZE
|
static int |
MAYBE_INTEGER
|
static int |
NOSUBTYPE
|
static int |
NUMERIC
|
static int |
TIME
|
Method Summary | ||
---|---|---|
boolean |
absolute(int rowIndex)
|
|
void |
afterLast()
|
|
void |
beforeFirst()
JDBC 2.0 Moves to the front of the result set, just before the first row. |
|
void |
cancelRowUpdates()
|
|
void |
clearWarnings()
After this call getWarnings returns null until a new warning is reported for this ResultSet. |
|
void |
close()
Closes the ResultSet. |
|
void |
deleteRow()
|
|
int |
findColumn(java.lang.String columnName)
Maps a Resultset column name to a ResultSet column index. |
|
boolean |
first()
JDBC 2.0 Moves to the first row in the result set. |
|
java.sql.Array |
getArray(int i)
JDBC 2.0 Get an array column. |
|
java.sql.Array |
getArray(java.lang.String colName)
JDBC 2.0 Get an array column. |
|
java.io.InputStream |
getAsciiStream(int columnIndex)
Gets the value of a column in the current row as a Java InputStream. |
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
Gets the value of a column in the current row as a Java InputStream. |
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
|
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated. |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
|
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated. |
|
java.io.InputStream |
getBinaryStream(int columnIndex)
The MVAResultSet implementation of getBinaryStream(int)
only supports columns with a SQL type of java.sql.Types.CHAR or
java.sql.Types.VARCHAR . |
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Gets the value of a column in the current row as a Java InputStream. |
|
java.sql.Blob |
getBlob(int i)
JDBC 2.0 Get a BLOB column. |
|
java.sql.Blob |
getBlob(java.lang.String colName)
JDBC 2.0 Get a BLOB column. |
|
boolean |
getBoolean(int columnIndex)
Gets the value of a column in the current row as a Java boolean. |
|
boolean |
getBoolean(java.lang.String columnName)
Gets the value of a column in the current row as a Java boolean. |
|
byte |
getByte(int columnIndex)
Gets the value of a column in the current row as a Java byte. |
|
byte |
getByte(java.lang.String columnName)
Gets the value of a column in the current row as a Java byte. |
|
byte[] |
getBytes(int columnIndex)
Gets the value of a column in the current row as a Java byte array. |
|
byte[] |
getBytes(java.lang.String columnName)
Gets the value of a column in the current row as a Java byte array. |
|
protected com.sas.rio.IRowCache |
getCache()
|
|
java.io.Reader |
getCharacterStream(int columnIndex)
JDBC 2.0 Gets the value of a column in the current row as a java.io.Reader. |
|
java.io.Reader |
getCharacterStream(int columnIndex,
java.lang.String charsetName)
JDBC 2.0 Proprietary Extension (S0678753) Gets the value of a column in the current row as a java.io.Reader using a specified character set. |
|
java.io.Reader |
getCharacterStream(java.lang.String columnName)
JDBC 2.0 Gets the value of a column in the current row as a java.io.Reader |
|
java.io.Reader |
getCharacterStream(java.lang.String columnName,
java.lang.String charsetName)
JDBC 2.0 Proprietary Extension (S0678753) Gets the value of a column in the current row as a java.io.Reader using a specified character set. |
|
java.sql.Clob |
getClob(int i)
JDBC 2.0 Get a CLOB column. |
|
java.sql.Clob |
getClob(java.lang.String colName)
JDBC 2.0 Get a CLOB column. |
|
int |
getConcurrency()
JDBC 2.0 Gets the concurrency of this result set. |
|
java.lang.String |
getCursorName()
Gets the name of the SQL cursor used by this ResultSet. |
|
java.sql.Date |
getDate(int columnIndex)
Gets the value of a column in the current row as a Java java.sql.Date. |
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
JDBC 2.0 Gets the value of a column in the current row as a java.sql.Date object. |
|
java.sql.Date |
getDate(java.lang.String columnName)
Gets the value of a column in the current row as a Java java.sql.Date. |
|
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal)
Gets the value of a column in the current row as a java.sql.Date object. |
|
double |
getDouble(int columnIndex)
Gets the value of a column in the current row as a Java double. |
|
double |
getDouble(java.lang.String columnName)
Gets the value of a column in the current row as a Java double. |
|
int |
getFetchDirection()
The IOM JDBC driver always returns ResultSet.FETCH_FORWARD
for the fetch direction, as calls to setFetchDirection(int)
are silently ignored. |
|
int |
getFetchSize()
JDBC 2.0 Gets the fetch size. |
|
float |
getFloat(int columnIndex)
Gets the value of a column in the current row as a Java float. |
|
float |
getFloat(java.lang.String columnName)
Gets the value of a column in the current row as a Java float. |
|
int |
getHoldability()
The MVAResultSet version of #getHoldability() always
returns ResultSet#CLOSE_CURSORS_AT_COMMIT . |
|
int |
getInt(int columnIndex)
Gets the value of a column in the current row as a Java int. |
|
int |
getInt(java.lang.String columnName)
Gets the value of a column in the current row as a Java int. |
|
long |
getLong(int columnIndex)
Gets the value of a column in the current row as a Java long. |
|
long |
getLong(java.lang.String columnName)
Gets the value of a column in the current row as a Java long. |
|
java.sql.ResultSetMetaData |
getMetaData()
Gets a ResultSetMetaData object that is associated with this ResultSet. |
|
java.io.Reader |
getNCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. |
|
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. |
|
java.sql.NClob |
getNClob(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java
programming language. |
|
java.sql.NClob |
getNClob(java.lang.String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java
programming language. |
|
java.lang.String |
getNString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java
programming language. |
|
java.lang.String |
getNString(java.lang.String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java
programming language. |
|
java.lang.Object |
getObject(int columnIndex)
Gets the value of a column in its default Java representation. |
|
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
JDBC 2.0 Returns the value of column i as a Java object. |
|
java.lang.Object |
getObject(java.lang.String columnName)
Gets the value of a column in its default Java representation. |
|
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
JDBC 2.0 Returns the value of column i as a Java object. |
|
java.sql.Ref |
getRef(int i)
JDBC 2.0 Get a REF(<structured-type>) column. |
|
java.sql.Ref |
getRef(java.lang.String colName)
JDBC 2.0 Get a REF(<structured-type>) column. |
|
int |
getRow()
|
|
java.sql.RowId |
getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in
the Java programming language. |
|
java.sql.RowId |
getRowId(java.lang.String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in
the Java programming language. |
|
short |
getShort(int columnIndex)
Gets the value of a column in the current row as a Java short. |
|
short |
getShort(java.lang.String columnName)
Gets the value of a column in the current row as a Java short. |
|
java.sql.SQLXML |
getSQLXML(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the
Java programming language. |
|
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the
Java programming language. |
|
java.sql.Statement |
getStatement()
JDBC 2.0 Return the Statement that produced the ResultSet. |
|
java.lang.String |
getString(int columnIndex)
Gets the value of a column in the current row as a Java String. |
|
java.lang.String |
getString(java.lang.String columnName)
Gets the value of a column in the current row as a Java String. |
|
java.sql.Time |
getTime(int columnIndex)
Gets the value of a column in the current row as a Java java.sql.Time. |
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Gets the value of a column in the current row as a java.sql.Time object. |
|
java.sql.Time |
getTime(java.lang.String columnName)
Gets the value of a column in the current row as a Java java.sql.Time. |
|
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal)
Gets the value of a column in the current row as a java.sql.Time object. |
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
Gets the value of a column in the current row as a Java java.sql.Timestamp. |
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Gets the value of a column in the current row as a Java java.sql.Timestamp. |
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp object. |
|
int |
getType()
JDBC 2.0 Gets the result set type. |
|
java.io.InputStream |
getUnicodeStream(int columnIndex)
The MVAResultSet implementation of getUnicodeStream(int)
only supports columns with a SQL type of java.sql.Types.CHAR or
java.sql.Types.VARCHAR . |
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated. |
|
java.net.URL |
getURL(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. |
|
java.net.URL |
getURL(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. |
|
java.sql.SQLWarning |
getWarnings()
Gets the SQLWarnings that are associated with this row. |
|
void |
insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and the database. |
|
boolean |
isAfterLast()
JDBC 2.0 Determines if the cursor is after the last row in the result set. |
|
boolean |
isBeforeFirst()
JDBC 2.0 Determines if the cursor is before the first row in the result set. |
|
boolean |
isClosed()
Retrieves whether this ResultSet object has been closed. |
|
boolean |
isFirst()
JDBC 2.0 Indicates whether the cursor is on the first row of this ResultSet object. |
|
boolean |
isLast()
|
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
|
|
boolean |
last()
JDBC 2.0 Moves to the last row in the result set. |
|
void |
moveToCurrentRow()
JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row. |
|
void |
moveToInsertRow()
JDBC 2.0 Move to the insert row. |
|
boolean |
next()
Proceeds to the next row in the ResultSet. |
|
boolean |
previous()
|
|
void |
refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in the database. |
|
boolean |
relative(int rows)
|
|
boolean |
rowDeleted()
JDBC 2.0 Determines if this row has been deleted. |
|
boolean |
rowInserted()
JDBC 2.0 Determines if the current row has been inserted. |
|
boolean |
rowUpdated()
JDBC 2.0 Determine if the current row has been updated. |
|
void |
setFetchDirection(int direction)
The IOM JDBC driver silently ignores the hint to set the fetch direction. |
|
void |
setFetchSize(int rows)
|
|
|
unwrap(java.lang.Class<T> iface)
|
|
void |
updateArray(int columnIndex,
java.sql.Array x)
Updates the designated column with a java.sql.Array value. |
|
void |
updateArray(java.lang.String columnName,
java.sql.Array x)
Updates the designated column with a java.sql.Array value. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ASCII stream value. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value. |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBlob(int columnIndex,
java.sql.Blob x)
Updates the designated column with a java.sql.Blob value. |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x)
Updates the designated column with a java.sql.Blob value. |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void |
updateBoolean(int columnIndex,
boolean x)
JDBC 2.0 Update a column with a boolean value. |
|
void |
updateBoolean(java.lang.String columnName,
boolean x)
JDBC 2.0 Update a column with a boolean value. |
|
void |
updateByte(int columnIndex,
byte x)
JDBC 2.0 Update a column with a byte value. |
|
void |
updateByte(java.lang.String columnName,
byte x)
JDBC 2.0 Update a column with a byte value. |
|
void |
updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
|
void |
updateBytes(java.lang.String columnName,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x)
Updates the designated column with a character stream value. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
JDBC 2.0 Update a column with a character stream value. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
JDBC 2.0 Update a column with a character stream value. |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateClob(int columnIndex,
java.sql.Clob x)
Updates the designated column with a java.sql.Clob value. |
|
void |
updateClob(int columnIndex,
java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void |
updateClob(int columnIndex,
java.io.Reader reader,
long length)
Updates the designated column using the given Reader object,
which is the given number of characters long. |
|
void |
updateClob(java.lang.String columnName,
java.sql.Clob x)
Updates the designated column with a java.sql.Clob value. |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Updates the designated column using the given Reader object,
which is the given number of characters long. |
|
void |
updateDate(int columnIndex,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value. |
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value. |
|
void |
updateDouble(int columnIndex,
double x)
JDBC 2.0 Update a column with a Double value. |
|
void |
updateDouble(java.lang.String columnName,
double x)
JDBC 2.0 Update a column with a double value. |
|
void |
updateFloat(int columnIndex,
float x)
JDBC 2.0 Update a column with a float value. |
|
void |
updateFloat(java.lang.String columnName,
float x)
JDBC 2.0 Update a column with a float value. |
|
void |
updateInt(int columnIndex,
int x)
JDBC 2.0 Update a column with an integer value. |
|
void |
updateInt(java.lang.String columnName,
int x)
JDBC 2.0 Update a column with an integer value. |
|
void |
updateLong(int columnIndex,
long x)
JDBC 2.0 Update a column with a long value. |
|
void |
updateLong(java.lang.String columnName,
long x)
JDBC 2.0 Update a column with a long value. |
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x)
Updates the designated column with a character stream value. |
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateNClob(int columnIndex,
java.sql.NClob nClob)
Updates the designated column with a java.sql.NClob value. |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader)
Updates the designated column using the given Reader The
data will be read from the stream as needed until end-of-stream is
reached. |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader,
long length)
Updates the designated column using the given Reader object,
which is the given number of characters long. |
|
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
Updates the designated column with a java.sql.NClob value. |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Updates the designated column using the given Reader object,
which is the given number of characters long. |
|
void |
updateNString(int columnIndex,
java.lang.String nString)
Updates the designated column with a String value. |
|
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString)
Updates the designated column with a String value. |
|
void |
updateNull(int columnIndex)
JDBC 2.0 Give a nullable column a null value. |
|
void |
updateNull(java.lang.String columnName)
JDBC 2.0 Update a column with a null value. |
|
void |
updateObject(int columnIndex,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value. |
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value. |
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
|
void |
updateRef(int columnIndex,
java.sql.Ref x)
Updates the designated column with a java.sql.Ref value Empty method implementation for JDK1.4 compliance. |
|
void |
updateRef(java.lang.String columnName,
java.sql.Ref x)
Updates the designated column with a java.sql.Ref value Empty method implementation for JDK1.4 compliance. |
|
void |
updateRow()
JDBC 2.0 Update the underlying database with the new contents of the current row. |
|
void |
updateRowId(int columnIndex,
java.sql.RowId x)
Updates the designated column with a RowId value. |
|
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
Updates the designated column with a RowId value. |
|
void |
updateShort(int columnIndex,
short x)
JDBC 2.0 Update a column with a short value. |
|
void |
updateShort(java.lang.String columnName,
short x)
JDBC 2.0 Update a column with a short value. |
|
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value. |
|
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value. |
|
void |
updateString(int columnIndex,
java.lang.String x)
JDBC 2.0 Update a column with a String value. |
|
void |
updateString(java.lang.String columnName,
java.lang.String x)
JDBC 2.0 Update a column with a String value. |
|
void |
updateTime(int columnIndex,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value. |
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value. |
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
|
boolean |
wasNull()
The MVAResultSet implementation of wasNull will
return true if the last column read contained a numeric
SAS missing value. |
Field Detail |
---|
public static final int NOSUBTYPE
public static final int DATE
public static final int TIME
public static final int DATETIME
public static final int INTEGER
public static final int MAYBE_INTEGER
public static final int NUMERIC
public static final int CHARACTER
protected static final int MAX_FIELD_SIZE
protected java.sql.SQLWarning _warnings
protected final int _concurrency
protected final int _type
protected final MVAStatement m_statement
protected com.sas.rio.IRowCache m_rowCache
protected boolean _wasNull
protected int m_columnCount
protected int m_maxRows
protected int initialFetchSize
Method Detail |
---|
public boolean absolute(int rowIndex) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
java.sql.SQLException
public boolean relative(int rows) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
java.sql.SQLException
public void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if the result set type
is TYPE_FORWARD_ONLY.public void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if a server error is
detected or if the result set type is TYPE_FORWARD_ONLY.public boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if an MvaException is
detected or result set type is TYPE_FORWARD_ONLY.public boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but
it is never thrown.public boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but
it is never thrown.public boolean isFirst() throws java.sql.SQLException
ResultSet
object.
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
- - If a data access error occurs.public boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if a server error is
detected.public boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if a server error is
detected.public boolean wasNull() throws java.sql.SQLException
MVAResultSet
implementation of wasNull
will
return
true if the last column read contained a numeric
SAS missing value. In the case where the last column read contained
a character SAS missing value false
is always returned.
To determine if the value was character missing you can use the SAS
SQL "IS [NOT] MISSING extension to the SQL language. Alternatively,
you can call String#trim().length()
and check for zero length.
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid.public boolean getBoolean(int columnIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a boolean
value.public byte getByte(int columnIndex) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to byte
representation.public short getShort(int columnIndex) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to byte
representation.public int getInt(int columnIndex) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid int
value.public long getLong(int columnIndex) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid long
value.public float getFloat(int columnIndex) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid float
value.public double getDouble(int columnIndex) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
double value.@Deprecated public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
BigDecimal value.public byte[] getBytes(int columnIndex) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown because SAS
software does not support conversions to binary
representation.public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Date value.public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Time value.public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Timestamp value.public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Type.VARCHAR value. SAS software does not support
other conversions.public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
MVAResultSet
implementation of getUnicodeStream(int)
only supports columns with a SQL type of java.sql.Types.CHAR
or
java.sql.Types.VARCHAR
.
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
MVAResultSet
implementation of getBinaryStream(int)
only supports columns with a SQL type of java.sql.Types.CHAR
or
java.sql.Types.VARCHAR
.
getBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid.public boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a boolean
value.public byte getByte(java.lang.String columnName) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to byte
representation.public short getShort(java.lang.String columnName) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
short value.public int getInt(java.lang.String columnName) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid int
value.public long getLong(java.lang.String columnName) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
long value.public float getFloat(java.lang.String columnName) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
float value.public double getDouble(java.lang.String columnName) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
double value.@Deprecated public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
BigDecimal value.public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown because SAS
software does not support conversions to binary
representation.public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Date value.public java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Time value.public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Timestamp value.public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the value is not java.sql.Type.VARCHAR. No other
conversions are supported.@Deprecated public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the value is not java.sql.Type.VARCHAR. No other
conversions are supported.public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the value is not java.sql.Type.VARCHAR. No other
conversions are supported.public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface, but
it is never thrown.public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface, but
it is never thrown.public java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if an error condition is
detected.public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnName
- The name of the column.
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public int findColumn(java.lang.String columnName) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
columnName
- The name of the column.
java.sql.SQLException
- This exception is thrown if the column name is
not valid.public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second column is 2, and so
on.
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public java.io.Reader getCharacterStream(int columnIndex, java.lang.String charsetName) throws java.sql.SQLException
columnIndex
- The first column is 1, the second column is 2, and so
on.charsetName
- The name of a supported
charset
java.sql.SQLException
- This exception is thrown if the column index or
type, or file encoding is not valid.public java.io.Reader getCharacterStream(java.lang.String columnName, java.lang.String charsetName) throws java.sql.SQLException
columnName
- The name of the column.charsetName
- The name of a supported
charset
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnName
- The name of the column.
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
ResultSet.FETCH_FORWARD
for the fetch direction, as calls to setFetchDirection(int)
are silently ignored.
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but
it is never thrown.public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but
it is never thrown.public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but
it is never thrown.public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown because SAS
software does not detect row updated.MVADatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown because SAS
software does not detect row inserts.MVADatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown because SAS
software does not detect row deletes.MVADatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is always thrown.public void updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuescale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- This exception is thrown if the column index is
not valid.public void updateNull(java.lang.String columnName) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnName
- the name of the column
java.sql.SQLException
- if a database-access error occurspublic void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- the name of the columnreader
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuescale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.
java.sql.SQLException
- if a database-access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown. This function is
available only on ResultSets generated from
MVAStatement.getTable()public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if called
when on the insert row This function is available only on
ResultSets generated from MVAStatement.getTable()public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if an MvaException is
detected.public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or the result
set is not updatablepublic java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurspublic java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...map
- the mapping from SQL type names to Java classes
java.sql.SQLException
public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
public java.lang.Object getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
colName
- the column namemap
- the mapping from SQL type names to Java classes
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Date value.public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Date value.public java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Time value.public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Time value.public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, and so on.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted to a valid
java.sql.Timestamp value.public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnName
- The name of the column that is returned by the
ResultSetMetaData object.cal
- The calendar to use in constructing the date. Ignored if cal
is NULL.
java.sql.SQLException
- This exception is thrown if the column value is
not valid or the SQL type cannot be converted into a valid
java.sql.Timestamp value.protected com.sas.rio.IRowCache getCache()
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateBlob(java.lang.String columnName, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateClob(java.lang.String columnName, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
ResultSet
object as a java.sql.RowId
object in
the Java programming language.
getRowId
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a java.sql.RowId
object in
the Java programming language.
getRowId
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
RowId
value. The
updater methods are used to update column values in the current row or
the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateRowId
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...x
- the column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
RowId
value. The
updater methods are used to update column values in the current row or
the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateRowId
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx
- the column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public int getHoldability() throws java.sql.SQLException
MVAResultSet
version of #getHoldability()
always
returns ResultSet#CLOSE_CURSORS_AT_COMMIT
. Transactions are
not supported by the IOM JDBC driver.
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isClosed() throws java.sql.SQLException
ResultSet
object has been closed. A
ResultSet
is closed if the method close has been called on
it, or if it is automatically closed.
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
String
value. It is
intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to
update column values in the current row or the insert row. The updater
methods do not update the underlying database; instead the
updateRow
or insertRow
methods are called to
update the database.
updateNString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...nString
- the value for the column to be updated
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNString(java.lang.String columnLabel, java.lang.String nString) throws java.sql.SQLException
String
value. It is
intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to
update column values in the current row or the insert row. The updater
methods do not update the underlying database; instead the
updateRow
or insertRow
methods are called to
update the database.
updateNString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnnString
- the value for the column to be updated
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
java.sql.NClob
value.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...nClob
- the value for the column to be updated
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException
java.sql.NClob
value.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnnClob
- the value for the column to be updated
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
ResultSet
object as a NClob
object in the Java
programming language.
getNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a NClob
object in the Java
programming language.
getNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
ResultSet
as a java.sql.SQLXML
object in the
Java programming language.
getSQLXML
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
as a java.sql.SQLXML
object in the
Java programming language.
getSQLXML
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
value.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateSQLXML
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...xmlObject
- the value for the column to be updated
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
value.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateSQLXML
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnxmlObject
- the column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException
ResultSet
object as a String
in the Java
programming language. It is intended for use when accessing
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a String
in the Java
programming language. It is intended for use when accessing
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a java.io.Reader
object. It
is intended for use when accessing NCHAR
,
NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned
is null
in the Java programming language.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a java.io.Reader
object. It
is intended for use when accessing NCHAR
,
NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned
is null
in the Java programming language
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
NCHAR
,
NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
NCHAR
,
NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the column.reader
- the java.io.Reader
object containing the new
column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- the java.io.Reader
object containing the new
column valuelength
- the length of the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...inputStream
- An object that contains the data to set the parameter
value to.length
- the number of bytes in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columninputStream
- An object that contains the data to set the parameter
value to.length
- the number of bytes in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object,
which is the given number of characters long. When a very large UNICODE
value is input to a LONGVARCHAR
parameter, it may be more
practical to send it via a java.io.Reader
object. The JDBC
driver will do any necessary conversion from UNICODE to the database char
format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value
to.length
- the number of characters in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object,
which is the given number of characters long. When a very large UNICODE
value is input to a LONGVARCHAR
parameter, it may be more
practical to send it via a java.io.Reader
object. The JDBC
driver will do any necessary conversion from UNICODE to the database char
format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- An object that contains the data to set the parameter value
to.length
- the number of characters in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object,
which is the given number of characters long. When a very large UNICODE
value is input to a LONGVARCHAR
parameter, it may be more
practical to send it via a java.io.Reader
object. The JDBC
driver will do any necessary conversion from UNICODE to the database char
format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...reader
- An object that contains the data to set the parameter value
to.length
- the number of characters in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object,
which is the given number of characters long. When a very large UNICODE
value is input to a LONGVARCHAR
parameter, it may be more
practical to send it via a java.io.Reader
object. The JDBC
driver will do any necessary conversion from UNICODE to the database char
format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- An object that contains the data to set the parameter value
to.length
- the number of characters in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
NCHAR
,NVARCHAR
and
LONGNVARCHAR
columns.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
NCHAR
,NVARCHAR
and
LONGNVARCHAR
columns.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- the java.io.Reader
object containing the new
column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx
- the new column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- the java.io.Reader
object containing the new
column value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateBlob
which
takes a length parameter.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...inputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateBlob
which
takes a length parameter.
updateBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columninputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE to
the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateClob
which
takes a length parameter.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE to
the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateClob
which
takes a length parameter.
updateClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Reader
The
data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE to
the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateNClob
which takes a length parameter.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...reader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE to
the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it
might be more efficient to use a version of updateNClob
which takes a length parameter.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
|
Foundation |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |