|
Components |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.net.sharenet.ShareNetResultSet
public class ShareNetResultSet
This class implements java.sql.ResultSet.
Field Summary | |
---|---|
protected ShareNetConnection |
connection
|
protected com.sas.net.sharenet.SqlValue[] |
currentRow
|
protected int |
currentRowNumber
|
protected java.lang.String |
cursorName
|
protected ShareNetDatabaseMetaData |
dbmd
|
protected com.sas.net.sharenet.SqlField[] |
fieldArray
|
protected boolean |
maxReached
|
protected int |
maxRows
|
protected java.util.Hashtable |
namesToColumns
|
protected int |
numColumns
|
protected int |
rowsFetched
|
protected com.sas.net.sharenet.ShareNetWarning |
shareWarning
|
protected ShareNetStatement |
stmt
|
protected short |
sv
|
protected java.sql.SQLWarning |
warnings
|
protected boolean |
wasnull
|
Method Summary | |
---|---|
boolean |
absolute(int row)
JDBC 2.0 Moves to an absolute row number in the result set. |
void |
addWarning(java.sql.SQLWarning warning)
Adds a warning to the result set. |
void |
afterLast()
JDBC 2.0 Moves to the end of the result set, just after the last row. |
void |
beforeFirst()
JDBC 2.0 Moves to the front of the result set, just before the first row. |
void |
cancelRowUpdates()
JDBC 2.0 Cancels row updates. |
void |
clearWarnings()
Clears all warnings. |
void |
close()
Closes the ResultSet. |
void |
deleteRow()
JDBC 2.0 Deletes the current row from the result set and the underlying database. |
protected com.sas.net.sharenet.SqlValue[] |
fetch()
Fetch the next row of the data table. |
java.lang.String |
fieldFormat(int i)
Find the type of all the fields in the query. |
java.lang.String[] |
fieldNames()
Find the names of all the fields in the query. |
int |
fieldType(int i)
Find the type of all the fields in the query. |
protected void |
finalize()
Protected method which cleans up state associated with this object. |
int |
findColumn(java.lang.String columnName)
Gets the index of a column. |
boolean |
first()
JDBC 2.0 Moves to the first row in the result set. |
java.sql.Array |
getArray(int i)
JDBC 2.0 Gets the value of column as an Array object. |
java.sql.Array |
getArray(java.lang.String colName)
JDBC 2.0 Gets the value of column as an array object. |
java.io.InputStream |
getAsciiStream(int column)
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)
JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(int column,
int scale)
Deprecated. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated. |
java.io.InputStream |
getBinaryStream(int column)
Gets the value of a column in the current row as a Java InputStream. |
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 Gets the value of column as a BLOB object. |
java.sql.Blob |
getBlob(java.lang.String colName)
JDBC 2.0 Gets the value of column as a BLOB object. |
boolean |
getBoolean(int column)
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 column)
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 column)
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. |
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 (S0639040) 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 (S0639040) 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 Gets the value of column as a CLOB object. |
java.sql.Clob |
getClob(java.lang.String colName)
JDBC 2.0 Gets the value of column as a CLOB object. |
int |
getConcurrency()
JDBC 2.0 Gets the result set concurrency type CONCUR_READ_ONLY as the resultset is a READ ONLY resultset. |
java.lang.String |
getCursorName()
Gets the name of the cursor. |
java.sql.Date |
getDate(int column)
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 column)
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()
JDBC 2.0 Gets the fetch direction for this result set. |
int |
getFetchSize()
JDBC 2.0 Gets the number of rows to be fetched. |
float |
getFloat(int column)
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 |
getInt(int column)
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 column)
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.lang.Object |
getObject(int column)
Gets the value of a column in its default Java representation. |
java.lang.Object |
getObject(int i,
java.util.Map map)
JDBC 2.0 Gets 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 map)
JDBC 2.0 Gets the value of column @i as a Java object. |
java.sql.Ref |
getRef(int i)
JDBC 2.0 Gets the value of column as a REF(<structured-type>) object. |
java.sql.Ref |
getRef(java.lang.String colName)
JDBC 2.0 Gets the value of column as a REF(<structured-type>) object. |
int |
getRow()
JDBC 2.0 Determines the current row number. |
short |
getShort(int column)
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.Statement |
getStatement()
JDBC 2.0 Gets the Statement that produced the ResultSet. |
java.lang.String |
getString(int column)
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 column)
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 column)
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 TYPE_FORWARD_ONLY as scrolling is not supported. |
java.io.InputStream |
getUnicodeStream(int column)
Deprecated. |
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()
Get the SQLWarnings that are associated with this row. |
void |
insertRow()
JDBC 2.0 Inserts 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 |
isFirst()
JDBC 2.0 Determines if the cursor is on the first row of the result set. |
boolean |
isLast()
JDBC 2.0 Determines if the cursor is on the last row of the result set. |
boolean |
last()
JDBC 2.0 Moves to the last row in the result set. |
void |
moveToCurrentRow()
JDBC 2.0 Moves the cursor to the remembered cursor position, usually the current row. |
void |
moveToInsertRow()
JDBC 2.0 Moves to the insert row. |
boolean |
next()
Proceeds to the next row in the ResultSet. |
int |
numFields()
Return the number of fields in the query. |
boolean |
previous()
JDBC 2.0 Moves to the previous row in the result set. |
void |
refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in the database. |
boolean |
relative(int rows)
JDBC 2.0 Moves a relative number of rows, either positive or negative. |
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 Determines if the current row has been updated. |
protected void |
send(com.sas.net.sharenet.Wqefcb fcb)
Sends a message to the server. |
void |
setFetchDirection(int direction)
JDBC 2.0 Gives a hint as to the direction in which the rows in this result set will be processed. |
void |
setFetchSize(int rows)
JDBC 2.0 Sets the number of rows to be fetched for this result set. |
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,
int length)
JDBC 2.0 Updates a column with an ascii stream value. |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Updates a column with an ascii stream value. |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
JDBC 2.0 Updates a column with a BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
JDBC 2.0 Updates a column with a BigDecimal value. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Updates a column with a binary stream value. |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Updates a column with a binary stream value. |
void |
updateBlob(int columnIndex,
java.sql.Blob x)
Updates the designated column with a java.sql.Blob value. |
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x)
Updates the designated column with a java.sql.Blob value. |
void |
updateBoolean(int columnIndex,
boolean x)
JDBC 2.0 Updates a column with a boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x)
JDBC 2.0 Updates a column with a boolean value. |
void |
updateByte(int columnIndex,
byte x)
JDBC 2.0 Updates a column with a byte value. |
void |
updateByte(java.lang.String columnName,
byte x)
JDBC 2.0 Updates a column with a byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Updates a column with a byte array value. |
void |
updateBytes(java.lang.String columnName,
byte[] x)
JDBC 2.0 Updates a column with a byte array value. |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
JDBC 2.0 Updates a column with a character stream value. |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
JDBC 2.0 Updates a column with a character stream value. |
void |
updateClob(int columnIndex,
java.sql.Clob x)
Updates the designated column with a java.sql.Clob value. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob x)
Updates the designated column with a java.sql.Clob value. |
void |
updateDate(int columnIndex,
java.sql.Date x)
JDBC 2.0 Updates a column with a Date value. |
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
JDBC 2.0 Updates a column with a Date value. |
void |
updateDouble(int columnIndex,
double x)
JDBC 2.0 Updates a column with a Double value. |
void |
updateDouble(java.lang.String columnName,
double x)
JDBC 2.0 Updates a column with a double value. |
void |
updateFloat(int columnIndex,
float x)
JDBC 2.0 Updates a column with a float value. |
void |
updateFloat(java.lang.String columnName,
float x)
JDBC 2.0 Updates a column with a float value. |
void |
updateInt(int columnIndex,
int x)
JDBC 2.0 Updates a column with an integer value. |
void |
updateInt(java.lang.String columnName,
int x)
JDBC 2.0 Updates a column with an integer value. |
void |
updateLong(int columnIndex,
long x)
JDBC 2.0 Updates a column with a long value. |
void |
updateLong(java.lang.String columnName,
long x)
JDBC 2.0 Updates a column with a long value. |
void |
updateNull(int columnIndex)
JDBC 2.0 Updates a nullable column with a null value. |
void |
updateNull(java.lang.String columnName)
JDBC 2.0 Updates a column with a null value. |
void |
updateObject(int columnIndex,
java.lang.Object x)
JDBC 2.0 Updates a column with an Object value. |
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
JDBC 2.0 Updates a column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
JDBC 2.0 Updates a column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
JDBC 2.0 Updates a column with an Object value. |
void |
updateRef(int columnIndex,
java.sql.Ref x)
Updates the designated column with a java.sql.Ref value. |
void |
updateRef(java.lang.String columnName,
java.sql.Ref x)
Updates the designated column with a java.sql.Ref value. |
void |
updateRow()
JDBC 2.0 Updates the underlying database with the new contents of the current row. |
void |
updateShort(int columnIndex,
short x)
JDBC 2.0 Updates a column with a short value. |
void |
updateShort(java.lang.String columnName,
short x)
JDBC 2.0 Updates a column with a short value. |
void |
updateString(int columnIndex,
java.lang.String x)
JDBC 2.0 Updates a column with a String value. |
void |
updateString(java.lang.String columnName,
java.lang.String x)
JDBC 2.0 Updates a column with a String value. |
void |
updateTime(int columnIndex,
java.sql.Time x)
JDBC 2.0 Updates a column with a Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
JDBC 2.0 Updates a column with a Time value. |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
JDBC 2.0 Updates a column with a Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
JDBC 2.0 Updates a column with a Timestamp value. |
boolean |
wasNull()
Determines whether the given column in the current row holds an SQL NULL. |
Field Detail |
---|
protected com.sas.net.sharenet.SqlValue[] currentRow
protected com.sas.net.sharenet.SqlField[] fieldArray
protected int numColumns
protected int currentRowNumber
protected int rowsFetched
protected boolean maxReached
protected int maxRows
protected java.lang.String cursorName
protected java.util.Hashtable namesToColumns
protected ShareNetStatement stmt
protected boolean wasnull
protected java.sql.SQLWarning warnings
protected com.sas.net.sharenet.ShareNetWarning shareWarning
protected ShareNetDatabaseMetaData dbmd
protected short sv
protected ShareNetConnection connection
Method Detail |
---|
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if a ShareNetException is detected.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if the current row is not valid.public java.lang.String getString(int column) throws java.sql.SQLException
getString
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.public boolean getBoolean(int column) throws java.sql.SQLException
getBoolean
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 boolean value.public byte getByte(int column) throws java.sql.SQLException
getByte
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 byte representation.public short getShort(int column) throws java.sql.SQLException
getShort
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 short value.public int getInt(int column) 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 column) 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 column) 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 column) 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.public java.math.BigDecimal getBigDecimal(int column, 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 column) 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 column) 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 column) 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 column) 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 column) 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 column) throws java.sql.SQLException
getUnicodeStream
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 getBinaryStream(int column) throws java.sql.SQLException
getBinaryStream
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.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.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 becaue 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.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.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface, but it is never thrown.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.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
- This exception may be thrown.public java.lang.Object getObject(int column) 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 name 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 returned by the ResultSetMetaData object.
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
Gets the value of a column in the current row as a java.io.Reader.
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
Gets the value of a column in the current row as a java.io.Reader using a specified character set.
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 is not valid.public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
Gets the value of a column in the current row as a java.io.Reader.
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.io.Reader getCharacterStream(java.lang.String columnName, java.lang.String charsetName) throws java.sql.SQLException
Gets the value of a column in the current row as a java.io.Reader using a specified character set.
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.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The column index. 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.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
getBigDecimal
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 boolean isBeforeFirst() throws java.sql.SQLException
Determines if the cursor is before the first row in the result set. This method is not yet supported.
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean isAfterLast() throws java.sql.SQLException
Determines if the cursor is after the last row in the result set. This method is not yet supported.
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean isFirst() throws java.sql.SQLException
Determines if the cursor is on the first row of the result set. This method is not yet supported.
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean isLast() throws java.sql.SQLException
Determines if the cursor is on the last row of the result set. This method is not yet supported. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
isLast
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void beforeFirst() throws java.sql.SQLException
Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows. This method is not yet supported.
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void afterLast() throws java.sql.SQLException
Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows. This method is not yet supported.
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean first() throws java.sql.SQLException
Moves to the first row in the result set. This method is not yet supported.
first
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean last() throws java.sql.SQLException
Moves to the last row in the result set. This method is not yet supported.
last
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public int getRow() throws java.sql.SQLException
Determines the current row number. The first row is number 1, the second number 2, and so on. This method is not yet supported.
getRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public boolean absolute(int row) throws java.sql.SQLException
Moves to an absolute row number in the result set. This method is not yet supported.
If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
absolute
in interface java.sql.ResultSet
row
- The row number in the result set.
java.sql.SQLException
- This exception is always thrown.public boolean relative(int rows) throws java.sql.SQLException
Moves a relative number of rows, either positive or negative. This method is not yet supported.
Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
relative
in interface java.sql.ResultSet
rows
- Number of rows to skip.
java.sql.SQLException
- This exception is always thrown.public boolean previous() throws java.sql.SQLException
Moves to the previous row in the result set. This method is not yet supported.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
previous
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
direction
- An integer indicating the direction in which the rows in
this result set will be processed. Currently supports only FETCH_FORWARD.
java.sql.SQLException
- This exception is thrown if the fetch direction is not FETCH_FORWARD.public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but it is never thrown.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
- This exception is thrown if a database-access error occurs, or the
condition 0 <= rows <= stmt.getMaxRows() is not satisfied.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.ShareNetDatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.ShareNetDatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.ShareNetDatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is always thrown.public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- the new column value
java.sql.SQLException
- This exception is always thrown.public void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.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 column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.scale
- 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 always thrown.public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- The column index. The first column is 1, the second is 2, and so on.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.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
- This exception is always thrown.public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.length
- The length of the stream.
java.sql.SQLException
- This exception is always thrown.public 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 column.x
- The new column value.scale
- 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 always thrown.public 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 column.x
- The new column value.
java.sql.SQLException
- This exception is always thrown.public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is always thrown.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
- This exception is always thrown.public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is required by the interface but it is never thrown;public java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
i
- The column index. The first column is 1, the second is 2, and so on.map
- The mapping from SQL type names to Java classes.
java.sql.SQLException
- This exception is always thrown.public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
i
- The column index. The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is always thrown.public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
i
- The column index. The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is always thrown.public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
i
- The column index. The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is always thrown.public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
i
- The column index. The first column is 1, the second is 2, and so on.
java.sql.SQLException
- This exception is always thrown.public java.lang.Object getObject(java.lang.String colName, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
colName
- The column name.map
- The mapping from SQL type names to Java classes.
java.sql.SQLException
- This exception is always thrown.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
- This exception is always thrown.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
- This exception is always thrown.public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
colName
- The column name.
This
- exception is always thrown.
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.
This
- exception is always thrown.
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 column index. 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 if the
SQLType 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.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 if the
SQLType cannot be converted to 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 column index. The first column is 1, the second is 2, and so on.cal
- The calendar to use in constructing the time. Ignored if cal is NULL.
java.sql.SQLException
- This exception is thrown if the column value is not valid or if the
SQLType 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.cal
- The calendar to use in constructing the time. Ignored if cal is NULL.
java.sql.SQLException
- This exception is thrown if the column value is not valid or if the
SQLType cannot be converted to 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 column index. The first column is 1, the second is 2, and so on.cal
- The calendar to use in constructing the timestamp. Ignored if cal is NULL.
java.sql.SQLException
- This exception is thrown if the column value is not valid or if the
SQLType 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.cal
- The calendar to use in constructing the timestamp. Ignored if cal is NULL.
java.sql.SQLException
- This exception is thrown if the column value is not valid or if the
SQLType cannot be converted to a valid java.sql.Timestamp value.public void addWarning(java.sql.SQLWarning warning)
SQLWarning
- Warning to add.protected com.sas.net.sharenet.SqlValue[] fetch() throws ShareNetException
ShareNetException
- This exception is thrown if an error condition is detected.protected void send(com.sas.net.sharenet.Wqefcb fcb) throws ShareNetException
fcb
- Function control block that contains the message.
ShareNetException
- This exception is thrown if an error condition is detected.public int numFields()
public java.lang.String[] fieldNames()
public int fieldType(int i)
public java.lang.String fieldFormat(int i)
public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
- This exception is thrown if a ShareNetException is detected.public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
ResultSet
object as a java.net.URL
object in the Java programming language.
This method is not implemented.
getURL
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a java.net.URL
object in the Java programming language.
This method is not implemented.
getURL
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
java.sql.Ref
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.
This method is not implemented.
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
java.sql.Ref
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.
This method is not implemented.
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
java.sql.Blob
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.
This method is not implemented.
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateBlob(java.lang.String columnName, java.sql.Blob x) throws java.sql.SQLException
java.sql.Blob
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.
This method is not implemented.
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
java.sql.Clob
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.
This method is not implemented.
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateClob(java.lang.String columnName, java.sql.Clob x) throws java.sql.SQLException
java.sql.Clob
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.
This method is not implemented.
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
java.sql.Array
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.
This method is not implemented.
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
java.sql.Array
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.
This method is not implemented.
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
- always thrown.protected void finalize() throws java.lang.Throwable
finalize
in class java.lang.Object
java.lang.Throwable
- required. Not created in this method.
|
Components |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |