|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object vortex.sql.vortexResultSet
public class vortexResultSet
This class implements the ResultSet for JDBC interface The class is designed to hold the results of database queries.
ResultSet
Field Summary |
---|
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Method Summary | ||
---|---|---|
boolean |
absolute(int row)
Moves the cursor to the given row number in the result set. |
|
void |
afterLast()
Not supported by VORTEXjdbc. |
|
void |
beforeFirst()
Not supported by VORTEXjdbc. |
|
void |
cancelRowUpdates()
Cancels the updates made to a row. |
|
void |
clearWarnings()
Clear the warning chain. |
|
void |
close()
Close a result set. |
|
void |
deleteRow()
Deletes the current row from the result set and the underlying database. |
|
int |
findColumn(java.lang.String name)
Given a column name, this method returns the column index for that name. |
|
boolean |
first()
Moves the cursor to the first row in the result set. |
|
java.sql.Array |
getArray(int column)
Not supported by VORTEXjdbc. |
|
java.sql.Array |
getArray(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.io.InputStream |
getAsciiStream(int column)
Get the value of a column in the current row as a Java AsciiStream. |
|
java.io.InputStream |
getAsciiStream(java.lang.String name)
Very large ascii values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream. |
|
java.math.BigDecimal |
getBigDecimal(int column)
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. |
|
java.math.BigDecimal |
getBigDecimal(int column,
int scale)
Get the value of a column in the current row as a Java BigDecimal. |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String name)
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String name,
int scale)
Retrieve the column value as a numeric based on column name |
|
java.io.InputStream |
getBinaryStream(int column)
Get the value of a column in the current row as a Java BinaryStream. |
|
java.io.InputStream |
getBinaryStream(java.lang.String name)
Very large binary values in a LONGVARBINARY column can be read in small chunks from a java.io.InputStream. |
|
java.sql.Blob |
getBlob(int column)
Not supported by VORTEXjdbc. |
|
java.sql.Blob |
getBlob(java.lang.String name)
Not supported by VORTEXjdbc. |
|
boolean |
getBoolean(int column)
Get the value of a column in the current row as a Java boolean. |
|
boolean |
getBoolean(java.lang.String name)
Retrieve the column value as a boolean based on column name |
|
byte |
getByte(int column)
Get the value of a column in the current row as a Java byte. |
|
byte |
getByte(java.lang.String name)
Get the value of a column in the current row as a Java byte. |
|
byte[] |
getBytes(int column)
Get the value of a column in the current row as a Java byte array. |
|
byte[] |
getBytes(java.lang.String name)
Retrieve the column value as a byte array based on column name |
|
java.io.Reader |
getCharacterStream(int column)
Not supported by VORTEXjdbc. |
|
java.io.Reader |
getCharacterStream(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.sql.Clob |
getClob(int column)
Not supported by VORTEXjdbc. |
|
java.sql.Clob |
getClob(java.lang.String name)
Not supported by VORTEXjdbc. |
|
int |
getConcurrency()
Returns the concurrency mode of this result set. |
|
java.lang.String |
getCursorName()
Return a cursor name |
|
java.sql.Date |
getDate(int column)
Get the value of a column in the current row as a Java date. |
|
java.sql.Date |
getDate(int column,
java.util.Calendar c)
Get the value of a column in the current row as a Java date. |
|
java.sql.Date |
getDate(java.lang.String name)
Retrieve the column value as a date based on column name |
|
java.sql.Date |
getDate(java.lang.String name,
java.util.Calendar c)
Get the value of a column in the current row as a Java date. |
|
double |
getDouble(int column)
Get the value of a column in the current row as a Java double. |
|
double |
getDouble(java.lang.String name)
Retrieve the column value as a double based on column name |
|
int |
getFetchDirection()
Returns the fetch direction for this result set. |
|
int |
getFetchSize()
Returns the fetch size for this result set. |
|
float |
getFloat(int column)
Get the value of a column in the current row as a Java float. |
|
float |
getFloat(java.lang.String name)
Retrieve the column value as a float based on column name |
|
int |
getHoldability()
Retrieves the holdability of this ResultSet object |
|
int |
getInt(int column)
Get the value of a column in the current row as a Java int. |
|
int |
getInt(java.lang.String name)
Retreive the column value as a int based on column name |
|
long |
getLong(int column)
Get the value of a column in the current row as a Java long. |
|
long |
getLong(java.lang.String name)
Retrieve the column value as a long based on column name |
|
java.sql.ResultSetMetaData |
getMetaData()
return meta-data on a result set. |
|
java.io.Reader |
getNCharacterStream(int column)
Not supported by VORTEXjdbc. |
|
java.io.Reader |
getNCharacterStream(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.sql.NClob |
getNClob(int column)
Not supported by VORTEXjdbc. |
|
java.sql.NClob |
getNClob(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.lang.String |
getNString(int column)
Not supported by VORTEXjdbc. |
|
java.lang.String |
getNString(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.lang.Object |
getObject(int column)
Get the value of a column in the current row as a Java Object. |
|
java.lang.Object |
getObject(int column,
int type)
Get the value of a column in the current row as a Java Object. |
|
java.lang.Object |
getObject(int column,
int type,
int scale)
Get the value of a column in the current row as a Java Object. |
|
java.lang.Object |
getObject(int column,
java.util.Map map)
Not supported by VORTEXjdbc. |
|
java.lang.Object |
getObject(java.lang.String name)
Same as above, except returning the default SQL type |
|
java.lang.Object |
getObject(java.lang.String name,
int type)
Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream. |
|
java.lang.Object |
getObject(java.lang.String name,
int type,
int scale)
Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream. |
|
java.lang.Object |
getObject(java.lang.String name,
java.util.Map map)
Not supported by VORTEXjdbc. |
|
java.sql.Ref |
getRef(int column)
Not supported by VORTEXjdbc. |
|
java.sql.Ref |
getRef(java.lang.String name)
Not supported by VORTEXjdbc. |
|
int |
getRow()
Retrieves the current row number. |
|
java.sql.RowId |
getRowId(int column)
Not supported by VORTEXjdbc. |
|
java.sql.RowId |
getRowId(java.lang.String name)
Not supported by VORTEXjdbc. |
|
short |
getShort(int column)
Get the value of a column in the current row as a Java short. |
|
short |
getShort(java.lang.String name)
Retrieve the column value as a short based on column name |
|
java.sql.SQLXML |
getSQLXML(int column)
Not supported by VORTEXjdbc. |
|
java.sql.SQLXML |
getSQLXML(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.sql.Statement |
getStatement()
Returns the Statement that produced this ResultSet object. |
|
java.lang.String |
getString(int column)
Get the value of a column in the current row as a Java string. |
|
java.lang.String |
getString(java.lang.String name)
Get the value of a column in the current row as a Java String. |
|
java.sql.Time |
getTime(int column)
Get the value of a column in the current row as a Java time. |
|
java.sql.Time |
getTime(int column,
java.util.Calendar c)
Get the value of a column in the current row as a Java time. |
|
java.sql.Time |
getTime(java.lang.String name)
Retrieve the column value as a time based on column name |
|
java.sql.Time |
getTime(java.lang.String name,
java.util.Calendar c)
Get the value of a column in the current row as a Java time. |
|
java.sql.Timestamp |
getTimestamp(int column)
Get the value of a column in the current row as a Java timestamp. |
|
java.sql.Timestamp |
getTimestamp(int column,
java.util.Calendar c)
Get the value of a column in the current row as a Java timestamp. |
|
java.sql.Timestamp |
getTimestamp(java.lang.String name)
Retrieve the column value as a timestamp based on column name |
|
java.sql.Timestamp |
getTimestamp(java.lang.String name,
java.util.Calendar c)
Get the value of a column in the current row as a Java timestamp. |
|
int |
getType()
Returns the type of this result set. |
|
java.io.InputStream |
getUnicodeStream(int column)
Get the value of a column in the current row as a Java UnicodeStream. |
|
java.io.InputStream |
getUnicodeStream(java.lang.String name)
Very large unicode values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream. |
|
java.net.URL |
getURL(int column)
Not supported by VORTEXjdbc. |
|
java.net.URL |
getURL(java.lang.String name)
Not supported by VORTEXjdbc. |
|
java.sql.SQLWarning |
getWarnings()
Return warning message |
|
void |
insertRow()
Inserts the contents of the insert row into the result set and the database. |
|
boolean |
isAfterLast()
Not supported by VORTEXjdbc. |
|
boolean |
isBeforeFirst()
Indicates whether the cursor is before the first row in the result set. |
|
boolean |
isClosed()
Retrieves whether this ResultSet object has been closed. |
|
boolean |
isFirst()
Indicates whether the cursor is on the first row of the result set. |
|
boolean |
isLast()
Not supported by VORTEXjdbc. |
|
boolean |
isNull(int column)
Reports whether the column has a value of SQL NULL. |
|
boolean |
isNull(java.lang.String name)
column is NULL? |
|
boolean |
isWrapperFor(java.lang.Class<?> ResultSet)
|
|
boolean |
last()
Moves the cursor to the last row in the result set. |
|
void |
moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row. |
|
void |
moveToInsertRow()
Moves the cursor to the insert row. |
|
boolean |
next()
Move to the next row of record, return true if there is one |
|
boolean |
previous()
Moves the cursor to the previous row in the result set. |
|
void |
refreshRow()
Not supported by VORTEXjdbc. |
|
boolean |
relative(int rows)
Moves the cursor a relative number of rows, either positive or negative. |
|
boolean |
rowDeleted()
Not supported by VORTEXjdbc. |
|
boolean |
rowInserted()
Not supported by VORTEXjdbc. |
|
boolean |
rowUpdated()
Not supported by VORTEXjdbc. |
|
void |
setFetchDirection(int direction)
Not supported by VORTEXjdbc. |
|
void |
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. |
|
|
unwrap(java.lang.Class<T> ResultSet)
|
|
void |
updateArray(int column,
java.sql.Array x)
Not supported by VORTEXjdbc Updates a column with an array value. |
|
void |
updateArray(java.lang.String name,
java.sql.Array x)
Not supported by VORTEXjdbc Updates a column with an array value. |
|
void |
updateAsciiStream(int column,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateAsciiStream(int column,
java.io.InputStream x,
int length)
Updates a column with an ascii stream value. |
|
void |
updateAsciiStream(int column,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateAsciiStream(java.lang.String name,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateAsciiStream(java.lang.String name,
java.io.InputStream x,
int length)
Updates a column with an ascii stream value. |
|
void |
updateAsciiStream(java.lang.String name,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateBigDecimal(int column,
java.math.BigDecimal x)
Updates a column with a BigDecimal value. |
|
void |
updateBigDecimal(java.lang.String name,
java.math.BigDecimal x)
Updates a column with a BigDecimal value. |
|
void |
updateBinaryStream(int column,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateBinaryStream(int column,
java.io.InputStream x,
int length)
Updates a column with a binary stream value. |
|
void |
updateBinaryStream(int column,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateBinaryStream(java.lang.String name,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateBinaryStream(java.lang.String name,
java.io.InputStream x,
int length)
Updates a column with a binary stream value. |
|
void |
updateBinaryStream(java.lang.String name,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateBlob(int column,
java.sql.Blob x)
Not supported by VORTEXjdbc Updates a column with a blob value. |
|
void |
updateBlob(int column,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateBlob(int column,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateBlob(java.lang.String name,
java.sql.Blob x)
Not supported by VORTEXjdbc Updates a column with a Blob value. |
|
void |
updateBlob(java.lang.String name,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateBlob(java.lang.String name,
java.io.InputStream x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateBoolean(int column,
boolean x)
Updates a column with a boolean value. |
|
void |
updateBoolean(java.lang.String name,
boolean x)
Updates a column with a boolean value. |
|
void |
updateByte(int column,
byte x)
Updates a column with a byte value. |
|
void |
updateByte(java.lang.String name,
byte x)
Updates a column with a byte value. |
|
void |
updateBytes(int column,
byte[] x)
Updates a column with a byte array value. |
|
void |
updateBytes(java.lang.String name,
byte[] x)
Updates a column with a byte array value. |
|
void |
updateCharacterStream(int column,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateCharacterStream(int column,
java.io.Reader x,
int length)
Updates a column with a character stream value. |
|
void |
updateCharacterStream(int column,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateCharacterStream(java.lang.String name,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateCharacterStream(java.lang.String name,
java.io.Reader x,
int length)
Updates a column with a character stream value. |
|
void |
updateCharacterStream(java.lang.String name,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateClob(int column,
java.sql.Clob x)
Not supported by VORTEXjdbc. |
|
void |
updateClob(int column,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateClob(int column,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateClob(java.lang.String name,
java.sql.Clob x)
Not supported by VORTEXjdbc. |
|
void |
updateClob(java.lang.String name,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateClob(java.lang.String name,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateDate(int column,
java.sql.Date x)
Updates a column with a Date value. |
|
void |
updateDate(java.lang.String name,
java.sql.Date x)
Updates a column with a Date value. |
|
void |
updateDouble(int column,
double x)
Updates a column with a Double value. |
|
void |
updateDouble(java.lang.String name,
double x)
Updates a column with a Double value. |
|
void |
updateFloat(int column,
float x)
Updates a column with a float value. |
|
void |
updateFloat(java.lang.String name,
float x)
Updates a column with a float value. |
|
void |
updateInt(int column,
int x)
Updates a column with a integer value. |
|
void |
updateInt(java.lang.String name,
int x)
Updates a column with a integer value. |
|
void |
updateLong(int column,
long x)
Updates a column with a long value. |
|
void |
updateLong(java.lang.String name,
long x)
Updates a column with a long value. |
|
void |
updateNCharacterStream(int column,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateNCharacterStream(int column,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateNCharacterStream(int column,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateNCharacterStream(java.lang.String name,
java.io.InputStream x)
Not supported by VORTEXjdbc. |
|
void |
updateNCharacterStream(java.lang.String name,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateNCharacterStream(java.lang.String name,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(int column,
java.sql.NClob x)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(int column,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(int column,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(java.lang.String name,
java.sql.NClob x)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(java.lang.String name,
java.io.Reader x)
Not supported by VORTEXjdbc. |
|
void |
updateNClob(java.lang.String name,
java.io.Reader x,
long len)
Not supported by VORTEXjdbc. |
|
void |
updateNString(int column,
java.lang.String x)
Not supported by VORTEXjdbc. |
|
void |
updateNString(java.lang.String name,
java.lang.String x)
Not supported by VORTEXjdbc. |
|
void |
updateNull(int column)
Give a nullable column a null value. |
|
void |
updateNull(java.lang.String name)
Give a nullable column a null value. |
|
void |
updateObject(int column,
java.lang.Object x)
Updates a column with an Object value. |
|
void |
updateObject(int column,
java.lang.Object x,
int scale)
Updates a column with an Object value. |
|
void |
updateObject(java.lang.String name,
java.lang.Object x)
Updates a column with an Object value. |
|
void |
updateObject(java.lang.String name,
java.lang.Object x,
int scale)
Updates a column with an Object value. |
|
void |
updateRef(int column,
java.sql.Ref x)
Not supported by VORTEXjdbc. |
|
void |
updateRef(java.lang.String name,
java.sql.Ref x)
Not supported by VORTEXjdbc. |
|
void |
updateRow()
Updates the underlying database with the new contents of the current row. |
|
void |
updateRowId(int column,
java.sql.RowId x)
Not supported by VORTEXjdbc. |
|
void |
updateRowId(java.lang.String name,
java.sql.RowId x)
Not supported by VORTEXjdbc. |
|
void |
updateShort(int column,
short x)
Updates a column with a short value. |
|
void |
updateShort(java.lang.String name,
short x)
Updates a column with a short value. |
|
void |
updateSQLXML(int column,
java.sql.SQLXML x)
Not supported by VORTEXjdbc. |
|
void |
updateSQLXML(java.lang.String name,
java.sql.SQLXML x)
Not supported by VORTEXjdbc. |
|
void |
updateString(int column,
java.lang.String x)
Updates a column with a String value. |
|
void |
updateString(java.lang.String name,
java.lang.String x)
Updates a column with a String value. |
|
void |
updateTime(int column,
java.sql.Time x)
Updates a column with a Time value. |
|
void |
updateTime(java.lang.String name,
java.sql.Time x)
Updates a column with a Time value. |
|
void |
updateTimestamp(int column,
java.sql.Timestamp x)
Updates a column with a Timestamp value. |
|
void |
updateTimestamp(java.lang.String name,
java.sql.Timestamp x)
Updates a column with a Timestamp value. |
|
boolean |
wasNull()
Reports whether the last column had a value of SQL NULL. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
- thrown if an error occurs during processingResultSet.next()
public boolean isNull(int column) throws java.sql.SQLException
column
- the column being tested for nullness
java.sql.SQLException
- thrown if column out of rangepublic boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
- thrown if column out of rangeResultSet.wasNull()
public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isFirst() throws java.sql.SQLException
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
public void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set type is TYPE_FORWARD_ONLYpublic void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set type is TYPE_FORWARD_ONLYpublic boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set type is TYPE_FORWARD_ONLYpublic boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set type is TYPE_FORWARD_ONLYpublic int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database error occurspublic boolean absolute(int row) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
row
- - the row number
java.sql.SQLException
- thrown if row is 0 or result set type is
TYPE_FORWARD_ONLY.public boolean relative(int rows) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
rows
- - the number of rows
java.sql.SQLException
- thrown if there is no current row or the result
set type is TYPE_FORWARD_ONLYpublic boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
- thrown if there is no current row or the result
set type is TYPE_FORWARD_ONLYpublic java.sql.Array getArray(int column) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
column
- the column to fetch
java.sql.SQLException
public java.sql.Array getArray(java.lang.String name) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
public java.sql.Blob getBlob(int column) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String name) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
name
- the column to fetch
java.sql.SQLException
public java.sql.Clob getClob(int column) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String name) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
name
- the column to fetch
java.sql.SQLException
public java.io.Reader getCharacterStream(int column) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
column
- the column to fetch
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String name) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
public java.lang.String getString(int column) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getString(int)
public byte getByte(int column) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
java.sql.SQLException
- thrown for invalid columns or bad rowspublic boolean getBoolean(int column) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
column
- the column for which the value is being retrieved
java.sql.SQLException
- error converting data to stringResultSet.getBoolean(int)
public short getShort(int column) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getShort(int)
public int getInt(int column) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getInt(int)
public long getLong(int column) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getLong(int)
public float getFloat(int column) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getFloat(int)
public double getDouble(int column) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getDouble(int)
public java.math.BigDecimal getBigDecimal(int column, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
column
- the column being retrievedscale
- how many decimal digits after the floating point to maintain
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getBigDecimal(int, int)
public byte[] getBytes(int column) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getBytes(int)
public java.sql.Date getDate(int column) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getDate(int)
public java.sql.Date getDate(int column, java.util.Calendar c) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getDate(int)
public java.sql.Date getDate(java.lang.String name, java.util.Calendar c) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
name
- the column name being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getDate(int)
public java.sql.Time getTime(int column) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTime(int)
public java.sql.Time getTime(int column, java.util.Calendar c) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
column
- the column being retrievedc
- the calendar
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTime(int)
public java.sql.Time getTime(java.lang.String name, java.util.Calendar c) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
name
- the column name to fetchc
- the calendar
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTime(int)
public java.sql.Timestamp getTimestamp(int column) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTimestamp(int)
public java.sql.Timestamp getTimestamp(int column, java.util.Calendar c) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTimestamp(int)
public java.sql.Timestamp getTimestamp(java.lang.String name, java.util.Calendar c) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
name
- the column name being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getTimestamp(int)
public java.io.InputStream getAsciiStream(int column) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getAsciiStream(int)
public java.io.InputStream getUnicodeStream(int column) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getAsciiStream(int)
public java.io.InputStream getBinaryStream(int column) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
column
- the column being retrieved
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getBinaryStream(int)
public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
- do nothingResultSet.close()
public java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
- do nothingResultSet.getCursorName()
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
- thrown on error getting meta-dataResultSet.getMetaData()
public java.lang.Object getObject(int column, int type, int scale) throws java.sql.SQLException
column
- the column desiredtype
- the SQL data type of the fieldscale
- precision for Numerics
java.sql.SQLException
- thrown for invalid columns or bad rowsResultSet.getObject(int)
public java.lang.Object getObject(int column, int type) throws java.sql.SQLException
column
- The SQL column indextype
- SQL type code defined by java.sql.Types
java.sql.SQLException
- thrown for invalid columns or bad rowspublic java.lang.Object getObject(int column) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
column
- The SQL column index
java.sql.SQLException
- thrown for invalid columns or bad rowspublic java.lang.String getString(java.lang.String name) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getString(int)
public byte getByte(java.lang.String name) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- if a database-access error occurs.ResultSet.getByte(int)
public boolean getBoolean(java.lang.String name) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- if a database-access error occurs.ResultSet.getBoolean(int)
public short getShort(java.lang.String name) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getShort(int)
public int getInt(java.lang.String name) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getInt(int)
public long getLong(java.lang.String name) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getLong(int)
public float getFloat(java.lang.String name) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getFloat(int)
public double getDouble(java.lang.String name) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getDouble(int)
public java.math.BigDecimal getBigDecimal(java.lang.String name, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
name
- the column namescale
- the scale of the numeric column
java.sql.SQLException
- do nothingResultSet.getBigDecimal(int, int)
public java.math.BigDecimal getBigDecimal(int column) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String name) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
name
- column to fetch
java.sql.SQLException
public byte[] getBytes(java.lang.String name) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getByte(int)
public java.sql.Date getDate(java.lang.String name) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getDate(int)
public java.sql.Time getTime(java.lang.String name) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getTime(int)
public java.sql.Timestamp getTimestamp(java.lang.String name) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- do nothingResultSet.getTimestamp(int)
public java.io.InputStream getAsciiStream(java.lang.String name) throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
getAsciiStream
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- Not usedpublic java.io.InputStream getUnicodeStream(java.lang.String name) throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
getUnicodeStream
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- Not usedpublic java.io.InputStream getBinaryStream(java.lang.String name) throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
getBinaryStream
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- Not usedpublic java.lang.Object getObject(java.lang.String name, int type, int scale) throws java.sql.SQLException
name
- the column nametype
- SQL type code defined by java.sql.Types
java.sql.SQLException
- Not usedpublic java.lang.Object getObject(java.lang.String name, int type) throws java.sql.SQLException
name
- the column nametype
- SQL type code defined by java.sql.Types
java.sql.SQLException
public java.lang.Object getObject(java.lang.String name) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
public java.lang.Object getObject(int column, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...map
- the mapping from SQL type names to Java classes
java.sql.SQLException
public java.lang.Object getObject(java.lang.String name, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
name
- the column namemap
- the mapping from SQL type names to Java classes
java.sql.SQLException
public java.net.URL getURL(int column) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
public java.net.URL getURL(java.lang.String name) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
name
- - name of the column
java.sql.SQLException
public boolean isNull(java.lang.String name) throws java.sql.SQLException
name
- the column name
java.sql.SQLException
- Not usedpublic java.sql.Ref getRef(int column) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
- Not usedpublic java.sql.Ref getRef(java.lang.String name) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
- Not usedpublic int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
direction
- to set
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
rows
- - the number of rows to fetch
java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNull(int column) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...
java.sql.SQLException
public void updateNull(java.lang.String name) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
name
- the column name
java.sql.SQLException
public void updateArray(int column, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateArray(java.lang.String name, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
name
- - name of the column to updatex
- - the new column value
java.sql.SQLException
public void updateBlob(int column, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateBlob(java.lang.String name, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
name
- - name of the column to updatex
- - the new column value
java.sql.SQLException
public void updateBoolean(int column, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateBoolean(java.lang.String name, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateByte(int column, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateByte(java.lang.String name, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateClob(int column, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateClob(java.lang.String name, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
name
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateRef(int column, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateRef(java.lang.String name, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
name
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateShort(int column, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateShort(java.lang.String name, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateInt(int column, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateInt(java.lang.String name, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
name
- the column namex
- - the new column value
java.sql.SQLException
public void updateLong(int column, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateLong(java.lang.String name, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
name
- the column namex
- - the new column value
java.sql.SQLException
public void updateFloat(int column, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateFloat(java.lang.String name, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
name
- the column namex
- - then new column value
java.sql.SQLException
public void updateDouble(int column, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateDouble(java.lang.String name, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
name
- the column namex
- - then new column value
java.sql.SQLException
public void updateBigDecimal(int column, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateBigDecimal(java.lang.String name, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
name
- the column namex
- - then new column value
java.sql.SQLException
public void updateString(int column, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateString(java.lang.String name, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
name
- the column namex
- - then new column value
java.sql.SQLException
public void updateBytes(int column, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateBytes(java.lang.String name, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateDate(int column, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateDate(java.lang.String name, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateTime(int column, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateTime(java.lang.String name, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateTimestamp(int column, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - the new column value
java.sql.SQLException
public void updateTimestamp(java.lang.String name, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
name
- - the column namex
- - the new column value
java.sql.SQLException
public void updateAsciiStream(int column, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateAsciiStream(java.lang.String name, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
name
- the column namex
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateBinaryStream(int column, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateBinaryStream(java.lang.String name, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
name
- the column namex
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateCharacterStream(int column, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateCharacterStream(java.lang.String name, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
name
- the column namex
- - then new column valuelength
- - the length of the stream
java.sql.SQLException
public void updateObject(int column, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then 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 is
ignored
java.sql.SQLException
public void updateObject(java.lang.String name, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
name
- the column namex
- - then 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 is
ignored
java.sql.SQLException
public void updateObject(int column, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
column
- - the first column is 1, the second is 2, ...x
- - then new column value
java.sql.SQLException
public void updateObject(java.lang.String name, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
name
- the column namex
- - then new column value
java.sql.SQLException
public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
public void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if called when on the insert row.public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if called when not on the insert row or if not all
of non-nullable columns in the insert row have been given a valuepublic void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if called when on the insert rowpublic void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if called when on the insert rowpublic void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if called when on the insert rowpublic int findColumn(java.lang.String name) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
name
- the name of the column desired
java.sql.SQLException
- thrown if a bad name is passedpublic java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- Not usedStatement.getWarnings()
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- Not usedStatement.clearWarnings()
public boolean isWrapperFor(java.lang.Class<?> ResultSet) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
public <T> T unwrap(java.lang.Class<T> ResultSet) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
public void updateNClob(int column, java.sql.NClob x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a NClob value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- the new column value
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNClob(java.lang.String name, java.sql.NClob x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a NClob value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- the new column value
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNClob(int column, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNClob(java.lang.String name, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNClob(int column, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNClob(java.lang.String name, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateClob(int column, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateClob(java.lang.String name, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateClob(int column, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateClob(java.lang.String name, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBlob(int column, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBlob(java.lang.String name, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBlob(int column, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBlob(java.lang.String name, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateCharacterStream(int column, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateCharacterStream(java.lang.String name, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateCharacterStream(int column, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateCharacterStream(java.lang.String name, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBinaryStream(int column, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBinaryStream(java.lang.String name, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBinaryStream(int column, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateBinaryStream(java.lang.String name, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateAsciiStream(int column, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateAsciiStream(java.lang.String name, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateAsciiStream(int column, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateAsciiStream(java.lang.String name, java.io.InputStream x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- an InputStream object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(int column, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
column
- the first column is 1, the second is 2, ...x
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(java.lang.String name, java.io.InputStream x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with an InputStream value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
name
- the column namex
- an InputStream object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(int column, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(java.lang.String name, java.io.Reader x, long len) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the datalen
- length of the data to update
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(int column, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNCharacterStream(java.lang.String name, java.io.Reader x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a Reader value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a Reader object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.io.Reader getNCharacterStream(int column) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getNCharacterStream
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.io.Reader getNCharacterStream(java.lang.String name) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getNCharacterStream
in interface java.sql.ResultSet
name
- the column name
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.lang.String getNString(int column) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a String.
getNString
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.lang.String getNString(java.lang.String name) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getNString
in interface java.sql.ResultSet
name
- the column name
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateSQLXML(int column, java.sql.SQLXML x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a SQLXML value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a SQLXML object
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateSQLXML(java.lang.String name, java.sql.SQLXML x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a SQLXML value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a SQLXML object
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.SQLXML getSQLXML(int column) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a SQLXML object.
getSQLXML
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.SQLXML getSQLXML(java.lang.String name) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getSQLXML
in interface java.sql.ResultSet
name
- the column name
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.NClob getNClob(int column) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
getNClob
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.NClob getNClob(java.lang.String name) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object.
getNClob
in interface java.sql.ResultSet
name
- the column name
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNString(int column, java.lang.String x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a NString value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a String
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateNString(java.lang.String name, java.lang.String x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a NString value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a String
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
- - if a database access error occurspublic int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
- - if a database access error occurs or this method is called on a closed result setpublic void updateRowId(int column, java.sql.RowId x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a RowId value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
column
- the first column is 1, the second is 2, ...x
- a RowId object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public void updateRowId(java.lang.String name, java.sql.RowId x) throws java.sql.SQLException
Not supported by VORTEXjdbc. Updates a column with a RowId value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX 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
name
- the column namex
- a RowId object containing the data
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.RowId getRowId(int column) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a RowId.
getRowId
in interface java.sql.ResultSet
column
- the first column is 1, the second is 2, ...
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String name) throws java.sql.SQLException
Not supported by VORTEXjdbc. Retrieves the value of the designated column in the current row of this ResultSet object as a RowId.
getRowId
in interface java.sql.ResultSet
name
- the column name
SQLException,
- SQLFeatureNotSupportedException
java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |