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
byte s. |
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, wait
getHoldability, 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, updateSQLXML
isWrapperFor, unwrap
public 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 ResultSet
columnLabel
- 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 ResultSet
boolean
, 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 AutoCloseable
close
in interface ResultSet
SQLException
- 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
get
Type 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 ResultSet
boolean
, true
if the last column
value read was SQL NULL
otherwise false
SQLException
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
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 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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
get
Type 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 ResultSet
columnIndex
- 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
get
Type 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 ResultSet
columnIndex
- 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
get
Type 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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
null
SQLException
- 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
get
Type 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 ResultSet
columnLabel
- 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
get
Type 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 ResultSet
columnLabel
- 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
byte
s. 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
get
Type 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 ResultSet
columnLabel
- 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 ResultSet
SQLWarning
object reported or
null
SQLException
- 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 ResultSet
SQLException
- 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 ResultSet
String
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 ResultSet
ResultSetMetaData
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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
AbstractFlatFile.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 ResultSet
AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
- this feature has not
been implemented.public boolean first() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
ResultSet
object.first
in interface ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
int
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 ResultSet
row
- 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 ResultSet
rows
- 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 ResultSet
boolean
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 ResultSet
direction
- an int
that specifies the expected
direction this ResultSet
object is to be processedSQLException
- if the fetch direction is not
FETCH_FORWARD
Statement.setFetchDirection(int)
public int getFetchDirection() throws SQLException
ResultSet
object.getFetchDirection
in interface ResultSet
int
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 ResultSet
rows
- 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 ResultSet
int
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 ResultSet
int
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 ResultSet
int
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 ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
boolean
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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
column
- 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 ResultSet
columnLabel
- 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 ResultSet
column
- 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 ResultSet
columnLabel
- 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 ResultSet
column
- 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 ResultSet
columnLabel
- 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 ResultSet
column
- 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 ResultSet
AbstractFlatFile.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 ResultSet
AbstractFlatFile.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 ResultSet
AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
- this feature has not
been implemented.public void refreshRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException
.refreshRow
in interface ResultSet
AbstractFlatFile.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 ResultSet
AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
- this feature has not
been implemented.public void moveToInsertRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException
.moveToInsertRow
in interface ResultSet
AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
- this feature has not
been implemented.public void moveToCurrentRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
SQLException
.moveToCurrentRow
in interface ResultSet
AbstractFlatFile.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 ResultSet
Statment
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 ResultSet
columnIndex
- 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 ResultSet
T
- 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 ResultSet
T
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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 ResultSet
columnIndex
- 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 ResultSet
columnLabel
- 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.