Class JdbcResultSet
- java.lang.Object
-
- org.h2.message.TraceObject
-
- org.h2.jdbc.JdbcResultSet
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.ResultSet
,java.sql.Wrapper
public final class JdbcResultSet extends TraceObject implements java.sql.ResultSet
Represents a result set.Column labels are case-insensitive, quotes are not supported. The first column has the column index 1.
Thread safety: the result set is not thread-safe and must not be used by multiple threads concurrently.
Updatable result sets: Result sets are updatable when the result only contains columns from one table, and if it contains all columns of a unique index (primary key or other) of this table. Key columns may not contain NULL (because multiple rows with NULL could exist). In updatable result sets, own changes are visible, but not own inserts and deletes.
-
-
Field Summary
Fields Modifier and Type Field Description private int
columnCount
private java.util.HashMap<java.lang.String,java.lang.Integer>
columnLabelMap
private CommandInterface
command
private JdbcConnection
conn
private Value[]
insertRow
private java.util.HashMap<java.lang.Long,Value[]>
patchedRows
private JdbcPreparedStatement
preparedStatement
(package private) ResultInterface
result
private boolean
scrollable
private JdbcStatement
stat
private boolean
triggerUpdatable
private boolean
updatable
private Value[]
updateRow
private boolean
wasNull
-
Fields inherited from class org.h2.message.TraceObject
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQLXML, STATEMENT, trace, XA_DATA_SOURCE, XID
-
-
Constructor Summary
Constructors Constructor Description JdbcResultSet(JdbcConnection conn, JdbcPreparedStatement preparedStatement, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, java.util.HashMap<java.lang.String,java.lang.Integer> columnLabelMap)
JdbcResultSet(JdbcConnection conn, JdbcStatement stat, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, boolean triggerUpdatable)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description boolean
absolute(int rowNumber)
Moves the current position to a specific row.void
afterLast()
Moves the current position to after the last row, that means after the end.void
beforeFirst()
Moves the current position to before the first row, that means resets the result set.void
cancelRowUpdates()
Cancels updating a row.(package private) void
checkClosed()
Check if this result set is closed.private int
checkColumnIndex(int columnIndex)
private void
checkOnValidRow()
private void
checkUpdatable()
void
clearWarnings()
Clears all warnings.void
close()
Closes the result set.(package private) void
closeInternal(boolean fromStatement)
Close the result set.private Value
convertToUnknownValue(java.lang.Object x)
private Value
convertToValue(java.lang.Object x, java.sql.SQLType targetSqlType)
void
deleteRow()
Deletes the current row.int
findColumn(java.lang.String columnLabel)
Searches for a specific column in the result set.boolean
first()
Moves the current position to the first row.private Value
get(int columnIndex)
java.sql.Array
getArray(int columnIndex)
Returns the value of the specified column as an Array.private java.sql.Array
getArray(int id, int columnIndex)
java.sql.Array
getArray(java.lang.String columnLabel)
Returns the value of the specified column as an Array.java.io.InputStream
getAsciiStream(int columnIndex)
Returns the value of the specified column as an input stream.java.io.InputStream
getAsciiStream(java.lang.String columnLabel)
Returns the value of the specified column as an input stream.java.math.BigDecimal
getBigDecimal(int columnIndex)
Returns the value of the specified column as a BigDecimal.java.math.BigDecimal
getBigDecimal(int columnIndex, int scale)
Deprecated.java.math.BigDecimal
getBigDecimal(java.lang.String columnLabel)
Returns the value of the specified column as a BigDecimal.java.math.BigDecimal
getBigDecimal(java.lang.String columnLabel, int scale)
Deprecated.java.io.InputStream
getBinaryStream(int columnIndex)
Returns the value of the specified column as an input stream.java.io.InputStream
getBinaryStream(java.lang.String columnLabel)
Returns the value of the specified column as an input stream.java.sql.Blob
getBlob(int columnIndex)
Returns the value of the specified column as a Blob.private JdbcBlob
getBlob(int id, int columnIndex)
java.sql.Blob
getBlob(java.lang.String columnLabel)
Returns the value of the specified column as a Blob.boolean
getBoolean(int columnIndex)
Returns the value of the specified column as a boolean.boolean
getBoolean(java.lang.String columnLabel)
Returns the value of the specified column as a boolean.private boolean
getBooleanInternal(int columnIndex)
byte
getByte(int columnIndex)
Returns the value of the specified column as a byte.byte
getByte(java.lang.String columnLabel)
Returns the value of the specified column as a byte.private byte
getByteInternal(int columnIndex)
byte[]
getBytes(int columnIndex)
Returns the value of the specified column as a byte array.byte[]
getBytes(java.lang.String columnLabel)
Returns the value of the specified column as a byte array.java.io.Reader
getCharacterStream(int columnIndex)
Returns the value of the specified column as a reader.java.io.Reader
getCharacterStream(java.lang.String columnLabel)
Returns the value of the specified column as a reader.java.sql.Clob
getClob(int columnIndex)
Returns the value of the specified column as a Clob.private JdbcClob
getClob(int id, int columnIndex)
java.sql.Clob
getClob(java.lang.String columnLabel)
Returns the value of the specified column as a Clob.private int
getColumnIndex(java.lang.String columnLabel)
int
getConcurrency()
Gets the result set concurrency.java.lang.String
getCursorName()
[Not supported] Gets the cursor name if it was defined.java.sql.Date
getDate(int columnIndex)
Returns the value of the specified column as a java.sql.Date.java.sql.Date
getDate(int columnIndex, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a specified time zone.java.sql.Date
getDate(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Date.java.sql.Date
getDate(java.lang.String columnLabel, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a specified time zone.double
getDouble(int columnIndex)
Returns the value of the specified column as a double.double
getDouble(java.lang.String columnLabel)
Returns the value of the specified column as a double.private double
getDoubleInternal(int columnIndex)
int
getFetchDirection()
Gets the fetch direction.int
getFetchSize()
Gets the number of rows suggested to read in one step.float
getFloat(int columnIndex)
Returns the value of the specified column as a float.float
getFloat(java.lang.String columnLabel)
Returns the value of the specified column as a float.private float
getFloatInternal(int columnIndex)
int
getHoldability()
Returns the current result set holdability.int
getInt(int columnIndex)
Returns the value of the specified column as an int.int
getInt(java.lang.String columnLabel)
Returns the value of the specified column as an int.Value
getInternal(int columnIndex)
INTERNALprivate int
getIntInternal(int columnIndex)
long
getLong(int columnIndex)
Returns the value of the specified column as a long.long
getLong(java.lang.String columnLabel)
Returns the value of the specified column as a long.private long
getLongInternal(int columnIndex)
java.sql.ResultSetMetaData
getMetaData()
Gets the meta data of this result set.java.io.Reader
getNCharacterStream(int columnIndex)
Returns the value of the specified column as a reader.java.io.Reader
getNCharacterStream(java.lang.String columnLabel)
Returns the value of the specified column as a reader.java.sql.NClob
getNClob(int columnIndex)
Returns the value of the specified column as a Clob.java.sql.NClob
getNClob(java.lang.String columnLabel)
Returns the value of the specified column as a Clob.java.lang.String
getNString(int columnIndex)
Returns the value of the specified column as a String.java.lang.String
getNString(java.lang.String columnLabel)
Returns the value of the specified column as a String.java.lang.Object
getObject(int columnIndex)
Returns a column value as a Java object.<T> T
getObject(int columnIndex, java.lang.Class<T> type)
Returns a column value as a Java object of the specified type.java.lang.Object
getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type mapping.java.lang.Object
getObject(java.lang.String columnLabel)
Returns a column value as a Java object.<T> T
getObject(java.lang.String columnName, java.lang.Class<T> type)
Returns a column value as a Java object of the specified type.java.lang.Object
getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type mapping.java.sql.Ref
getRef(int columnIndex)
[Not supported] Gets a column as a reference.java.sql.Ref
getRef(java.lang.String columnLabel)
[Not supported] Gets a column as a reference.ResultInterface
getResult()
INTERNALint
getRow()
Gets the current row number.java.sql.RowId
getRowId(int columnIndex)
[Not supported] Returns the value of the specified column as a row id.java.sql.RowId
getRowId(java.lang.String columnLabel)
[Not supported] Returns the value of the specified column as a row id.short
getShort(int columnIndex)
Returns the value of the specified column as a short.short
getShort(java.lang.String columnLabel)
Returns the value of the specified column as a short.private short
getShortInternal(int columnIndex)
java.sql.SQLXML
getSQLXML(int columnIndex)
Returns the value of the specified column as a SQLXML.java.sql.SQLXML
getSQLXML(java.lang.String columnLabel)
Returns the value of the specified column as a SQLXML.java.sql.Statement
getStatement()
Returns the statement that created this object.java.lang.String
getString(int columnIndex)
Returns the value of the specified column as a String.java.lang.String
getString(java.lang.String columnLabel)
Returns the value of the specified column as a String.java.sql.Time
getTime(int columnIndex)
Returns the value of the specified column as a java.sql.Time.java.sql.Time
getTime(int columnIndex, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a specified time zone.java.sql.Time
getTime(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Time.java.sql.Time
getTime(java.lang.String columnLabel, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a specified time zone.java.sql.Timestamp
getTimestamp(int columnIndex)
Returns the value of the specified column as a java.sql.Timestamp.java.sql.Timestamp
getTimestamp(int columnIndex, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.java.sql.Timestamp
getTimestamp(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Timestamp.java.sql.Timestamp
getTimestamp(java.lang.String columnLabel, java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp.int
getType()
Get the result set type.java.io.InputStream
getUnicodeStream(int columnIndex)
Deprecated.since JDBC 2.0, use getCharacterStreamjava.io.InputStream
getUnicodeStream(java.lang.String columnLabel)
Deprecated.since JDBC 2.0, use setCharacterStreamprivate UpdatableRow
getUpdatableRow()
Value[]
getUpdateRow()
INTERNALjava.net.URL
getURL(int columnIndex)
[Not supported]java.net.URL
getURL(java.lang.String columnLabel)
[Not supported]java.sql.SQLWarning
getWarnings()
Gets the first warning reported by calls on this object.void
insertRow()
Inserts the current row.boolean
isAfterLast()
Checks if the current position is after the last row, that means next() was called and returned false, and there was at least one row.boolean
isBeforeFirst()
Checks if the current position is before the first row, that means next() was not called yet, and there is at least one row.boolean
isClosed()
Returns whether this result set is closed.boolean
isFirst()
Checks if the current position is row 1, that means next() was called once and returned true.boolean
isLast()
Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.private boolean
isOnValidRow()
boolean
isWrapperFor(java.lang.Class<?> iface)
Checks if unwrap can return an object of this class.boolean
last()
Moves the current position to the last row.void
moveToCurrentRow()
Moves the current position to the current row.void
moveToInsertRow()
Moves the current position to the insert row.boolean
next()
Moves the cursor to the next row of the result set.private boolean
nextLazyRow()
private boolean
nextRow()
private void
patchCurrentRow(Value[] row)
boolean
previous()
Moves the cursor to the last row, or row before first row if the current position is the first row.void
refreshRow()
Re-reads the current row from the database.boolean
relative(int rowCount)
Moves the current position to a specific row relative to the current row.private void
resetResult()
boolean
rowDeleted()
Detects if the row was deleted (by somebody else or the caller).boolean
rowInserted()
Detects if the row was inserted.boolean
rowUpdated()
Detects if the row was updated (by somebody else or the caller).void
setFetchDirection(int direction)
[Not supported] Sets (changes) the fetch direction for this result set.void
setFetchSize(int rows)
Sets the number of rows suggested to read in one step.java.lang.String
toString()
INTERNAL<T> T
unwrap(java.lang.Class<T> iface)
Return an object of this class if possible.private void
update(int columnIndex, Value v)
void
updateArray(int columnIndex, java.sql.Array x)
Updates a column in the current or insert row.void
updateArray(java.lang.String columnLabel, java.sql.Array x)
Updates a column in the current or insert row.private void
updateArrayImpl(int columnIndex, java.sql.Array x)
private void
updateAscii(int columnIndex, java.io.InputStream x, long length)
void
updateAsciiStream(int columnIndex, java.io.InputStream x)
Updates a column in the current or insert row.void
updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
Updates a column in the current or insert row.void
updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
Updates a column in the current or insert row.void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length)
Updates a column in the current or insert row.void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateBigDecimal(int columnIndex, java.math.BigDecimal x)
Updates a column in the current or insert row.void
updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x)
Updates a column in the current or insert row.void
updateBinaryStream(int columnIndex, java.io.InputStream x)
Updates a column in the current or insert row.void
updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
Updates a column in the current or insert row.void
updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
Updates a column in the current or insert row.void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length)
Updates a column in the current or insert row.void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateBlob(int columnIndex, java.io.InputStream x)
Updates a column in the current or insert row.void
updateBlob(int columnIndex, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateBlob(int columnIndex, java.sql.Blob x)
Updates a column in the current or insert row.void
updateBlob(java.lang.String columnLabel, java.io.InputStream x)
Updates a column in the current or insert row.void
updateBlob(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates a column in the current or insert row.void
updateBlob(java.lang.String columnLabel, java.sql.Blob x)
Updates a column in the current or insert row.private void
updateBlobImpl(int columnIndex, java.io.InputStream x, long length)
private void
updateBlobImpl(int columnIndex, java.sql.Blob x, long length)
void
updateBoolean(int columnIndex, boolean x)
Updates a column in the current or insert row.void
updateBoolean(java.lang.String columnLabel, boolean x)
Updates a column in the current or insert row.void
updateByte(int columnIndex, byte x)
Updates a column in the current or insert row.void
updateByte(java.lang.String columnLabel, byte x)
Updates a column in the current or insert row.void
updateBytes(int columnIndex, byte[] x)
Updates a column in the current or insert row.void
updateBytes(java.lang.String columnLabel, byte[] x)
Updates a column in the current or insert row.void
updateCharacterStream(int columnIndex, java.io.Reader x)
Updates a column in the current or insert row.void
updateCharacterStream(int columnIndex, java.io.Reader x, int length)
Updates a column in the current or insert row.void
updateCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader x)
Updates a column in the current or insert row.void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, int length)
Updates a column in the current or insert row.void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateClob(int columnIndex, java.io.Reader x)
Updates a column in the current or insert row.void
updateClob(int columnIndex, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateClob(int columnIndex, java.sql.Clob x)
Updates a column in the current or insert row.void
updateClob(java.lang.String columnLabel, java.io.Reader x)
Updates a column in the current or insert row.void
updateClob(java.lang.String columnLabel, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateClob(java.lang.String columnLabel, java.sql.Clob x)
Updates a column in the current or insert row.private void
updateClobImpl(int columnIndex, java.io.Reader x, long length)
private void
updateClobImpl(int columnIndex, java.sql.Clob x)
void
updateDate(int columnIndex, java.sql.Date x)
Updates a column in the current or insert row.void
updateDate(java.lang.String columnLabel, java.sql.Date x)
Updates a column in the current or insert row.void
updateDouble(int columnIndex, double x)
Updates a column in the current or insert row.void
updateDouble(java.lang.String columnLabel, double x)
Updates a column in the current or insert row.void
updateFloat(int columnIndex, float x)
Updates a column in the current or insert row.void
updateFloat(java.lang.String columnLabel, float x)
Updates a column in the current or insert row.void
updateInt(int columnIndex, int x)
Updates a column in the current or insert row.void
updateInt(java.lang.String columnLabel, int x)
Updates a column in the current or insert row.void
updateLong(int columnIndex, long x)
Updates a column in the current or insert row.void
updateLong(java.lang.String columnLabel, long x)
Updates a column in the current or insert row.void
updateNCharacterStream(int columnIndex, java.io.Reader x)
Updates a column in the current or insert row.void
updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x)
Updates a column in the current or insert row.void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateNClob(int columnIndex, java.io.Reader x)
Updates a column in the current or insert row.void
updateNClob(int columnIndex, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateNClob(int columnIndex, java.sql.NClob x)
Updates a column in the current or insert row.void
updateNClob(java.lang.String columnLabel, java.io.Reader x)
Updates a column in the current or insert row.void
updateNClob(java.lang.String columnLabel, java.io.Reader x, long length)
Updates a column in the current or insert row.void
updateNClob(java.lang.String columnLabel, java.sql.NClob x)
Updates a column in the current or insert row.void
updateNString(int columnIndex, java.lang.String x)
Updates a column in the current or insert row.void
updateNString(java.lang.String columnLabel, java.lang.String x)
Updates a column in the current or insert row.void
updateNull(int columnIndex)
Updates a column in the current or insert row.void
updateNull(java.lang.String columnLabel)
Updates a column in the current or insert row.void
updateObject(int columnIndex, java.lang.Object x)
Updates a column in the current or insert row.void
updateObject(int columnIndex, java.lang.Object x, int scale)
Updates a column in the current or insert row.void
updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType)
Updates a column in the current or insert row.void
updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
Updates a column in the current or insert row.void
updateObject(java.lang.String columnLabel, java.lang.Object x)
Updates a column in the current or insert row.void
updateObject(java.lang.String columnLabel, java.lang.Object x, int scale)
Updates a column in the current or insert row.void
updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType)
Updates a column in the current or insert row.void
updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
Updates a column in the current or insert row.void
updateRef(int columnIndex, java.sql.Ref x)
[Not supported]void
updateRef(java.lang.String columnLabel, java.sql.Ref x)
[Not supported]void
updateRow()
Updates the current row.void
updateRowId(int columnIndex, java.sql.RowId x)
[Not supported] Updates a column in the current or insert row.void
updateRowId(java.lang.String columnLabel, java.sql.RowId x)
[Not supported] Updates a column in the current or insert row.void
updateShort(int columnIndex, short x)
Updates a column in the current or insert row.void
updateShort(java.lang.String columnLabel, short x)
Updates a column in the current or insert row.void
updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
Updates a column in the current or insert row.void
updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)
Updates a column in the current or insert row.private void
updateSQLXMLImpl(int columnIndex, java.sql.SQLXML xmlObject)
void
updateString(int columnIndex, java.lang.String x)
Updates a column in the current or insert row.void
updateString(java.lang.String columnLabel, java.lang.String x)
Updates a column in the current or insert row.void
updateTime(int columnIndex, java.sql.Time x)
Updates a column in the current or insert row.void
updateTime(java.lang.String columnLabel, java.sql.Time x)
Updates a column in the current or insert row.void
updateTimestamp(int columnIndex, java.sql.Timestamp x)
Updates a column in the current or insert row.void
updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x)
Updates a column in the current or insert row.boolean
wasNull()
Returns whether the last column accessed was null.-
Methods inherited from class org.h2.message.TraceObject
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported
-
-
-
-
Field Detail
-
scrollable
private final boolean scrollable
-
updatable
private final boolean updatable
-
triggerUpdatable
private final boolean triggerUpdatable
-
result
ResultInterface result
-
conn
private JdbcConnection conn
-
stat
private JdbcStatement stat
-
columnCount
private int columnCount
-
wasNull
private boolean wasNull
-
insertRow
private Value[] insertRow
-
updateRow
private Value[] updateRow
-
columnLabelMap
private java.util.HashMap<java.lang.String,java.lang.Integer> columnLabelMap
-
patchedRows
private java.util.HashMap<java.lang.Long,Value[]> patchedRows
-
preparedStatement
private JdbcPreparedStatement preparedStatement
-
command
private final CommandInterface command
-
-
Constructor Detail
-
JdbcResultSet
public JdbcResultSet(JdbcConnection conn, JdbcStatement stat, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, boolean triggerUpdatable)
-
JdbcResultSet
JdbcResultSet(JdbcConnection conn, JdbcPreparedStatement preparedStatement, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, java.util.HashMap<java.lang.String,java.lang.Integer> columnLabelMap)
-
-
Method Detail
-
next
public boolean next() throws java.sql.SQLException
Moves the cursor to the next row of the result set.- Specified by:
next
in interfacejava.sql.ResultSet
- Returns:
- true if successful, false if there are no more rows
- Throws:
java.sql.SQLException
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
Gets the meta data of this result set.- Specified by:
getMetaData
in interfacejava.sql.ResultSet
- Returns:
- the meta data
- Throws:
java.sql.SQLException
-
wasNull
public boolean wasNull() throws java.sql.SQLException
Returns whether the last column accessed was null.- Specified by:
wasNull
in interfacejava.sql.ResultSet
- Returns:
- true if the last column accessed was null
- Throws:
java.sql.SQLException
-
findColumn
public int findColumn(java.lang.String columnLabel) throws java.sql.SQLException
Searches for a specific column in the result set. A case-insensitive search is made.- Specified by:
findColumn
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the column index (1,2,...)
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
close
public void close() throws java.sql.SQLException
Closes the result set.- Specified by:
close
in interfacejava.lang.AutoCloseable
- Specified by:
close
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
closeInternal
void closeInternal(boolean fromStatement)
Close the result set. This method also closes the statement if required.- Parameters:
fromStatement
- if true - close statement in the end
-
getStatement
public java.sql.Statement getStatement() throws java.sql.SQLException
Returns the statement that created this object.- Specified by:
getStatement
in interfacejava.sql.ResultSet
- Returns:
- the statement or prepared statement, or null if created by a DatabaseMetaData call.
- Throws:
java.sql.SQLException
-
getWarnings
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
Gets the first warning reported by calls on this object.- Specified by:
getWarnings
in interfacejava.sql.ResultSet
- Returns:
- null
- Throws:
java.sql.SQLException
-
clearWarnings
public void clearWarnings() throws java.sql.SQLException
Clears all warnings.- Specified by:
clearWarnings
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a String.- Specified by:
getString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getString
public java.lang.String getString(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a String.- Specified by:
getString
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getInt
public int getInt(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as an int.- Specified by:
getInt
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getInt
public int getInt(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as an int.- Specified by:
getInt
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getIntInternal
private int getIntInternal(int columnIndex)
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a BigDecimal.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getDate
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Date.Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getTime
public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Time.Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Timestamp.Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a BigDecimal.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getDate
public java.sql.Date getDate(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Date.Usage of this method is discouraged. Use
getObject(columnLabel, LocalDate.class)
instead.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getTime
public java.sql.Time getTime(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Time.Usage of this method is discouraged. Use
getObject(columnLabel, LocalTime.class)
instead.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Timestamp.Usage of this method is discouraged. Use
getObject(columnLabel, LocalDateTime.class)
instead.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getObject
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side).- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value or null
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getObject
public java.lang.Object getObject(java.lang.String columnLabel) throws java.sql.SQLException
Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side).- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value or null
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBoolean
public boolean getBoolean(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a boolean.- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBoolean
public boolean getBoolean(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a boolean.- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBooleanInternal
private boolean getBooleanInternal(int columnIndex)
-
getByte
public byte getByte(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a byte.- Specified by:
getByte
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getByte
public byte getByte(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a byte.- Specified by:
getByte
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getByteInternal
private byte getByteInternal(int columnIndex)
-
getShort
public short getShort(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a short.- Specified by:
getShort
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getShort
public short getShort(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a short.- Specified by:
getShort
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getShortInternal
private short getShortInternal(int columnIndex)
-
getLong
public long getLong(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a long.- Specified by:
getLong
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getLong
public long getLong(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a long.- Specified by:
getLong
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getLongInternal
private long getLongInternal(int columnIndex)
-
getFloat
public float getFloat(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a float.- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getFloat
public float getFloat(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a float.- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getFloatInternal
private float getFloatInternal(int columnIndex)
-
getDouble
public double getDouble(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a double.- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getDouble
public double getDouble(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a double.- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getDoubleInternal
private double getDoubleInternal(int columnIndex)
-
getBigDecimal
@Deprecated public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel, int scale) throws java.sql.SQLException
Deprecated.Returns the value of the specified column as a BigDecimal.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelscale
- the scale of the returned value- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBigDecimal
@Deprecated public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
Deprecated.Returns the value of the specified column as a BigDecimal.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)scale
- the scale of the returned value- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getUnicodeStream
@Deprecated public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
Deprecated.since JDBC 2.0, use getCharacterStream[Not supported]- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getUnicodeStream
@Deprecated public java.io.InputStream getUnicodeStream(java.lang.String columnLabel) throws java.sql.SQLException
Deprecated.since JDBC 2.0, use setCharacterStream[Not supported]- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
[Not supported] Gets a column as a object using the specified type mapping.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
[Not supported] Gets a column as a object using the specified type mapping.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
[Not supported] Gets a column as a reference.- Specified by:
getRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String columnLabel) throws java.sql.SQLException
[Not supported] Gets a column as a reference.- Specified by:
getRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Date using a specified time zone.Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)calendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getDate
public java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Date using a specified time zone.Usage of this method is discouraged. Use
getObject(columnLabel, LocalDate.class)
instead.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelcalendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getTime
public java.sql.Time getTime(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Time using a specified time zone.Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)calendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getTime
public java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Time using a specified time zone.Usage of this method is discouraged. Use
getObject(columnLabel, LocalTime.class)
instead.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelcalendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)calendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(int, Class)
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of the specified column as a java.sql.Timestamp.Usage of this method is discouraged. Use
getObject(columnLabel, LocalDateTime.class)
instead.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelcalendar
- the calendar- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed- See Also:
getObject(String, Class)
-
getBlob
public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a Blob.- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBlob
public java.sql.Blob getBlob(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a Blob.- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBlob
private JdbcBlob getBlob(int id, int columnIndex)
-
getBytes
public byte[] getBytes(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a byte array.- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBytes
public byte[] getBytes(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a byte array.- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBinaryStream
public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as an input stream.- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getBinaryStream
public java.io.InputStream getBinaryStream(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as an input stream.- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getClob
public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a Clob.- Specified by:
getClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getClob
public java.sql.Clob getClob(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a Clob.- Specified by:
getClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getArray
public java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as an Array.- Specified by:
getArray
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getArray
public java.sql.Array getArray(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as an Array.- Specified by:
getArray
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getArray
private java.sql.Array getArray(int id, int columnIndex)
-
getAsciiStream
public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as an input stream.- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getAsciiStream
public java.io.InputStream getAsciiStream(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as an input stream.- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getCharacterStream
public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a reader.- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a reader.- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getURL
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
[Not supported]- Specified by:
getURL
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String columnLabel) throws java.sql.SQLException
[Not supported]- Specified by:
getURL
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNull
public void updateNull(int columnIndex) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNull
public void updateNull(java.lang.String columnLabel) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBoolean
public void updateBoolean(java.lang.String columnLabel, boolean x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if result set is closed or not updatable
-
updateByte
public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateByte
public void updateByte(java.lang.String columnLabel, byte x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBytes
public void updateBytes(java.lang.String columnLabel, byte[] x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateShort
public void updateShort(int columnIndex, short x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateShort
public void updateShort(java.lang.String columnLabel, short x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateInt
public void updateInt(int columnIndex, int x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateInt
public void updateInt(java.lang.String columnLabel, int x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateLong
public void updateLong(int columnIndex, long x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateLong
public void updateLong(java.lang.String columnLabel, long x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateFloat
public void updateFloat(int columnIndex, float x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateFloat
public void updateFloat(java.lang.String columnLabel, float x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateDouble
public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateDouble
public void updateDouble(java.lang.String columnLabel, double x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBigDecimal
public void updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateString
public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateString
public void updateString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateString
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateDate
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnIndex, value)
withLocalDate
parameter instead.- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(int, Object)
-
updateDate
public void updateDate(java.lang.String columnLabel, java.sql.Date x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnLabel, value)
withLocalDate
parameter instead.- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(String, Object)
-
updateTime
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnIndex, value)
withLocalTime
parameter instead.- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(int, Object)
-
updateTime
public void updateTime(java.lang.String columnLabel, java.sql.Time x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnLabel, value)
withLocalTime
parameter instead.- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(String, Object)
-
updateTimestamp
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnIndex, value)
withLocalDateTime
parameter instead.- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(int, Object)
-
updateTimestamp
public void updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x) throws java.sql.SQLException
Updates a column in the current or insert row.Usage of this method is discouraged. Use
updateObject(columnLabel, value)
withLocalDateTime
parameter instead.- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable- See Also:
updateObject(String, Object)
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateAscii
private void updateAscii(int columnIndex, java.io.InputStream x, long length)
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, int length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuescale
- is ignored- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, int scale) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuescale
- is ignored- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuetargetSqlType
- the SQL type- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuetargetSqlType
- the SQL typescaleOrLength
- is ignored- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuetargetSqlType
- the SQL type- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuetargetSqlType
- the SQL typescaleOrLength
- is ignored- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateRef
public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
[Not supported]- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRef
public void updateRef(java.lang.String columnLabel, java.sql.Ref x) throws java.sql.SQLException
[Not supported]- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlob
public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.sql.Blob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlobImpl
private void updateBlobImpl(int columnIndex, java.sql.Blob x, long length) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateBlobImpl
private void updateBlobImpl(int columnIndex, java.io.InputStream x, long length)
-
updateClob
public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClob
public void updateClob(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClob
public void updateClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClob
public void updateClob(java.lang.String columnLabel, java.sql.Clob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateArray
public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateArray
public void updateArray(java.lang.String columnLabel, java.sql.Array x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateArrayImpl
private void updateArrayImpl(int columnIndex, java.sql.Array x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getCursorName
public java.lang.String getCursorName() throws java.sql.SQLException
[Not supported] Gets the cursor name if it was defined. This feature is superseded by updateX methods. This method throws a SQLException because cursor names are not supported.- Specified by:
getCursorName
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRow
public int getRow() throws java.sql.SQLException
Gets the current row number. The first row is row 1, the second 2 and so on. This method returns 0 before the first and after the last row.- Specified by:
getRow
in interfacejava.sql.ResultSet
- Returns:
- the row number
- Throws:
java.sql.SQLException
-
getConcurrency
public int getConcurrency() throws java.sql.SQLException
Gets the result set concurrency. Result sets are only updatable if the statement was created with updatable concurrency, and if the result set contains all columns of the primary key or of a unique index of a table.- Specified by:
getConcurrency
in interfacejava.sql.ResultSet
- Returns:
- ResultSet.CONCUR_UPDATABLE if the result set is updatable, or ResultSet.CONCUR_READ_ONLY otherwise
- Throws:
java.sql.SQLException
-
getFetchDirection
public int getFetchDirection() throws java.sql.SQLException
Gets the fetch direction.- Specified by:
getFetchDirection
in interfacejava.sql.ResultSet
- Returns:
- the direction: FETCH_FORWARD
- Throws:
java.sql.SQLException
-
getFetchSize
public int getFetchSize() throws java.sql.SQLException
Gets the number of rows suggested to read in one step.- Specified by:
getFetchSize
in interfacejava.sql.ResultSet
- Returns:
- the current fetch size
- Throws:
java.sql.SQLException
-
setFetchSize
public void setFetchSize(int rows) throws java.sql.SQLException
Sets the number of rows suggested to read in one step. This value cannot be higher than the maximum rows (setMaxRows) set by the statement or prepared statement, otherwise an exception is throws. Setting the value to 0 will set the default value. The default value can be changed using the system property h2.serverResultSetFetchSize.- Specified by:
setFetchSize
in interfacejava.sql.ResultSet
- Parameters:
rows
- the number of rows- Throws:
java.sql.SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws java.sql.SQLException
[Not supported] Sets (changes) the fetch direction for this result set. This method should only be called for scrollable result sets, otherwise it will throw an exception (no matter what direction is used).- Specified by:
setFetchDirection
in interfacejava.sql.ResultSet
- Parameters:
direction
- the new fetch direction- Throws:
java.sql.SQLException
- Unsupported Feature if the method is called for a forward-only result set
-
getType
public int getType() throws java.sql.SQLException
Get the result set type.- Specified by:
getType
in interfacejava.sql.ResultSet
- Returns:
- the result set type (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE)
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
isBeforeFirst
public boolean isBeforeFirst() throws java.sql.SQLException
Checks if the current position is before the first row, that means next() was not called yet, and there is at least one row.- Specified by:
isBeforeFirst
in interfacejava.sql.ResultSet
- Returns:
- if there are results and the current position is before the first row
- Throws:
java.sql.SQLException
- if the result set is closed
-
isAfterLast
public boolean isAfterLast() throws java.sql.SQLException
Checks if the current position is after the last row, that means next() was called and returned false, and there was at least one row.- Specified by:
isAfterLast
in interfacejava.sql.ResultSet
- Returns:
- if there are results and the current position is after the last row
- Throws:
java.sql.SQLException
- if the result set is closed
-
isFirst
public boolean isFirst() throws java.sql.SQLException
Checks if the current position is row 1, that means next() was called once and returned true.- Specified by:
isFirst
in interfacejava.sql.ResultSet
- Returns:
- if the current position is the first row
- Throws:
java.sql.SQLException
- if the result set is closed
-
isLast
public boolean isLast() throws java.sql.SQLException
Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.- Specified by:
isLast
in interfacejava.sql.ResultSet
- Returns:
- if the current position is the last row
- Throws:
java.sql.SQLException
- if the result set is closed
-
beforeFirst
public void beforeFirst() throws java.sql.SQLException
Moves the current position to before the first row, that means resets the result set.- Specified by:
beforeFirst
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed
-
afterLast
public void afterLast() throws java.sql.SQLException
Moves the current position to after the last row, that means after the end.- Specified by:
afterLast
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed
-
first
public boolean first() throws java.sql.SQLException
Moves the current position to the first row. This is the same as calling beforeFirst() followed by next().- Specified by:
first
in interfacejava.sql.ResultSet
- Returns:
- true if there is a row available, false if not
- Throws:
java.sql.SQLException
- if the result set is closed
-
last
public boolean last() throws java.sql.SQLException
Moves the current position to the last row.- Specified by:
last
in interfacejava.sql.ResultSet
- Returns:
- true if there is a row available, false if not
- Throws:
java.sql.SQLException
- if the result set is closed
-
absolute
public boolean absolute(int rowNumber) throws java.sql.SQLException
Moves the current position to a specific row.- Specified by:
absolute
in interfacejava.sql.ResultSet
- Parameters:
rowNumber
- the row number. 0 is not allowed, 1 means the first row, 2 the second. -1 means the last row, -2 the row before the last row. If the value is too large, the position is moved after the last row, if the value is too small it is moved before the first row.- Returns:
- true if there is a row available, false if not
- Throws:
java.sql.SQLException
- if the result set is closed
-
relative
public boolean relative(int rowCount) throws java.sql.SQLException
Moves the current position to a specific row relative to the current row.- Specified by:
relative
in interfacejava.sql.ResultSet
- Parameters:
rowCount
- 0 means don't do anything, 1 is the next row, -1 the previous. If the value is too large, the position is moved after the last row, if the value is too small it is moved before the first row.- Returns:
- true if there is a row available, false if not
- Throws:
java.sql.SQLException
- if the result set is closed
-
previous
public boolean previous() throws java.sql.SQLException
Moves the cursor to the last row, or row before first row if the current position is the first row.- Specified by:
previous
in interfacejava.sql.ResultSet
- Returns:
- true if there is a row available, false if not
- Throws:
java.sql.SQLException
- if the result set is closed
-
moveToInsertRow
public void moveToInsertRow() throws java.sql.SQLException
Moves the current position to the insert row. The current row is remembered.- Specified by:
moveToInsertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed or is not updatable
-
moveToCurrentRow
public void moveToCurrentRow() throws java.sql.SQLException
Moves the current position to the current row.- Specified by:
moveToCurrentRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed or is not updatable
-
rowUpdated
public boolean rowUpdated() throws java.sql.SQLException
Detects if the row was updated (by somebody else or the caller).- Specified by:
rowUpdated
in interfacejava.sql.ResultSet
- Returns:
- false because this driver does not detect this
- Throws:
java.sql.SQLException
-
rowInserted
public boolean rowInserted() throws java.sql.SQLException
Detects if the row was inserted.- Specified by:
rowInserted
in interfacejava.sql.ResultSet
- Returns:
- false because this driver does not detect this
- Throws:
java.sql.SQLException
-
rowDeleted
public boolean rowDeleted() throws java.sql.SQLException
Detects if the row was deleted (by somebody else or the caller).- Specified by:
rowDeleted
in interfacejava.sql.ResultSet
- Returns:
- false because this driver does not detect this
- Throws:
java.sql.SQLException
-
insertRow
public void insertRow() throws java.sql.SQLException
Inserts the current row. The current position must be the insert row.- Specified by:
insertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed or if not on the insert row, or if the result set it not updatable
-
updateRow
public void updateRow() throws java.sql.SQLException
Updates the current row.- Specified by:
updateRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed, if the current row is the insert row or if not on a valid row, or if the result set it not updatable
-
deleteRow
public void deleteRow() throws java.sql.SQLException
Deletes the current row.- Specified by:
deleteRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed, if the current row is the insert row or if not on a valid row, or if the result set it not updatable
-
refreshRow
public void refreshRow() throws java.sql.SQLException
Re-reads the current row from the database.- Specified by:
refreshRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed or if the current row is the insert row or if the row has been deleted or if not on a valid row
-
cancelRowUpdates
public void cancelRowUpdates() throws java.sql.SQLException
Cancels updating a row.- Specified by:
cancelRowUpdates
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- if the result set is closed or if the current row is the insert row
-
getUpdatableRow
private UpdatableRow getUpdatableRow() throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getColumnIndex
private int getColumnIndex(java.lang.String columnLabel)
-
checkColumnIndex
private int checkColumnIndex(int columnIndex)
-
checkClosed
void checkClosed()
Check if this result set is closed.- Throws:
DbException
- if it is closed
-
isOnValidRow
private boolean isOnValidRow()
-
checkOnValidRow
private void checkOnValidRow()
-
get
private Value get(int columnIndex)
-
getInternal
public Value getInternal(int columnIndex)
INTERNAL- Parameters:
columnIndex
- index of a column- Returns:
- internal representation of the value in the specified column
-
update
private void update(int columnIndex, Value v)
-
nextRow
private boolean nextRow()
-
nextLazyRow
private boolean nextLazyRow()
-
resetResult
private void resetResult()
-
getRowId
public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
[Not supported] Returns the value of the specified column as a row id.- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
[Not supported] Returns the value of the specified column as a row id.- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
[Not supported] Updates a column in the current or insert row.- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
[Not supported] Updates a column in the current or insert row.- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
-
getHoldability
public int getHoldability() throws java.sql.SQLException
Returns the current result set holdability.- Specified by:
getHoldability
in interfacejava.sql.ResultSet
- Returns:
- the holdability
- Throws:
java.sql.SQLException
- if the connection is closed
-
isClosed
public boolean isClosed() throws java.sql.SQLException
Returns whether this result set is closed.- Specified by:
isClosed
in interfacejava.sql.ResultSet
- Returns:
- true if the result set is closed
- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(int columnIndex, java.lang.String x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNString
public void updateNString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(int columnIndex, java.sql.NClob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the length- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.sql.NClob x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClobImpl
private void updateClobImpl(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a Clob.- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getNClob
public java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a Clob.- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getClob
private JdbcClob getClob(int id, int columnIndex)
-
getSQLXML
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a SQLXML.- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a SQLXML.- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
updateSQLXML
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)xmlObject
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateSQLXML
public void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelxmlObject
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateSQLXMLImpl
private void updateSQLXMLImpl(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a String.- Specified by:
getNString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getNString
public java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a String.- Specified by:
getNString
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
Returns the value of the specified column as a reader.- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
Returns the value of the specified column as a reader.- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column label- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- (1,2,...)x
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the value- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
Updates a column in the current or insert row.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column labelx
- the valuelength
- the number of characters- Throws:
java.sql.SQLException
- if the result set is closed or not updatable
-
updateClobImpl
private void updateClobImpl(int columnIndex, java.io.Reader x, long length)
-
unwrap
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
Return an object of this class if possible.- Specified by:
unwrap
in interfacejava.sql.Wrapper
- Parameters:
iface
- the class- Returns:
- this
- Throws:
java.sql.SQLException
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
Checks if unwrap can return an object of this class.- Specified by:
isWrapperFor
in interfacejava.sql.Wrapper
- Parameters:
iface
- the class- Returns:
- whether or not the interface is assignable from this class
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws java.sql.SQLException
Returns a column value as a Java object of the specified type.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- the column index (1, 2, ...)type
- the class of the returned value- Returns:
- the value
- Throws:
java.sql.SQLException
- if the column is not found or if the result set is closed
-
getObject
public <T> T getObject(java.lang.String columnName, java.lang.Class<T> type) throws java.sql.SQLException
Returns a column value as a Java object of the specified type.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the column nametype
- the class of the returned value- Returns:
- the value
- Throws:
java.sql.SQLException
-
toString
public java.lang.String toString()
INTERNAL- Overrides:
toString
in classjava.lang.Object
-
patchCurrentRow
private void patchCurrentRow(Value[] row)
-
convertToValue
private Value convertToValue(java.lang.Object x, java.sql.SQLType targetSqlType)
-
convertToUnknownValue
private Value convertToUnknownValue(java.lang.Object x)
-
checkUpdatable
private void checkUpdatable()
-
getUpdateRow
public Value[] getUpdateRow()
INTERNAL- Returns:
- array of column values for the current row
-
getResult
public ResultInterface getResult()
INTERNAL- Returns:
- result
-
-