public abstract class AbstractFlatFile extends Object implements ResultSet
ResultSet.
In Java, the result of a database query is normally returned as a
ResultSet object. This class is intended to support reading of
text or binary flat files and returning them as a ResultSet.
A flat file is a rectangular data set where each row is an observation and each column is a variable. The data type in any one column is the same for all of the rows.
| Modifier and Type | Class and Description |
|---|---|
protected static class |
AbstractFlatFile.FlatFileSQLException
A
SQLException thrown by the AbstractFlatFile class. |
protected static class |
AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
A
SQLFeatureNotSupportedException thrown by the AbstractFlatFile class. |
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| Constructor and Description |
|---|
AbstractFlatFile()
Initializes an
AbstractFlatFile. |
| Modifier and Type | Method and Description |
|---|---|
boolean |
absolute(int row)
Moves the cursor to the given row number in this
ResultSet
object. |
void |
afterLast()
Moves the cursor to the end of this
ResultSet object, just
after the last row. |
void |
beforeFirst()
Moves the cursor to the front of this
ResultSet object, just
before the first row. |
protected void |
beginGet()
This method should be called at the start of every
get
Type method. |
void |
cancelRowUpdates()
Cancels the updates made to the current row in this
ResultSet object. |
void |
clearWarnings()
Clears all warnings reported on this
ResultSet object. |
void |
close()
Releases this
ResultSet object's database and JDBC resources
immediately instead of waiting for this to happen when it is
automatically closed. |
void |
deleteRow()
Deletes the current row from this
ResultSet object and from
the underlying database. |
protected abstract byte[] |
doGetBytes(int columnIndex)
Implements the actual
getBytes(). |
protected abstract boolean |
doNext()
Implements the operations on the file required by the method next().
|
int |
findColumn(String columnLabel)
Maps the given
ResultSet column name to its
ResultSet column index. |
protected String |
findColumnName(int columnIndex)
Maps the given columnIndex into its column name.
|
boolean |
first()
Moves the cursor to the first row in this
ResultSet object. |
Array |
getArray(int columnIndex)
Deprecated.
|
Array |
getArray(String columnLabel)
Returns the value of the designated column in the current row of this
ResultSet object as an Array object in the Java
programming language. |
InputStream |
getAsciiStream(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a stream of ASCII characters. |
InputStream |
getAsciiStream(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a stream of ASCII characters. |
BigDecimal |
getBigDecimal(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a java.math.BigDecimal with
full precision. |
BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a java.math.BigDecimal with
full precision. |
BigDecimal |
getBigDecimal(String columnLabel,
int scale)
Deprecated.
|
InputStream |
getBinaryStream(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a binary stream of uninterpreted bytes. |
InputStream |
getBinaryStream(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a stream of uninterpreted
bytes. |
Blob |
getBlob(int columnIndex)
Returns the value of the designated column in the current row of this
ResultSet object as a Blob object in the Java
programming language. |
Blob |
getBlob(String columnLabel)
Returns the value of the designated column in the current row of this
ResultSet object as a Blob object in the Java
programming language. |
boolean |
getBoolean(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a boolean in the Java
programming language. |
boolean |
getBoolean(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a boolean in the Java
programming language. |
byte |
getByte(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a byte in the Java
programming language. |
byte |
getByte(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a byte in the Java
programming language. |
byte[] |
getBytes(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a byte array in the Java
programming language. |
byte[] |
getBytes(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a byte array in the Java
programming language. |
Reader |
getCharacterStream(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a java.io.Reader object. |
Reader |
getCharacterStream(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a java.io.Reader object. |
Clob |
getClob(int columnIndex)
Returns the value of the designated column in the current row of this
ResultSet object as a Clob object in the Java
programming language. |
Clob |
getClob(String columnLabel)
Returns the value of the designated column in the current row of this
ResultSet object as a Clob object in the Java
programming language. |
Class |
getColumnClass(int columnIndex)
Returns the class of the items in the specified column.
|
abstract int |
getColumnCount()
Returns the number of columns in this
ResultSet object. |
int |
getConcurrency()
Returns the concurrency mode of this
ResultSet object. |
String |
getCursorName()
Gets the name of the SQL cursor used by this
ResultSet
object. |
Date |
getDate(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Date object in
the Java programming language. |
Date |
getDate(int columnIndex,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Date object in
the Java programming language. |
Date |
getDate(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Date object in
the Java programming language. |
Date |
getDate(String columnLabel,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Date object in
the Java programming language. |
double |
getDouble(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a double in the Java
programming language. |
double |
getDouble(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a double in the Java
programming language. |
int |
getFetchDirection()
Returns the fetch direction for this
ResultSet object. |
int |
getFetchSize()
Returns the fetch size for this
ResultSet object. |
float |
getFloat(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a float in the Java
programming language. |
float |
getFloat(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a float in the Java
programming language. |
int |
getInt(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as an int in the Java
programming language. |
int |
getInt(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as an int in the Java
programming language. |
long |
getLong(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a long in the Java
programming language. |
long |
getLong(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a long in the Java
programming language. |
ResultSetMetaData |
getMetaData()
Retrieves the number, types and properties of this
ResultSet
object's columns. |
abstract Object |
getObject(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language. |
<T> T |
getObject(int columnIndex,
Class<T> type)
Returns the value of the designated column in the current row of this
ResultSet object converted to the requested data type in the
Java programming language. |
Object |
getObject(int columnIndex,
Map map)
Returns the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language. |
Object |
getObject(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language. |
<T> T |
getObject(String columnLabel,
Class<T> type)
Returns the value of the designated column in the current row of this
ResultSet object converted to the requested data type in the
Java programming language. |
Object |
getObject(String columnLabel,
Map map)
Returns the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language. |
Ref |
getRef(int columnIndex)
Returns the value of the designated column in the current row of this
ResultSet object as a Ref object in the Java
programming language. |
Ref |
getRef(String columnLabel)
Returns the value of the designated column in the current row of this
ResultSet object as a Ref object in the Java
programming language. |
int |
getRow()
Retrieves the current row number.
|
short |
getShort(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a short in the Java
programming language. |
short |
getShort(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a short in the Java
programming language. |
Statement |
getStatement()
Returns the
Statement object that produced this
ResultSet object. |
String |
getString(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a String in the Java
programming language. |
String |
getString(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a String in the Java
programming language. |
Time |
getTime(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Time object in
the Java programming language. |
Time |
getTime(int columnIndex,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Time object in
the Java programming language. |
Time |
getTime(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Time object in
the Java programming language. |
Time |
getTime(String columnLabel,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Time object in
the Java programming language. |
Timestamp |
getTimestamp(int columnIndex)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
getTimestamp(int columnIndex,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
getTimestamp(String columnLabel)
Gets the value of the designated column in the current row of this
ResultSet object as a java.sql.Timestamp
object. |
Timestamp |
getTimestamp(String columnLabel,
Calendar cal)
Returns the value of the designated column in the current row of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
int |
getType()
Returns the type of this
ResultSet object. |
InputStream |
getUnicodeStream(int columnIndex)
Deprecated.
Use
AbstractFlatFile.getCharacterStream(int) instead. |
InputStream |
getUnicodeStream(String columnLabel)
Deprecated.
Use
AbstractFlatFile.getCharacterStream(String) instead. |
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. |
URL |
getURL(String columnLabel)
Retrieves the value of the designated column in the current row of this
ResultSet object as a java.net.URL object. |
SQLWarning |
getWarnings()
Returns the first warning reported by calls on this
ResultSet object. |
void |
insertRow()
Inserts the contents of the insert row into this
ResultSet
object and into the database. |
boolean |
isAfterLast()
Indicates whether the cursor is after the last row in this
ResultSet object. |
boolean |
isBeforeFirst()
Indicates whether the cursor is before the first row in this
ResultSet object. |
boolean |
isFirst()
Indicates whether the cursor is on the first row of this
ResultSet object. |
boolean |
isLast()
Indicates whether the cursor is on the last row of this
ResultSet object. |
boolean |
last()
Moves the cursor to the last row in this
ResultSet object. |
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()
Moves the cursor down one row from its current position.
|
boolean |
previous()
Moves the cursor to the previous row in this
ResultSet
object. |
void |
refreshRow()
Refreshes the current row with its most recent value in the database.
|
boolean |
relative(int rows)
Moves the cursor a relative number of rows, either positive or negative.
|
boolean |
rowDeleted()
Indicates whether a row has been deleted.
|
boolean |
rowInserted()
Indicates whether the current row has had an insertion.
|
boolean |
rowUpdated()
Indicates whether the current row has been updated.
|
protected void |
setColumnClass(int columnIndex,
Class columnClass)
Sets a column class.
|
protected void |
setColumnName(int columnIndex,
String columnName)
Sets a column name.
|
void |
setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in this
ResultSet object is processed. |
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
ResultSet object. |
protected void |
setWarning(SQLWarning warning)
Sets a
SQLWarning. |
void |
updateArray(int column,
Array x)
Updates the designated column with an
Array value. |
void |
updateArray(String columnLabel,
Array x)
Updates the designated column with an
Array value. |
void |
updateAsciiStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with an ASCII stream value.
|
void |
updateAsciiStream(String columnLabel,
InputStream x,
int length)
Updates the designated column with an ASCII stream value.
|
void |
updateBigDecimal(int columnIndex,
BigDecimal x)
Updates the designated column with a
java.math.BigDecimal
value. |
void |
updateBigDecimal(String columnLabel,
BigDecimal x)
Updates the designated column with a
java.sql.BigDecimal
value. |
void |
updateBinaryStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(String columnLabel,
InputStream x,
int length)
Updates the designated column with a binary stream value.
|
void |
updateBlob(int column,
Blob x)
Updates the designated column with an
java.sql.Blob value. |
void |
updateBlob(String columnLabel,
Blob x)
Updates the designated column with an
java.sql.Blob value. |
void |
updateBoolean(int columnIndex,
boolean x)
Updates the designated column with a
boolean value. |
void |
updateBoolean(String columnLabel,
boolean x)
Updates the designated column with a
boolean value. |
void |
updateByte(int columnIndex,
byte x)
Updates the designated column with a
byte value. |
void |
updateByte(String columnLabel,
byte x)
Updates the designated column with a
byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
Updates the designated column with a
byte array value. |
void |
updateBytes(String columnLabel,
byte[] x)
Updates the designated column with a
byte value. |
void |
updateCharacterStream(int columnIndex,
Reader x,
int length)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(String columnLabel,
Reader reader,
int length)
Updates the designated column with a character stream value.
|
void |
updateClob(int column,
Clob x)
Updates the designated column with an
java.sql.Clob value. |
void |
updateClob(String columnLabel,
Clob x)
Updates the designated column with an
java.sql.Clob value. |
void |
updateDate(int columnIndex,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
updateDate(String columnLabel,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
updateDouble(int columnIndex,
double x)
Updates the designated column with a
double value. |
void |
updateDouble(String columnLabel,
double x)
Updates the designated column with a
double value. |
void |
updateFloat(int columnIndex,
float x)
Updates the designated column with a
float value. |
void |
updateFloat(String columnLabel,
float x)
Updates the designated column with a
float value. |
void |
updateInt(int columnIndex,
int x)
Updates the designated column with an
int value. |
void |
updateInt(String columnLabel,
int x)
Updates the designated column with an
int value. |
void |
updateLong(int columnIndex,
long x)
Updates the designated column with a
long value. |
void |
updateLong(String columnLabel,
long x)
Updates the designated column with a
long value. |
void |
updateNull(int columnIndex)
Gives a nullable column a
null value. |
void |
updateNull(String columnLabel)
Updates the designated column with a
null value. |
void |
updateObject(int columnIndex,
Object x)
Updates the designated column with an
Object value. |
void |
updateObject(int columnIndex,
Object x,
int scale)
Updates the designated column with an
Object value. |
void |
updateObject(String columnLabel,
Object x)
Updates the designated column with an
Object value. |
void |
updateObject(String columnLabel,
Object x,
int scale)
Updates the designated column with an
Object value. |
void |
updateRef(int column,
Ref x)
Updates the designated column with an
java.sql.Ref value. |
void |
updateRef(String columnLabel,
Ref x)
Updates the designated column with an
java.sql.Ref value. |
void |
updateRow()
Updates the underlying database with the new contents of the current row
of this
ResultSet object. |
void |
updateShort(int columnIndex,
short x)
Updates the designated column with a
short value. |
void |
updateShort(String columnLabel,
short x)
Updates the designated column with a
short value. |
void |
updateString(int columnIndex,
String x)
Updates the designated column with a
String value. |
void |
updateString(String columnLabel,
String x)
Updates the designated column with a
String value. |
void |
updateTime(int columnIndex,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
updateTime(String columnLabel,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
updateTimestamp(int columnIndex,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
void |
updateTimestamp(String columnLabel,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
boolean |
wasNull()
Reports whether the last column read had a value of SQL
NULL. |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXMLisWrapperFor, unwrappublic AbstractFlatFile()
AbstractFlatFile.
Since AbstractFlatFile is abstract, it cannot be directly
instantiated.protected void setColumnName(int columnIndex,
String columnName)
findColumn
and findColumnName.columnIndex - an int specifying the column index of the
column to be namedcolumnName - a String specifying the name of the columnAbstractFlatFile.findColumn(String),
AbstractFlatFile.findColumnName(int)protected void setColumnClass(int columnIndex,
Class columnClass)
columnIndex - an int specifying the index of a columncolumnClass - a Class object used to specify the class
of the data in the columnpublic int findColumn(String columnLabel) throws SQLException
ResultSet column name to its
ResultSet column index.findColumn in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.int specifying the column index of the given
column nameSQLException - if the ResultSet object does not
contain columnLabel or a database access error occursprotected String findColumnName(int columnIndex) throws SQLException
columnIndex - an int specifying the index of a column
for which the name is to be foundString containing the name of the columnSQLException - if a database access error occursprotected void beginGet()
get
Type method. It closes any InputStreams or
Readers created by get methods in this object. It also
resets the wasNull flag to false.public boolean next()
throws SQLException
ResultSet cursor is initially positioned before the first
row, the first call to the method next makes the first row
the current row, the second call makes the second row the current row,
and so on.
If an input stream is open for the current row, a call to the method
next will implicitly close it. A ResultSet
object's warning chain is cleared when a new row is read.
next in interface ResultSetboolean, true if the new current row
is valid, false if there are no more rowsSQLException - if a database access error occurs or this method
is called on a closed result setprotected abstract boolean doNext()
throws SQLException
boolean, true if the new current row
is valid, false if there are no more rowsSQLException - if a database access error occurspublic abstract int getColumnCount()
throws SQLException
ResultSet object.int that specifies the number of columnsSQLException - if a database access error occurspublic void close()
throws SQLException
ResultSet object's database and JDBC resources
immediately instead of waiting for this to happen when it is
automatically closed.close in interface AutoCloseableclose in interface ResultSetSQLException - if a database access error occurspublic Class getColumnClass(int columnIndex) throws SQLException
Class set using
getColumnClass. If no class type is set the default
implementation returns Object.class.columnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.Class object used to specify the class of the data
in the columnSQLException - if a database access error occursAbstractFlatFile.setColumnClass(int,Class)public boolean wasNull()
throws SQLException
NULL. Note that you must first call one of the
getType methods on a column to try to read its value
and then call the method wasNull to see if the value read
was SQL NULL.wasNull in interface ResultSetboolean, true if the last column
value read was SQL NULL otherwise falseSQLException - if a database access error occurspublic String getString(int columnIndex) throws SQLException
ResultSet object as a String in the Java
programming language.getString in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.String representation of the column value. If the
value is SQL NULL, the value returned is null.SQLException - if a database access error occurspublic boolean getBoolean(int columnIndex)
throws SQLException
ResultSet object as a boolean in the Java
programming language.getBoolean in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.boolean representation of the column value. If the
value is SQL NULL, the value returned is false.SQLException - if a conversion or database access error occurspublic byte getByte(int columnIndex)
throws SQLException
ResultSet object as a byte in the Java
programming language.getByte in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.byte representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic short getShort(int columnIndex)
throws SQLException
ResultSet object as a short in the Java
programming language.getShort in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.short representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic int getInt(int columnIndex)
throws SQLException
ResultSet object as an int in the Java
programming language.getInt in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.int representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic long getLong(int columnIndex)
throws SQLException
ResultSet object as a long in the Java
programming language.getLong in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.long representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic float getFloat(int columnIndex)
throws SQLException
ResultSet object as a float in the Java
programming language.getFloat in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.float representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic double getDouble(int columnIndex)
throws SQLException
ResultSet object as a double in the Java
programming language.getDouble in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.double representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a conversion or database access error occurspublic BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
ResultSet object as a java.sql.BigDecimal in
the Java programming language.getBigDecimal in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.scale - an int that specifies the number of digits to
the right of the decimal pointjava.sql.BigDecimal representation of the column
value. If the value is SQL NULL, the value returned is
null.SQLException - if a database access error occurspublic byte[] getBytes(int columnIndex)
throws SQLException
ResultSet object as a byte array in the Java
programming language. The bytes represent the raw values returned by the
driver.getBytes in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.byte array representation of the column value. If
the value is SQL NULL, the value returned is
null.SQLException - if a database access error occursprotected abstract byte[] doGetBytes(int columnIndex)
throws SQLException
getBytes(). The bytes represent the
raw values returned by the driver.columnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.byte array representation of the column value. If
the value is SQL null, the value returned is
null.SQLException - if a database access error occurspublic Date getDate(int columnIndex) throws SQLException
ResultSet object as a java.sql.Date object in
the Java programming language.getDate in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.sql.Date representation of the column value.
If the value is SQL NULL, the value returned is
null.SQLException - if a conversion or database access error occurspublic Time getTime(int columnIndex) throws SQLException
ResultSet object as a java.sql.Time object in
the Java programming language.getTime in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.sql.Time representation of the column value.
If the value is SQL NULL, the value returned is
null.SQLException - if a conversion or database access error occurspublic Timestamp getTimestamp(int columnIndex) throws SQLException
ResultSet object as a java.sql.Timestamp object
in the Java programming language.getTimestamp in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.sql.Timestamp representation of the column
value. If the value is SQL NULL, the value returned is
null.SQLException - if a conversion or database access error occurspublic InputStream getAsciiStream(int columnIndex) throws SQLException
ResultSet object as a stream of ASCII characters. The value
can then be read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR values. The JDBC
driver does any necessary conversion from the database format into ASCII.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method
InputStream.available is called whether there is data
available or not.
getAsciiStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.io.InputStream that delivers the database
column value as a stream of one-byte ASCII characters. If the value is
SQL NULL, the value returned is null.SQLException - if a database access error occurspublic InputStream getUnicodeStream(int columnIndex) throws SQLException
AbstractFlatFile.getCharacterStream(int) instead.ResultSet object as as a stream of Unicode characters. The
value can then be read in chunks from the stream. This method is
particularly suitable for retrieving large LONGVARCHAR
values. The JDBC driver does any necessary conversion from the database
format into Unicode. The byte format of the Unicode stream must be Java
UTF-8, as specified in the Java virtual machine specification.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method
InputStream.available is called whether there is data
available or not.
getUnicodeStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.io.InputStream that delivers the database
column value as a stream in Java UTF-8 byte format. If the value is SQL
NULL, the value returned is null.SQLException - if a database access error occurspublic InputStream getBinaryStream(int columnIndex) throws SQLException
ResultSet object as a binary stream of uninterpreted bytes.
The value can then be read in chunks from the stream. This method is
particularly suitable for retrieving large LONGVARBINARY
values.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method
InputStream.available is called whether there is data
available or not.
getBinaryStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.io.InputStream that delivers the database
column value as a stream of uninterpreted bytes. If the value is SQL
NULL, the value returned is null.SQLException - if a database access error occurspublic String getString(String columnLabel) throws SQLException
ResultSet object as a String in the Java
programming language.getString in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.String representation of the column value. If the
value is SQL NULL, the value returned is null.SQLException - if a database access error occurspublic boolean getBoolean(String columnLabel) throws SQLException
ResultSet object as a boolean in the Java
programming language.getBoolean in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.boolean representation of the column value. If the
value is SQL NULL, the value returned is false.SQLException - if a database access error occurspublic byte getByte(String columnLabel) throws SQLException
ResultSet object as a byte in the Java
programming language.getByte in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.byte representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic short getShort(String columnLabel) throws SQLException
ResultSet object as a short in the Java
programming language.getShort in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.short representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic int getInt(String columnLabel) throws SQLException
ResultSet object as an int in the Java
programming language.getInt in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.int representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic long getLong(String columnLabel) throws SQLException
ResultSet object as a long in the Java
programming language.getLong in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.long representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic float getFloat(String columnLabel) throws SQLException
ResultSet object as a float in the Java
programming language.getFloat in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.float representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic double getDouble(String columnLabel) throws SQLException
ResultSet object as a double in the Java
programming language.getDouble in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.double representation of the column value. If the
value is SQL NULL, the value returned is 0.SQLException - if a database access error occurspublic BigDecimal getBigDecimal(String columnLabel, int scale) throws SQLException
ResultSet object as a java.math.BigDecimal in
the Java programming language.getBigDecimal in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.scale - an int that specifies the number of digits to
the right of the decimal pointjava.math.BigDecimal representation of the column
value. If the value is SQL NULL, the value returned is
null.SQLException - if a database access error occurspublic byte[] getBytes(String columnLabel) throws SQLException
ResultSet object as a byte array in the Java
programming language. The bytes represent the raw values returned by the
driver.getBytes in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.byte array representation of the column value. If
the value is SQL NULL, the value returned is
null.SQLException - if a database access error occurspublic Date getDate(String columnLabel) throws SQLException
ResultSet object as a java.sql.Date object in
the Java programming language.getDate in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.sql.Date representation of the column value.
If the value is SQL NULL, the value returned is
null.SQLException - if a database access error occurspublic Time getTime(String columnLabel) throws SQLException
ResultSet object as a java.sql.Time object in
the Java programming language.getTime in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.sql.Time representation of the column value.
If the value is SQL NULL, the value returned is
null.SQLException - if a database access error occurspublic Timestamp getTimestamp(String columnLabel) throws SQLException
ResultSet object as a java.sql.Timestamp
object.getTimestamp in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.sql.Timestamp representation of the column
value, if the value is SQL NULL, the value returned is
nullSQLException - if a database access error occurspublic InputStream getAsciiStream(String columnLabel) throws SQLException
ResultSet object as a stream of ASCII characters. The value
can then be read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR values. The JDBC
driver does any necessary conversion from the database format into ASCII.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method available
is called whether there is data available or not.
getAsciiStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.io.InputStream that delivers the database
column value as a stream of one-byte ASCII characters. If the value is
SQL NULL, the value returned is null.SQLException - if a database access error occurspublic InputStream getUnicodeStream(String columnLabel) throws SQLException
AbstractFlatFile.getCharacterStream(String) instead.ResultSet object as a stream of Unicode characters. The
value can then be read in chunks from the stream. This method is
particularly suitable for retrieving large LONGVARCHAR
values. The JDBC driver does any necessary conversion from the database
format into Unicode. The byte format of the Unicode stream must be Java
UTF-8, as defined in the Java virtual machine specification.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method available
is called whether there is data available or not.
getUnicodeStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.io.InputStream that delivers the database
column value as a stream of two-byte Unicode characters. If the value is
SQL NULL, the value returned is null.SQLException - if a database access error occurspublic InputStream getBinaryStream(String columnLabel) throws SQLException
ResultSet object as a stream of uninterpreted
bytes. The value can then be read in chunks from the stream.
This method is particularly suitable for retrieving large
LONGVARBINARY values.
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
getType method implicitly closes the stream. Also, a
stream may return 0 when the method available
is called whether there is data available or not.
getBinaryStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.io.InputStream that delivers the database
column value as a stream of uninterpreted bytes. If the value is SQL
NULL, the result is null.SQLException - if a database access error occurspublic SQLWarning getWarnings() throws SQLException
ResultSet object. Subsequent warnings on this
ResultSet object are chained to the SQLWarning
object that this method returns.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by
ResultSet methods. Any warning caused by
Statement methods (such as reading OUT parameters) are
chained on the Statement object.
getWarnings in interface ResultSetSQLWarning object reported or
nullSQLException - if a database access error occurspublic void clearWarnings()
throws SQLException
ResultSet object. After
this method is called, the method getWarnings returns
null until a new warning is reported for this
ResultSet object.clearWarnings in interface ResultSetSQLException - if a database access error occursprotected void setWarning(SQLWarning warning)
SQLWarning.warning - a SQLWarning that is to be added to this
object.public String getCursorName() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet
object. The default implementation throws a SQLException.getCursorName in interface ResultSetString that specifies the SQL name for this
ResultSet object's cursorAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implementedpublic ResultSetMetaData getMetaData() throws SQLException
ResultSet
object's columns.getMetaData in interface ResultSetResultSetMetaData which provides a description of
this ResultSet object's columnsSQLException - if a database access error occurspublic abstract Object getObject(int columnIndex) throws SQLException
Gets the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language.
This method returns the value of the given column as a Java object. The type of the Java object is the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
getObject in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.lang.Object representation of the column
valueSQLException - if a database access error occurspublic Object getObject(String columnLabel) throws SQLException
Gets the value of the designated column in the current row of this
ResultSet object as an Object in the Java
programming language.
This method returns the value of the given column as a Java object. The type of the Java object is the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
This method may also be used to read datatabase-specific abstract data
types. In the JDBC 2.0 API, the behavior of the method
getObject is extended to materialize data of SQL
user-defined types. When a column contains a structured or distinct
value, the behavior of this method is as if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap()).
getObject in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.lang.Object representation of the column
valueSQLException - if a database access error occurspublic Reader getCharacterStream(int columnIndex) throws SQLException
ResultSet object as a java.io.Reader object.getCharacterStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.io.Reader object that contains the column
value. If the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic Reader getCharacterStream(String columnLabel) throws SQLException
ResultSet object as a java.io.Reader object.getCharacterStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.io.Reader object that contains the column
value. If the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic BigDecimal getBigDecimal(int columnIndex) throws SQLException
ResultSet object as a java.math.BigDecimal with
full precision.getBigDecimal in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.math.BigDecimal object that contains the
column value. If the value is SQL NULL, the value returned
is null in the Java programming language.SQLException - if a conversion or database access error occurspublic BigDecimal getBigDecimal(String columnLabel) throws SQLException
ResultSet object as a java.math.BigDecimal with
full precision.getBigDecimal in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.math.BigDecimal object that contains the
column value. If the value is SQL NULL, the value returned
is null in the Java programming language.SQLException - if a database access error occurspublic URL getURL(String columnLabel) throws SQLException
ResultSet object as a java.net.URL object.getURL in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.java.net.URL object that contains the column
value. If the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic URL getURL(int columnIndex) throws SQLException
ResultSet object as a java.net.URL object.getURL in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.java.net.URL object that contains the column
value. If the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a conversion or database access error occurspublic boolean isBeforeFirst()
throws SQLException
ResultSet object.isBeforeFirst in interface ResultSetboolean whose value is true if the
cursor is before the first row, false if the cursor is at
any other position or the ResultSet contains no rowsSQLException - if a database access error occurspublic boolean isAfterLast()
throws SQLException
ResultSet object.isAfterLast in interface ResultSetboolean whose value is true if the
cursor is after the last row, false if the cursor is at any
other position or the ResultSet contains no rowsSQLException - if a database access error occurspublic boolean isFirst()
throws SQLException
ResultSet object.isFirst in interface ResultSetboolean whose value is true if the
cursor is on the first row, false otherwiseSQLException - if a database access error occurspublic boolean isLast()
throws SQLException
ResultSet object. Note: Calling the method
isLast may be expensive because 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 ResultSetboolean whose value is true if the
cursor is on the last row, false otherwiseSQLException - if a database access error occurspublic void beforeFirst()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object, just
before the first row. This method has no effect if the result set
contains no rows.beforeFirst in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void afterLast()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object, just
after the last row. This method has no effect if the result set contains
no rows.afterLast in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public boolean first()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object.first in interface ResultSetboolean whose value is true if the
cursor is on the result set, false otherwiseAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public boolean last()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object.last in interface ResultSetboolean whose value is true if the
cursor is on the result set, false otherwiseAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public int getRow()
throws SQLException
getRow in interface ResultSetint that specifies the current row number;
0 if there is no current rowSQLException - if a database access error occurspublic boolean absolute(int row)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet
object.absolute in interface ResultSetrow - an int that specifies a row, of the
ResultSet object, where the cursor is to be movedboolean whose value is true if the
cursor is on the result set, false otherwiseAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public boolean relative(int rows)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
relative in interface ResultSetrows - an int that specifies the number of rows in the
ResultSet object to advance or regressboolean whose value is true if the
cursor is on the result set, false otherwiseAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public boolean previous()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet
object.previous in interface ResultSetboolean whose value is true if the
cursor is on the result set, false otherwiseAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void setFetchDirection(int direction)
throws SQLException
ResultSet object is processed.setFetchDirection in interface ResultSetdirection - an int that specifies the expected
direction this ResultSet object is to be processedSQLException - if the fetch direction is not
FETCH_FORWARDStatement.setFetchDirection(int)public int getFetchDirection()
throws SQLException
ResultSet object.getFetchDirection in interface ResultSetint that specifies the current fetch direction
for this ResultSet object. Always returns
FETCH_FORWARD.SQLException - if a database access error occurspublic void setFetchSize(int rows)
throws SQLException
ResultSet object. If the fetch size specified is zero, the
JDBC driver ignores the value and is free to make its own best guess as
to what the fetch size should be. The default value is set by the
Statement object that created the result set. The fetch size
may be changed at any time.setFetchSize in interface ResultSetrows - an int that specifies the number of rows to
fetchSQLException - if a database access error occurs or the
condition 0 <= rows <= this.getMaxRows() is not satisfiedpublic int getFetchSize()
throws SQLException
ResultSet object.getFetchSize in interface ResultSetint that specifies the current fetch size for
this ResultSet objectSQLException - if a database access error occurspublic int getType()
throws SQLException
ResultSet object. The type is
determined by the Statement object that created the result
set.getType in interface ResultSetint that specifies the type of this
ResultSet object. Always returns
TYPE_FORWARD_ONLY.SQLException - if a database access error occurspublic int getConcurrency()
throws SQLException
ResultSet object.getConcurrency in interface ResultSetint that specifies whether concurrency is read
only or an update processes as well. Always returns
CONCUR_READ_ONLY.SQLException - if a database access error occurspublic boolean rowUpdated()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
false.rowUpdated in interface ResultSetboolean which indicates whether a row has been
updated. Always returns false since updates are not allowed.AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public boolean rowInserted()
throws SQLException
false.rowInserted in interface ResultSetboolean which indicates whether the current row
had an insertion. Always returns false since updates are not
allowed.SQLException - if a database access error occurspublic boolean rowDeleted()
throws SQLException
false.rowDeleted in interface ResultSetboolean which indicates whether a row has been
deleted. Always returns false since updates are not allowed.SQLException - if a database access error occurspublic void updateNull(int columnIndex)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
null value. Since updates are not
allowed, this method always throws a SQLException.updateNull in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBoolean(int columnIndex,
boolean x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
boolean value. Since
updates are not allowed, this method always throws a
SQLException.updateBoolean in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a boolean that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateByte(int columnIndex,
byte x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
byte value. Since
updates are not allowed, this method always throws a
SQLException.updateByte in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a byte that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateShort(int columnIndex,
short x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
short value. Since
updates are not allowed, this method always throws a
SQLException.updateShort in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a short that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateInt(int columnIndex,
int x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
int value. Since
updates are not allowed, this method always throws a
SQLException.updateInt in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - an int that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateLong(int columnIndex,
long x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
long value. Since
updates are not allowed, this method always throws a
SQLException.updateLong in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a long that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateFloat(int columnIndex,
float x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
float value. Since
updates are not allowed, this method always throws a
SQLException.updateFloat in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a float that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateDouble(int columnIndex,
double x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
double value. Since
updates are not allowed, this method always throws a
SQLException.updateDouble in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a double that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBigDecimal(int columnIndex,
BigDecimal x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.math.BigDecimal
value. Since updates are not allowed, this method always throws a
SQLException.updateBigDecimal in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a java.math.BigDecimal that specifies the new
column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateString(int columnIndex,
String x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
String value. Since
updates are not allowed, this method always throws a
SQLException.updateString in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a String that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBytes(int columnIndex,
byte[] x)
throws SQLException
byte array value. Since
updates are not allowed, this method always throws a
SQLException.updateBytes in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a byte array that specifies the new column valueSQLException - is always thrown since updates are not allowedpublic void updateDate(int columnIndex,
Date x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Date value.
Since updates are not allowed, this method always throws a
SQLException.updateDate in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a java.sql.Date that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateTime(int columnIndex,
Time x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Time value.
Since updates are not allowed, this method always throws a
SQLException.updateTime in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a java.sql.Time that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateTimestamp(int columnIndex,
Timestamp x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Timestamp
value. Since updates are not allowed, this method always throws a
SQLException.updateTimestamp in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a java.sql.Timestamp that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateAsciiStream(int columnIndex,
InputStream x,
int length)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateAsciiStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - an InputStream that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBinaryStream(int columnIndex,
InputStream x,
int length)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateBinaryStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - an InputStream that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateCharacterStream(int columnIndex,
Reader x,
int length)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateCharacterStream in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - a Reader that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateObject(int columnIndex,
Object x,
int scale)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Object value. Since
updates are not allowed, this method always throws a
SQLException.updateObject in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - an Object that specifies the new column valuescale - for java.sql.Types.DECIMAL or
java.sql.Types.NUMERIC types, this is the number of digits
after the decimal point. For all other types this value is ignored.AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateObject(int columnIndex,
Object x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Object value. Since
updates are not allowed, this method always throws a
SQLException.updateObject in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.x - an Object that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateNull(String columnLabel) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
null value. Since
updates are not allowed, this method always throws a
SQLException.updateNull in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBoolean(String columnLabel, boolean x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
boolean value. Since
updates are not allowed, this method always throws a
SQLException.updateBoolean in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a boolean that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateByte(String columnLabel, byte x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
byte value. Since
updates are not allowed, this method always throws a
SQLException.updateByte in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a byte that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateShort(String columnLabel, short x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
short value. Since
updates are not allowed, this method always throws a
SQLException.updateShort in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a short that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateInt(String columnLabel, int x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
int value. Since
updates are not allowed, this method always throws a
SQLException.updateInt in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - an int that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateLong(String columnLabel, long x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
long value. Since
updates are not allowed, this method always throws a
SQLException.updateLong in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a long that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateFloat(String columnLabel, float x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
float value. Since
updates are not allowed, this method always throws a
SQLException.updateFloat in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a float that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateDouble(String columnLabel, double x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
double value. Since
updates are not allowed, this method always throws a
SQLException.updateDouble in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a double that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBigDecimal(String columnLabel, BigDecimal x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.BigDecimal
value. Since updates are not allowed, this method always throws a
SQLException.updateBigDecimal in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.BigDecimal that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateString(String columnLabel, String x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
String value. Since
updates are not allowed, this method always throws a
SQLException.updateString in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a String that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBytes(String columnLabel, byte[] x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
byte value. Since
updates are not allowed, this method always throws a
SQLException.updateBytes in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a byte array that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateDate(String columnLabel, Date x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Date value.
Since updates are not allowed, this method always throws a
SQLException.updateDate in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Date that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateTime(String columnLabel, Time x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Time value.
Since updates are not allowed, this method always throws a
SQLException.updateTime in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Time that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateTimestamp(String columnLabel, Timestamp x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Timestamp
value. Since updates are not allowed, this method always throws a
SQLException.updateTimestamp in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Timestamp that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateAsciiStream(String columnLabel, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateAsciiStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - an InputStream that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBinaryStream(String columnLabel, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateBinaryStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - an InputStream that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateCharacterStream(String columnLabel, Reader reader, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.updateCharacterStream in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.reader - a Reader that specifies the new column valuelength - an int that specifies the stream lengthAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateObject(String columnLabel, Object x, int scale) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Object value. Since
updates are not allowed, this method always throws a
SQLException.updateObject in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - an Object that specifies the new column valuescale - for java.sql.Types.DECIMAL or
java.sql.Types.NUMERIC types, this is the number of digits
after the decimal point. For all other types this value is ignored.AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateObject(String columnLabel, Object x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Object value. Since
updates are not allowed, this method always throws a
SQLException.updateObject in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Object that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateArray(String columnLabel, Array x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Array value. Since
updates are not allowed, this method always throws a
SQLException.updateArray in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Array that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateArray(int column,
Array x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
Array value. Since
updates are not allowed, this method always throws a
SQLException.updateArray in interface ResultSetcolumn - an int that specifies the column. The first
column is 1, the second is 2, and so on.x - a java.sql.Array that specifies the new column
valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateClob(String columnLabel, Clob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Clob value.
Since updates are not allowed, this method always throws a
SQLException.updateClob in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Clob that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBlob(int column,
Blob x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Blob value.
Since updates are not allowed, this method always throws a
SQLException.updateBlob in interface ResultSetcolumn - an int that specifies the column. The first
column is 1, the second is 2, and so on.x - a java.sql.Blob that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateBlob(String columnLabel, Blob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Blob value.
Since updates are not allowed, this method always throws a
SQLException.updateBlob in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Blob that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateClob(int column,
Clob x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Clob value.
Since updates are not allowed, this method always throws a
SQLException.updateClob in interface ResultSetcolumn - an int that specifies the column. The first
column is 1, the second is 2, and so on.x - a java.sql.Clob that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateRef(String columnLabel, Ref x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Ref value.
Since updates are not allowed, this method always throws a
SQLException.updateRef in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.x - a java.sql.Ref that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateRef(int column,
Ref x)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
java.sql.Ref value.
Since updates are not allowed, this method always throws a
SQLException.updateRef in interface ResultSetcolumn - an int that specifies the column. The first
column is 1, the second is 2, and so on.x - a java.sql.Ref that specifies the new column valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void insertRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet
object and into the database. Since updates are not allowed, this method
always throws a SQLException.insertRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void updateRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object. Since updates are not allowed,
this method always throws a SQLException.updateRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void deleteRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object and from
the underlying database. Since updates are not allowed, this method
always throws a SQLException.deleteRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void refreshRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.refreshRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void cancelRowUpdates()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object. Since updates are not allowed, this method
always throws a SQLException.cancelRowUpdates in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void moveToInsertRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.moveToInsertRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public void moveToCurrentRow()
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException.moveToCurrentRow in interface ResultSetAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Statement getStatement() throws SQLException
Statement object that produced this
ResultSet object. Since there is no
java.sqlStatement, this method always throws a
SQLException.getStatement in interface ResultSetStatment object that produced this
ResultSet object or null if the result set was
produced some other waySQLException - is always thrown since updates are not allowedpublic Object getObject(int columnIndex, Map map) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object as an Object in the Java
programming language. This method uses the given Map object
for the custom mapping of the SQL structured or distinct type that is
being retrieved.getObject in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.map - a java.util.Map object that contains the mapping
from SQL type names to classes in the Java programming languageObject in the Java programming language
representing the SQL valueAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public <T> T getObject(String columnLabel, Class<T> type) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object converted to the requested data type in the
Java programming language.getObject in interface ResultSetT - the argument type that to be unwrappedcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.type - a Java data type to convert toObject representing the SQL value in the
specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public <T> T getObject(int columnIndex,
Class<T> type)
throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object converted to the requested data type in the
Java programming language.getObject in interface ResultSetT - the argument type that to be unwrappedcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.type - a Java data type to convert toObject representing the SQL value in the
specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Ref getRef(int columnIndex) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object as a Ref object in the Java
programming language.getRef in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.Ref object representing the SQL REF
value in the specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Blob getBlob(int columnIndex) throws SQLException
ResultSet object as a Blob object in the Java
programming language.
NOTE: java.sql.Blob.free() has not been implemented (they
are empty methods) in the instance returned.
java.sql.Blob.getBinaryStream(long, long) returns
null and java.sql.Blob.setBinaryStream(long)
throws a SQLException.
getBlob in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.Blob object representing the SQL BLOB
value in the specified columnSQLException - if a database access error occurspublic Clob getClob(int columnIndex) throws SQLException
ResultSet object as a Clob object in the Java
programming language.
NOTE: java.sql.Clob.free() has not been implemented (they
are empty methods) in the instance returned.
java.sql.Clob.getCharacterStream(long, long) returns
null. java.sql.Clob.position(Clob, long),
java.sql.Clob.setAsciiStream(long),
java.sql.Clob.setCharacterStream(long),
java.sql.Clob.setString(long, String), and
java.sql.Clob.setString(long, String, int, int) throw a
SQLException.
getClob in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.Clob object representing an SQL Clob
value in the specified columnSQLException - if a database access error occurspublic Array getArray(int columnIndex) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object as an Array object in the Java
programming language.getArray in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.Array object representing an SQL
Array value in the specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Object getObject(String columnLabel, Map map) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object as an Object in the Java
programming language. This method uses the specified Map
object for custom mapping if appropriate.getObject in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.map - a java.util.Map object that contains the mapping
from SQL type names to classes in the Java programming languageObject representing the SQL value in the
specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Ref getRef(String columnLabel) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet object as a Ref object in the Java
programming language.getRef in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.Ref object representing the SQL REF
value in the specified columnAbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not
been implemented.public Blob getBlob(String columnLabel) throws SQLException
ResultSet object as a Blob object in the Java
programming language.getBlob in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.Blob object representing the SQL BLOB
value in the specified columnSQLException - if a database access error occurspublic Clob getClob(String columnLabel) throws SQLException
ResultSet object as a Clob object in the Java
programming language.getClob in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.Clob object representing the SQL CLOB
value in the specified columnSQLException - if a database access error occurspublic Array getArray(String columnLabel) throws SQLException
ResultSet object as an Array object in the Java
programming language.getArray in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.Array object representing the SQL
ARRAY value in the specified columnSQLException - if a database access error occurspublic Date getDate(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Date object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the date if the underlying
database does not store timezone information.getDate in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.cal - the java.util.Calendar object to use in
constructing the datejava.sql.Date object. If the
value is SQL NULL, the value returned is null
in the Java programming language.SQLException - if a database access error occurspublic Date getDate(String columnLabel, Calendar cal) throws SQLException
ResultSet object as a java.sql.Date object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the date if the underlying
database does not store timezone information.getDate in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.cal - the java.util.Calendar object to use in
constructing the datejava.sql.Date object. If the
value is SQL NULL, the value returned is null
in the Java programming language.SQLException - if a database access error occurspublic Time getTime(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Time object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the time if the underlying
database does not store timezone information.getTime in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.cal - the java.util.Calendar object to use in
constructing the timejava.sql.Time object. If the
value is SQL NULL, the value returned is null
in the Java programming language.SQLException - if a database access error occurspublic Time getTime(String columnLabel, Calendar cal) throws SQLException
ResultSet object as a java.sql.Time object in
the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the time if the underlying
database does not store timezone information.getTime in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.cal - the java.util.Calendar object to use in
constructing the timejava.sql.Time object. If the
value is SQL NULL, the value returned is null
in the Java programming language.SQLException - if a database access error occurspublic Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Timestamp object
in the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the timestamp if the
underlying database does not store timezone information.getTimestamp in interface ResultSetcolumnIndex - an int that specifies the column. The
first column is 1, the second is 2, and so on.cal - the java.util.Calendar object to use in
constructing the timestampjava.sql.Timestamp object. If
the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic Timestamp getTimestamp(String columnLabel, Calendar cal) throws SQLException
ResultSet object as a java.sql.Timestamp object
in the Java programming language. This method uses the given calendar to
construct an appropriate millisecond value for the timestamp if the
underlying database does not store timezone information.getTimestamp in interface ResultSetcolumnLabel - a String that indicates the label for the
column specified with the SQL AS clause. If the SQL
AS clause was not specified, then the label is the name of
the column.cal - the java.util.Calendar object to use in
constructing the timestampjava.sql.Timestamp object. If
the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occursCopyright © 2020 Rogue Wave Software. All rights reserved.