public class MirthCachedRowSet
extends com.sun.rowset.CachedRowSetImpl
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream
COMMIT_ON_ACCEPT_CHANGES
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 |
---|
MirthCachedRowSet() |
MirthCachedRowSet(Hashtable env) |
Modifier and Type | Method and Description |
---|---|
boolean |
columnUpdated(String columnName)
Indicates whether the designated column in the current row of this
CachedRowSet object has been updated. |
int |
findColumn(String columnName)
Maps the given
ResultSet column label to its
ResultSet column index. |
Array |
getArray(String colName)
Retrieves 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(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of
ASCII characters. |
BigDecimal |
getBigDecimal(String columnName)
Retrieves 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 columnName,
int scale)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.math.BigDecimal in the Java programming language. |
InputStream |
getBinaryStream(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of uninterpreted
byte s. |
Blob |
getBlob(String colName)
Retrieves 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(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a boolean in the Java programming language. |
byte |
getByte(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a byte in the Java programming language. |
byte[] |
getBytes(String columnName)
Retrieves 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(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
Clob |
getClob(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Clob object
in the Java programming language. |
Date |
getDate(String columnName)
Retrieves 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 columnName,
Calendar cal)
Retrieves 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(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a double in the Java programming language. |
float |
getFloat(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a float in the Java programming language. |
int |
getInt(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
an int in the Java programming language. |
long |
getLong(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a long in the Java programming language. |
Object |
getObject(String columnName)
Gets 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 columnName,
Map<String,Class<?>> map)
Retrieves the value of the designated column in the current row
of this
ResultSet object as an Object
in the Java programming language. |
Ref |
getRef(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Ref object
in the Java programming language. |
short |
getShort(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a short in the Java programming language. |
String |
getString(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
Time |
getTime(String columnName)
Retrieves 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 columnName,
Calendar cal)
Retrieves 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(String columnName)
Retrieves 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 columnName,
Calendar cal)
Retrieves 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. |
InputStream |
getUnicodeStream(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of two-byte
Unicode characters. |
URL |
getURL(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.net.URL
object in the Java programming language. |
Collection<?> |
toCollection(String column)
Converts the designated column in this
CachedRowSet object
to a Collection object. |
void |
updateArray(String columnName,
Array a)
Updates the designated column with a
java.sql.Array value. |
void |
updateAsciiStream(String columnName,
InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateBigDecimal(String columnName,
BigDecimal x)
Updates the designated column with a
java.sql.BigDecimal
value. |
void |
updateBinaryStream(String columnName,
InputStream x,
int length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
updateBlob(String columnName,
Blob b)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBoolean(String columnName,
boolean x)
Updates the designated column with a
boolean value. |
void |
updateByte(String columnName,
byte x)
Updates the designated column with a
byte value. |
void |
updateBytes(String columnName,
byte[] x)
Updates the designated column with a byte array value.
|
void |
updateCharacterStream(String columnName,
Reader reader,
int length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
updateClob(String columnName,
Clob c)
Updates the designated column with a
java.sql.Clob value. |
void |
updateDate(String columnName,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
updateDouble(String columnName,
double x)
Updates the designated column with a
double value. |
void |
updateFloat(String columnName,
float x)
Updates the designated column with a
float value. |
void |
updateInt(String columnName,
int x)
Updates the designated column with an
int value. |
void |
updateLong(String columnName,
long x)
Updates the designated column with a
long value. |
void |
updateNull(String columnName)
Updates the designated column with a
null value. |
void |
updateObject(String columnName,
Object x)
Updates the designated column with an
Object value. |
void |
updateObject(String columnName,
Object x,
int scale)
Updates the designated column with an
Object value. |
void |
updateRef(String columnName,
Ref ref)
Updates the designated column with a
java.sql.Ref value. |
void |
updateShort(String columnName,
short x)
Updates the designated column with a
short value. |
void |
updateString(String columnName,
String x)
Updates the designated column with a
String value. |
void |
updateTime(String columnName,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
updateTimestamp(String columnName,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
absolute, acceptChanges, acceptChanges, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, clone, close, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, deleteRow, execute, execute, first, getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getClob, getConnection, getCurrentRow, getCursorName, getDate, getDate, getDouble, getFloat, getHoldability, getInt, getKeyColumns, getLong, getMatchColumnIndexes, getMatchColumnNames, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getOriginal, getOriginalRow, getPageSize, getRef, getRow, getRowId, getRowId, getRowSetWarnings, getShort, getSQLXML, getSQLXML, getStatement, getString, getSyncProvider, getTableName, getTime, getTime, getTimestamp, getTimestamp, getUnicodeStream, getURL, getWarnings, insertRow, internalFirst, internalLast, internalNext, internalPrevious, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, next, nextPage, populate, populate, previous, previousPage, refreshRow, relative, release, removeCurrentRow, restoreOriginal, rollback, rollback, rowDeleted, rowInserted, rowSetPopulated, rowUpdated, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setClob, setCommand, setDate, setDate, setDouble, setFloat, setInt, setKeyColumns, setLong, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, setMetaData, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setObject, setObject, setObject, setOriginal, setOriginalRow, setPageSize, setRowId, setRowId, setRowInserted, setShort, setSQLXML, setSQLXML, setString, setSyncProvider, setTableName, setTime, setTime, setTimestamp, setTimestamp, setURL, size, toCollection, toCollection, undoDelete, undoInsert, undoUpdate, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unwrap, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateByte, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDouble, updateFloat, updateInt, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateObject, updateObject, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateSQLXML, updateSQLXML, updateString, updateTime, updateTimestamp, wasNull
addRowSetListener, clearParameters, getCommand, getConcurrency, getDataSourceName, getEscapeProcessing, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getParams, getPassword, getQueryTimeout, getShowDeleted, getTransactionIsolation, getType, getTypeMap, getUrl, getUsername, initParams, isReadOnly, notifyCursorMoved, notifyRowChanged, notifyRowSetChanged, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFetchDirection, setFetchSize, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setShowDeleted, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUnicodeStream, setUrl, setUsername
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getParams
getShowDeleted, setShowDeleted
addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername
getConcurrency, getFetchDirection, getFetchSize, getType, setFetchDirection, setFetchSize, updateObject, updateObject, updateObject, updateObject
public MirthCachedRowSet() throws SQLException
SQLException
public MirthCachedRowSet(Hashtable env) throws SQLException
SQLException
public Collection<?> toCollection(String column) throws SQLException
javax.sql.rowset.CachedRowSet
CachedRowSet
object
to a Collection
object. Implementations have some latitude in
how they can represent this Collection
object because of the
abstract nature of the Collection
framework.
Each column value should be fully represented in either a
general purpose Collection
implementation or a specialized
Collection
implementation, such as a Vector
object.
An SQL NULL
column value must be represented as a null
in the Java programming language.
The standard reference implementation uses a Vector
object
to contain the column values, and it is expected
that most implementations will do the same. If a Vector
object
is used, it size must be exactly equal to the number of rows
in this CachedRowSet
object.
toCollection
in interface CachedRowSet
toCollection
in class com.sun.rowset.CachedRowSetImpl
column
- a String
object giving the name of the
column whose values are to be represented in a collectionCollection
object that contains the values
stored in the specified column of this CachedRowSet
objectSQLException
- if an error occurs generating the collection or
an invalid column id is providedCachedRowSet.toCollection()
,
CachedRowSet.toCollection(int)
public String getString(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a String
in the Java programming language.getString
in interface ResultSet
getString
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic boolean getBoolean(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a boolean
in the Java programming language.
If the designated column has a datatype of CHAR or VARCHAR
and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 0, a value of false
is returned. If the designated column has a datatype
of CHAR or VARCHAR
and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 1, a value of true
is returned.
getBoolean
in interface ResultSet
getBoolean
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is false
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic byte getByte(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a byte
in the Java programming language.getByte
in interface ResultSet
getByte
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic short getShort(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a short
in the Java programming language.getShort
in interface ResultSet
getShort
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic int getInt(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
an int
in the Java programming language.getInt
in interface ResultSet
getInt
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic long getLong(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a long
in the Java programming language.getLong
in interface ResultSet
getLong
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic float getFloat(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a float
in the Java programming language.getFloat
in interface ResultSet
getFloat
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic double getDouble(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a double
in the Java programming language.getDouble
in interface ResultSet
getDouble
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is 0
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
java.sql.ResultSet
ResultSet
object as
a java.math.BigDecimal
in the Java programming language.getBigDecimal
in interface ResultSet
getBigDecimal
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnscale
- the number of digits to the right of the decimal pointNULL
, the
value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic byte[] getBytes(String columnName) throws SQLException
java.sql.ResultSet
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
getBytes
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic Date getDate(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a java.sql.Date
object in the Java programming language.getDate
in interface ResultSet
getDate
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic Time getTime(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a java.sql.Time
object in the Java programming language.getTime
in interface ResultSet
getTime
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
,
the value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic Timestamp getTimestamp(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as
a java.sql.Timestamp
object in the Java programming language.getTimestamp
in interface ResultSet
getTimestamp
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the
value returned is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic InputStream getAsciiStream(String columnName) throws SQLException
java.sql.ResultSet
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 will
do 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 getter 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
getAsciiStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
,
the value returned is null
.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic InputStream getUnicodeStream(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as a stream of two-byte
Unicode characters. The first byte is the high byte; the second
byte is the low byte.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values.
The JDBC technology-enabled driver will
do any necessary conversion from the database format into Unicode.
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 getter 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
getUnicodeStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the value returned
is null
.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic InputStream getBinaryStream(String columnName) throws SQLException
java.sql.ResultSet
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 getter 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
getBinaryStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the result is null
SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic Object getObject(String columnName) throws SQLException
java.sql.ResultSet
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 will return the value of the given column as a
Java object. The type of the Java object will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification. If the value is an SQL NULL
,
the driver returns a Java null
.
This method may also be used to read database-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
getObject
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnjava.lang.Object
holding the column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic int findColumn(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
column label to its
ResultSet
column index.findColumn
in interface ResultSet
findColumn
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnSQLException
- if the ResultSet
object
does not contain a column labeled columnLabel
, a database access error occurs
or this method is called on a closed result setpublic Reader getCharacterStream(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as a
java.io.Reader
object.getCharacterStream
in interface ResultSet
getCharacterStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnjava.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming languageSQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic BigDecimal getBigDecimal(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as a
java.math.BigDecimal
with full precision.getBigDecimal
in interface ResultSet
getBigDecimal
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnNULL
, the value returned is
null
in the Java programming language.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic boolean columnUpdated(String columnName) throws SQLException
javax.sql.rowset.CachedRowSet
CachedRowSet
object has been updated.columnUpdated
in interface CachedRowSet
columnUpdated
in class com.sun.rowset.CachedRowSetImpl
columnName
- a String
object giving the name of the
column to be checked for updatestrue
if the column has been visibly updated;
false
otherwiseSQLException
- if the cursor is on the insert row, before the first row,
or after the last rowDatabaseMetaData.updatesAreDetected(int)
public void updateNull(String columnName) throws SQLException
java.sql.ResultSet
null
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateNull
in interface ResultSet
updateNull
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBoolean(String columnName, boolean x) throws SQLException
java.sql.ResultSet
boolean
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateBoolean
in interface ResultSet
updateBoolean
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateByte(String columnName, byte x) throws SQLException
java.sql.ResultSet
byte
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateByte
in interface ResultSet
updateByte
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateShort(String columnName, short x) throws SQLException
java.sql.ResultSet
short
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateShort
in interface ResultSet
updateShort
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateInt(String columnName, int x) throws SQLException
java.sql.ResultSet
int
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateInt
in interface ResultSet
updateInt
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateLong(String columnName, long x) throws SQLException
java.sql.ResultSet
long
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateLong
in interface ResultSet
updateLong
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateFloat(String columnName, float x) throws SQLException
java.sql.ResultSet
float
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateFloat
in interface ResultSet
updateFloat
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDouble(String columnName, double x) throws SQLException
java.sql.ResultSet
double
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateDouble
in interface ResultSet
updateDouble
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
java.sql.ResultSet
java.sql.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateBigDecimal
in interface ResultSet
updateBigDecimal
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateString(String columnName, String x) throws SQLException
java.sql.ResultSet
String
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateString
in interface ResultSet
updateString
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBytes(String columnName, byte[] x) throws SQLException
java.sql.ResultSet
updateRow
or insertRow
methods are called to update the database.updateBytes
in interface ResultSet
updateBytes
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDate(String columnName, Date x) throws SQLException
java.sql.ResultSet
java.sql.Date
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateDate
in interface ResultSet
updateDate
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTime(String columnName, Time x) throws SQLException
java.sql.ResultSet
java.sql.Time
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateTime
in interface ResultSet
updateTime
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTimestamp(String columnName, Timestamp x) throws SQLException
java.sql.ResultSet
java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateTimestamp
in interface ResultSet
updateTimestamp
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
java.sql.ResultSet
updateRow
or
insertRow
methods are called to update the database.updateAsciiStream
in interface ResultSet
updateAsciiStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the streamSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
java.sql.ResultSet
updateRow
or
insertRow
methods are called to update the database.updateBinaryStream
in interface ResultSet
updateBinaryStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the streamSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
java.sql.ResultSet
updateRow
or
insertRow
methods are called to update the database.updateCharacterStream
in interface ResultSet
updateCharacterStream
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column valuelength
- the length of the streamSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(String columnName, Object x, int scale) throws SQLException
java.sql.ResultSet
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
If the second argument is an InputStream
then the stream must contain
the number of bytes specified by scaleOrLength. If the second argument is a
Reader
then the reader must contain the number of characters specified
by scaleOrLength. If these conditions are not true the driver will generate a
SQLException
when the statement is executed.
updateObject
in interface ResultSet
updateObject
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuescale
- for an object of java.math.BigDecimal
,
this is the number of digits after the decimal point. For
Java Object types InputStream
and Reader
,
this is the length
of the data in the stream or reader. For all other types,
this value will be ignored.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(String columnName, Object x) throws SQLException
java.sql.ResultSet
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateObject
in interface ResultSet
updateObject
in class com.sun.rowset.CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Object getObject(String columnName, Map<String,Class<?>> map) throws SQLException
java.sql.ResultSet
ResultSet
object as an Object
in the Java programming language.
If the value is an SQL NULL
,
the driver returns a Java null
.
This method uses the specified Map
object for
custom mapping if appropriate.getObject
in interface ResultSet
getObject
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnmap
- 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 columnSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Ref getRef(String colName) throws SQLException
java.sql.ResultSet
ResultSet
object as a Ref
object
in the Java programming language.getRef
in interface ResultSet
getRef
in class com.sun.rowset.CachedRowSetImpl
colName
- 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 columnRef
object representing the SQL REF
value in the specified columnSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Blob getBlob(String colName) throws SQLException
java.sql.ResultSet
ResultSet
object as a Blob
object
in the Java programming language.getBlob
in interface ResultSet
getBlob
in class com.sun.rowset.CachedRowSetImpl
colName
- 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 columnBlob
object representing the SQL BLOB
value in the specified columnSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Clob getClob(String colName) throws SQLException
java.sql.ResultSet
ResultSet
object as a Clob
object
in the Java programming language.getClob
in interface ResultSet
getClob
in class com.sun.rowset.CachedRowSetImpl
colName
- 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 columnClob
object representing the SQL CLOB
value in the specified columnSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Array getArray(String colName) throws SQLException
java.sql.ResultSet
ResultSet
object as an Array
object
in the Java programming language.getArray
in interface ResultSet
getArray
in class com.sun.rowset.CachedRowSetImpl
colName
- 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 columnArray
object representing the SQL ARRAY
value in
the specified columnSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic Date getDate(String columnName, Calendar cal) throws SQLException
java.sql.ResultSet
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
getDate
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columncal
- 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 languageSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setpublic Time getTime(String columnName, Calendar cal) throws SQLException
java.sql.ResultSet
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
getTime
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columncal
- 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 languageSQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setpublic Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
java.sql.ResultSet
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
getTimestamp
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columncal
- the java.util.Calendar
object
to use in constructing the datejava.sql.Timestamp
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming languageSQLException
- if the columnLabel is not valid or
if a database access error occurs
or this method is called on a closed result setpublic void updateRef(String columnName, Ref ref) throws SQLException
java.sql.ResultSet
java.sql.Ref
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateRef
in interface ResultSet
updateRef
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnref
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(String columnName, Clob c) throws SQLException
java.sql.ResultSet
java.sql.Clob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateClob
in interface ResultSet
updateClob
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnc
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(String columnName, Blob b) throws SQLException
java.sql.ResultSet
java.sql.Blob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateBlob
in interface ResultSet
updateBlob
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnb
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateArray(String columnName, Array a) throws SQLException
java.sql.ResultSet
java.sql.Array
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateArray
in interface ResultSet
updateArray
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columna
- the new column valueSQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic URL getURL(String columnName) throws SQLException
java.sql.ResultSet
ResultSet
object as a java.net.URL
object in the Java programming language.getURL
in interface ResultSet
getURL
in class com.sun.rowset.CachedRowSetImpl
columnName
- 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 columnjava.net.URL
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming languageSQLException
- if the columnLabel is not valid;
if a database access error occurs; this method
is called on a closed result set or if a URL is malformedSQLFeatureNotSupportedException
- if the JDBC driver does not support
this method