Top Description Fields Constructors Methods
org.h2.jdbc

public final Class JdbcResultSet

extends TraceObject
implements ResultSet
Class Inheritance
All Implemented Interfaces
java.sql.ResultSet, java.lang.AutoCloseable, java.sql.Wrapper
Imports
java.io.InputStream, .Reader, java.math.BigDecimal, java.net.URL, java.sql.Array, .Blob, .Clob, .Date, .NClob, .Ref, .ResultSet, .ResultSetMetaData, .RowId, .SQLException, .SQLType, .SQLWarning, .SQLXML, .Statement, .Time, .Timestamp, java.util.Calendar, .HashMap, .Map, org.h2.api.ErrorCode, org.h2.command.CommandInterface, org.h2.engine.Session, .SysProperties, org.h2.message.DbException, .TraceObject, org.h2.result.ResultInterface, .UpdatableRow, org.h2.util.IOUtils, .LegacyDateTimeUtils, .StringUtils, org.h2.value.CompareMode, .DataType, .Value, .ValueBigint, .ValueBoolean, .ValueDouble, .ValueInteger, .ValueNull, .ValueNumeric, .ValueReal, .ValueSmallint, .ValueTinyint, .ValueToObjectConverter, .ValueVarbinary, .ValueVarchar

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

Modifier and TypeField and Description
private int
private HashMap<String, Integer>
private final CommandInterface
private JdbcConnection
private Value[]
private HashMap<Long, Value[]>
private JdbcPreparedStatement
pack-priv ResultInterface
private final boolean
private JdbcStatement
private final boolean
private final boolean
private Value[]
private boolean
Inherited from org.h2.message.TraceObject:
ARRAYBLOBCALLABLE_STATEMENTCLOBCONNECTIONDATA_SOURCEDATABASE_META_DATAPARAMETER_META_DATAPREPARED_STATEMENTRESULT_SETRESULT_SET_META_DATASAVEPOINTSQLXMLSTATEMENTtraceXA_DATA_SOURCEXID

Constructor Summary

AccessConstructor and Description
public
JdbcResultSet(JdbcConnection conn, JdbcStatement stat, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, boolean triggerUpdatable)

pack-priv
JdbcResultSet(JdbcConnection conn, JdbcPreparedStatement preparedStatement, CommandInterface command, ResultInterface result, int id, boolean scrollable, boolean updatable, HashMap<String, Integer> columnLabelMap)

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if there is a row available, false if not
absolute
(int
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.
rowNumber
)

Implements java.sql.ResultSet.absolute.

Moves the current position to a specific row.

public void
afterLast()

Implements java.sql.ResultSet.afterLast.

Moves the current position to after the last row, that means after the end.

public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

Moves the current position to before the first row, that means resets the result set.

public void
cancelRowUpdates()

Implements java.sql.ResultSet.cancelRowUpdates.

Cancels updating a row.

pack-priv void
checkClosed()

Check if this result set is closed.

private int
checkColumnIndex(int columnIndex)

private void
private void
public void
clearWarnings()

Implements java.sql.ResultSet.clearWarnings.

Clears all warnings.

public void
close()

Implements java.sql.ResultSet.close.

Closes the result set.

pack-priv void
closeInternal(boolean
if true - close statement in the end
fromStatement
)

Close the result set.

private Value
private Value
convertToValue(Object x, SQLType targetSqlType)

public void
deleteRow()

Implements java.sql.ResultSet.deleteRow.

Deletes the current row.

public int

Returns:

the column index (1,2,...)
findColumn
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.findColumn.

Searches for a specific column in the result set.

public boolean

Returns:

true if there is a row available, false if not
first
()

Implements java.sql.ResultSet.first.

Moves the current position to the first row.

private Value
get(int columnIndex)

public Array

Returns:

the value
getArray
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getArray.

Returns the value of the specified column as an Array.

public Array

Returns:

the value
getArray
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getArray.

Returns the value of the specified column as an Array.

private Array
getArray(int id, int columnIndex)

public InputStream

Returns:

the value
getAsciiStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

Returns the value of the specified column as an input stream.

public InputStream

Returns:

the value
getAsciiStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getAsciiStream.

Returns the value of the specified column as an input stream.

public BigDecimal

Returns:

the value
getBigDecimal
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBigDecimal.

Returns the value of the specified column as a BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBigDecimal.

Returns the value of the specified column as a BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(String
the column label
columnLabel
,
int
the scale of the returned value
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated use getBigDecimal(String)

Returns the value of the specified column as a BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(int
(1,2,...)
columnIndex
,
int
the scale of the returned value
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated use getBigDecimal(int)

Returns the value of the specified column as a BigDecimal.

public InputStream

Returns:

the value
getBinaryStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

Returns the value of the specified column as an input stream.

public InputStream

Returns:

the value
getBinaryStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBinaryStream.

Returns the value of the specified column as an input stream.

public Blob

Returns:

the value
getBlob
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBlob.

Returns the value of the specified column as a Blob.

public Blob

Returns:

the value
getBlob
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBlob.

Returns the value of the specified column as a Blob.

private JdbcBlob
getBlob(int id, int columnIndex)

public boolean

Returns:

the value
getBoolean
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBoolean.

Returns the value of the specified column as a boolean.

public boolean

Returns:

the value
getBoolean
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBoolean.

Returns the value of the specified column as a boolean.

private boolean
getBooleanInternal(int columnIndex)

public byte

Returns:

the value
getByte
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getByte.

Returns the value of the specified column as a byte.

public byte

Returns:

the value
getByte
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getByte.

Returns the value of the specified column as a byte.

private byte
getByteInternal(int columnIndex)

public byte[]

Returns:

the value
getBytes
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBytes.

Returns the value of the specified column as a byte array.

public byte[]

Returns:

the value
getBytes
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBytes.

Returns the value of the specified column as a byte array.

public Reader

Returns:

the value
getCharacterStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getCharacterStream.

Returns the value of the specified column as a reader.

public Reader

Returns:

the value
getCharacterStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getCharacterStream.

Returns the value of the specified column as a reader.

public Clob

Returns:

the value
getClob
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getClob.

Returns the value of the specified column as a Clob.

public Clob

Returns:

the value
getClob
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getClob.

Returns the value of the specified column as a Clob.

private JdbcClob
getClob(int id, int columnIndex)

private int
getColumnIndex(String columnLabel)

public int

Returns:

ResultSet.CONCUR_UPDATABLE if the result set is updatable, or ResultSet.CONCUR_READ_ONLY otherwise
getConcurrency
()

Implements java.sql.ResultSet.getConcurrency.

Gets the result set concurrency.

public String
getCursorName()

Implements java.sql.ResultSet.getCursorName.

[Not supported] Gets the cursor name if it was defined.

public Date

Returns:

the value
getDate
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getDate.

Returns the value of the specified column as a java.sql.Date.

public Date

Returns:

the value
getDate
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getDate.

Returns the value of the specified column as a java.sql.Date.

public Date

Returns:

the value
getDate
(int
(1,2,...)
columnIndex
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getDate.

Returns the value of the specified column as a java.sql.Date using a specified time zone.

public Date

Returns:

the value
getDate
(String
the column label
columnLabel
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getDate.

Returns the value of the specified column as a java.sql.Date using a specified time zone.

public double

Returns:

the value
getDouble
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getDouble.

Returns the value of the specified column as a double.

public double

Returns:

the value
getDouble
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getDouble.

Returns the value of the specified column as a double.

private double
getDoubleInternal(int columnIndex)

public int

Returns:

the direction: FETCH_FORWARD
getFetchDirection
()

Implements java.sql.ResultSet.getFetchDirection.

Gets the fetch direction.

public int

Returns:

the current fetch size
getFetchSize
()

Implements java.sql.ResultSet.getFetchSize.

Gets the number of rows suggested to read in one step.

public float

Returns:

the value
getFloat
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getFloat.

Returns the value of the specified column as a float.

public float

Returns:

the value
getFloat
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getFloat.

Returns the value of the specified column as a float.

private float
getFloatInternal(int columnIndex)

public int

Returns:

the holdability
getHoldability
()

Implements java.sql.ResultSet.getHoldability.

Returns the current result set holdability.

public int

Returns:

the value
getInt
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getInt.

Returns the value of the specified column as an int.

public int

Returns:

the value
getInt
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getInt.

Returns the value of the specified column as an int.

public Value

Returns:

internal representation of the value in the specified column
getInternal
(int
index of a column
columnIndex
)

INTERNAL

private int
getIntInternal(int columnIndex)

public long

Returns:

the value
getLong
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getLong.

Returns the value of the specified column as a long.

public long

Returns:

the value
getLong
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getLong.

Returns the value of the specified column as a long.

private long
getLongInternal(int columnIndex)

public ResultSetMetaData

Returns:

the meta data
getMetaData
()

Implements java.sql.ResultSet.getMetaData.

Gets the meta data of this result set.

public Reader

Returns:

the value
getNCharacterStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getNCharacterStream.

Returns the value of the specified column as a reader.

public Reader

Returns:

the value
getNCharacterStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getNCharacterStream.

Returns the value of the specified column as a reader.

public NClob

Returns:

the value
getNClob
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getNClob.

Returns the value of the specified column as a Clob.

public NClob

Returns:

the value
getNClob
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getNClob.

Returns the value of the specified column as a Clob.

public String

Returns:

the value
getNString
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getNString.

Returns the value of the specified column as a String.

public String

Returns:

the value
getNString
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getNString.

Returns the value of the specified column as a String.

public Object

Returns:

the value or null
getObject
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getObject.

Returns a column value as a Java object.

public Object

Returns:

the value or null
getObject
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getObject.

Returns a column value as a Java object.

public Object
getObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

[Not supported] Gets a column as a object using the specified type mapping.

public Object
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

[Not supported] Gets a column as a object using the specified type mapping.

public <T> T

Returns:

the value
getObject
(int
the column index (1, 2, ...)
columnIndex
,
Class<T>
the class of the returned value
type
)

Implements java.sql.ResultSet.getObject.

Returns a column value as a Java object of the specified type.

public <T> T

Returns:

the value
getObject
(String
the column name
columnName
,
Class<T>
the class of the returned value
type
)

Implements java.sql.ResultSet.getObject.

Returns a column value as a Java object of the specified type.

public Ref
getRef(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRef.

[Not supported] Gets a column as a reference.

public Ref
getRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getRef.

[Not supported] Gets a column as a reference.

public ResultInterface

Returns:

result
getResult
()

INTERNAL

public int

Returns:

the row number
getRow
()

Implements java.sql.ResultSet.getRow.

Gets the current row number.

public RowId
getRowId(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getRowId.

[Not supported] Returns the value of the specified column as a row id.

public RowId
getRowId(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getRowId.

[Not supported] Returns the value of the specified column as a row id.

public short

Returns:

the value
getShort
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getShort.

Returns the value of the specified column as a short.

public short

Returns:

the value
getShort
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getShort.

Returns the value of the specified column as a short.

private short
getShortInternal(int columnIndex)

public SQLXML

Returns:

the value
getSQLXML
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getSQLXML.

Returns the value of the specified column as a SQLXML.

public SQLXML

Returns:

the value
getSQLXML
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getSQLXML.

Returns the value of the specified column as a SQLXML.

public Statement

Returns:

the statement or prepared statement, or null if created by a DatabaseMetaData call.
getStatement
()

Implements java.sql.ResultSet.getStatement.

Returns the statement that created this object.

public String

Returns:

the value
getString
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getString.

Returns the value of the specified column as a String.

public String

Returns:

the value
getString
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getString.

Returns the value of the specified column as a String.

public Time

Returns:

the value
getTime
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getTime.

Returns the value of the specified column as a java.sql.Time.

public Time

Returns:

the value
getTime
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getTime.

Returns the value of the specified column as a java.sql.Time.

public Time

Returns:

the value
getTime
(int
(1,2,...)
columnIndex
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getTime.

Returns the value of the specified column as a java.sql.Time using a specified time zone.

public Time

Returns:

the value
getTime
(String
the column label
columnLabel
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getTime.

Returns the value of the specified column as a java.sql.Time using a specified time zone.

public Timestamp

Returns:

the value
getTimestamp
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp.

public Timestamp

Returns:

the value
getTimestamp
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp.

public Timestamp

Returns:

the value
getTimestamp
(int
(1,2,...)
columnIndex
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.

public Timestamp

Returns:

the value
getTimestamp
(String
the column label
columnLabel
,
Calendar
the calendar
calendar
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp.

public int

Returns:

the result set type (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE)
getType
()

Implements java.sql.ResultSet.getType.

Get the result set type.

public InputStream
getUnicodeStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated since JDBC 2.0, use getCharacterStream

[Not supported]

public InputStream
getUnicodeStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated since JDBC 2.0, use setCharacterStream

[Not supported]

private UpdatableRow
public Value[]

Returns:

array of column values for the current row
getUpdateRow
()

INTERNAL

public URL
getURL(int
the index of the column 1 is the first, 2 is the second,...
columnIndex
)

Implements java.sql.ResultSet.getURL.

[Not supported]

public URL
getURL(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getURL.

[Not supported]

public SQLWarning

Returns:

null
getWarnings
()

Implements java.sql.ResultSet.getWarnings.

Gets the first warning reported by calls on this object.

public void
insertRow()

Implements java.sql.ResultSet.insertRow.

Inserts the current row.

public boolean

Returns:

if there are results and the current position is after the last row
isAfterLast
()

Implements java.sql.ResultSet.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.

public boolean

Returns:

if there are results and the current position is before the first row
isBeforeFirst
()

Implements java.sql.ResultSet.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.

public boolean

Returns:

true if the result set is closed
isClosed
()

Implements java.sql.ResultSet.isClosed.

Returns whether this result set is closed.

public boolean

Returns:

if the current position is the first row
isFirst
()

Implements java.sql.ResultSet.isFirst.

Checks if the current position is row 1, that means next() was called once and returned true.

public boolean

Returns:

if the current position is the last row
isLast
()

Implements java.sql.ResultSet.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
public boolean

Returns:

whether or not the interface is assignable from this class
isWrapperFor
(Class<?>
the class
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Checks if unwrap can return an object of this class.

public boolean

Returns:

true if there is a row available, false if not
last
()

Implements java.sql.ResultSet.last.

Moves the current position to the last row.

public void
moveToCurrentRow()

Implements java.sql.ResultSet.moveToCurrentRow.

Moves the current position to the current row.

public void
moveToInsertRow()

Implements java.sql.ResultSet.moveToInsertRow.

Moves the current position to the insert row.

public boolean

Returns:

true if successful, false if there are no more rows
next
()

Implements java.sql.ResultSet.next.

Moves the cursor to the next row of the result set.

private boolean
private boolean
private void
public boolean

Returns:

true if there is a row available, false if not
previous
()

Implements java.sql.ResultSet.previous.

Moves the cursor to the last row, or row before first row if the current position is the first row.

public void
refreshRow()

Implements java.sql.ResultSet.refreshRow.

Re-reads the current row from the database.

public boolean

Returns:

true if there is a row available, false if not
relative
(int
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.
rowCount
)

Implements java.sql.ResultSet.relative.

Moves the current position to a specific row relative to the current row.

private void
public boolean

Returns:

false because this driver does not detect this
rowDeleted
()

Implements java.sql.ResultSet.rowDeleted.

Detects if the row was deleted (by somebody else or the caller).

public boolean

Returns:

false because this driver does not detect this
rowInserted
()

Implements java.sql.ResultSet.rowInserted.

Detects if the row was inserted.

public boolean

Returns:

false because this driver does not detect this
rowUpdated
()

Implements java.sql.ResultSet.rowUpdated.

Detects if the row was updated (by somebody else or the caller).

public void
setFetchDirection(int
the new fetch direction
direction
)

Implements java.sql.ResultSet.setFetchDirection.

[Not supported] Sets (changes) the fetch direction for this result set.

public void
setFetchSize(int
the number of rows
rows
)

Implements java.sql.ResultSet.setFetchSize.

Sets the number of rows suggested to read in one step.

public String
toString()

Overrides java.lang.Object.toString.

INTERNAL

public <T> T

Returns:

this
unwrap
(Class<T>
the class
iface
)

Implements java.sql.Wrapper.unwrap.

Return an object of this class if possible.

private void
update(int columnIndex, Value v)

public void
updateArray(int
(1,2,...)
columnIndex
,
Array
the value
x
)

Implements java.sql.ResultSet.updateArray.

Updates a column in the current or insert row.

public void
updateArray(String
the column label
columnLabel
,
Array
the value
x
)

Implements java.sql.ResultSet.updateArray.

Updates a column in the current or insert row.

private void
updateArrayImpl(int columnIndex, Array x)

private void
updateAscii(int columnIndex, InputStream x, long length)

public void
updateAsciiStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateAsciiStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateAsciiStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateAsciiStream(String
the column label
columnLabel
,
InputStream
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateAsciiStream(String
the column label
columnLabel
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateAsciiStream(String
the column label
columnLabel
,
InputStream
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates a column in the current or insert row.

public void
updateBigDecimal(int
(1,2,...)
columnIndex
,
BigDecimal
the value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

Updates a column in the current or insert row.

public void
updateBigDecimal(String
the column label
columnLabel
,
BigDecimal
the value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

Updates a column in the current or insert row.

public void
updateBinaryStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBinaryStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBinaryStream(int
(1,2,...)
columnIndex
,
InputStream
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBinaryStream(String
the column label
columnLabel
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBinaryStream(String
the column label
columnLabel
,
InputStream
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBinaryStream(String
the column label
columnLabel
,
InputStream
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates a column in the current or insert row.

public void
updateBlob(int
(1,2,...)
columnIndex
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

public void
updateBlob(int
(1,2,...)
columnIndex
,
InputStream
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

public void
updateBlob(int
(1,2,...)
columnIndex
,
Blob
the value
x
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

public void
updateBlob(String
the column label
columnLabel
,
Blob
the value
x
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

public void
updateBlob(String
the column label
columnLabel
,
InputStream
the value
x
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

public void
updateBlob(String
the column label
columnLabel
,
InputStream
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateBlob.

Updates a column in the current or insert row.

private void
updateBlobImpl(int columnIndex, Blob x, long length)

private void
updateBlobImpl(int columnIndex, InputStream x, long length)

public void
updateBoolean(int
(1,2,...)
columnIndex
,
boolean
the value
x
)

Implements java.sql.ResultSet.updateBoolean.

Updates a column in the current or insert row.

public void
updateBoolean(String
the column label
columnLabel
,
boolean
the value
x
)

Implements java.sql.ResultSet.updateBoolean.

Updates a column in the current or insert row.

public void
updateByte(int
(1,2,...)
columnIndex
,
byte
the value
x
)

Implements java.sql.ResultSet.updateByte.

Updates a column in the current or insert row.

public void
updateByte(String
the column label
columnLabel
,
byte
the value
x
)

Implements java.sql.ResultSet.updateByte.

Updates a column in the current or insert row.

public void
updateBytes(int
(1,2,...)
columnIndex
,
byte[]
the value
x
)

Implements java.sql.ResultSet.updateBytes.

Updates a column in the current or insert row.

public void
updateBytes(String
the column label
columnLabel
,
byte[]
the value
x
)

Implements java.sql.ResultSet.updateBytes.

Updates a column in the current or insert row.

public void
updateCharacterStream(int
(1,2,...)
columnIndex
,
Reader
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateCharacterStream(int
(1,2,...)
columnIndex
,
Reader
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateCharacterStream(int
(1,2,...)
columnIndex
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateCharacterStream(String
the column label
columnLabel
,
Reader
the value
x
,
int
the number of characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateCharacterStream(String
the column label
columnLabel
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateCharacterStream(String
the column label
columnLabel
,
Reader
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates a column in the current or insert row.

public void
updateClob(int
(1,2,...)
columnIndex
,
Clob
the value
x
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

public void
updateClob(int
(1,2,...)
columnIndex
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

public void
updateClob(int
(1,2,...)
columnIndex
,
Reader
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

public void
updateClob(String
the column label
columnLabel
,
Clob
the value
x
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

public void
updateClob(String
the column label
columnLabel
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

public void
updateClob(String
the column label
columnLabel
,
Reader
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateClob.

Updates a column in the current or insert row.

private void
updateClobImpl(int columnIndex, Clob x)

private void
updateClobImpl(int columnIndex, Reader x, long length)

public void
updateDate(int
(1,2,...)
columnIndex
,
Date
the value
x
)

Implements java.sql.ResultSet.updateDate.

Updates a column in the current or insert row.

public void
updateDate(String
the column label
columnLabel
,
Date
the value
x
)

Implements java.sql.ResultSet.updateDate.

Updates a column in the current or insert row.

public void
updateDouble(int
(1,2,...)
columnIndex
,
double
the value
x
)

Implements java.sql.ResultSet.updateDouble.

Updates a column in the current or insert row.

public void
updateDouble(String
the column label
columnLabel
,
double
the value
x
)

Implements java.sql.ResultSet.updateDouble.

Updates a column in the current or insert row.

public void
updateFloat(int
(1,2,...)
columnIndex
,
float
the value
x
)

Implements java.sql.ResultSet.updateFloat.

Updates a column in the current or insert row.

public void
updateFloat(String
the column label
columnLabel
,
float
the value
x
)

Implements java.sql.ResultSet.updateFloat.

Updates a column in the current or insert row.

public void
updateInt(int
(1,2,...)
columnIndex
,
int
the value
x
)

Implements java.sql.ResultSet.updateInt.

Updates a column in the current or insert row.

public void
updateInt(String
the column label
columnLabel
,
int
the value
x
)

Implements java.sql.ResultSet.updateInt.

Updates a column in the current or insert row.

public void
updateLong(int
(1,2,...)
columnIndex
,
long
the value
x
)

Implements java.sql.ResultSet.updateLong.

Updates a column in the current or insert row.

public void
updateLong(String
the column label
columnLabel
,
long
the value
x
)

Implements java.sql.ResultSet.updateLong.

Updates a column in the current or insert row.

public void
updateNCharacterStream(int
(1,2,...)
columnIndex
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates a column in the current or insert row.

public void
updateNCharacterStream(int
(1,2,...)
columnIndex
,
Reader
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates a column in the current or insert row.

public void
updateNCharacterStream(String
the column label
columnLabel
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates a column in the current or insert row.

public void
updateNCharacterStream(String
the column label
columnLabel
,
Reader
the value
x
,
long
the number of characters
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates a column in the current or insert row.

public void
updateNClob(int
(1,2,...)
columnIndex
,
NClob
the value
x
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNClob(int
(1,2,...)
columnIndex
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNClob(int
(1,2,...)
columnIndex
,
Reader
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNClob(String
the column label
columnLabel
,
Reader
the value
x
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNClob(String
the column label
columnLabel
,
Reader
the value
x
,
long
the length
length
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNClob(String
the column label
columnLabel
,
NClob
the value
x
)

Implements java.sql.ResultSet.updateNClob.

Updates a column in the current or insert row.

public void
updateNString(int
(1,2,...)
columnIndex
,
String
the value
x
)

Implements java.sql.ResultSet.updateNString.

Updates a column in the current or insert row.

public void
updateNString(String
the column label
columnLabel
,
String
the value
x
)

Implements java.sql.ResultSet.updateNString.

Updates a column in the current or insert row.

public void
updateNull(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.updateNull.

Updates a column in the current or insert row.

public void
updateNull(String
the column label
columnLabel
)

Implements java.sql.ResultSet.updateNull.

Updates a column in the current or insert row.

public void
updateObject(int
(1,2,...)
columnIndex
,
Object
the value
x
,
int
is ignored
scale
)

Implements java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(String
the column label
columnLabel
,
Object
the value
x
,
int
is ignored
scale
)

Implements java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(int
(1,2,...)
columnIndex
,
Object
the value
x
)

Implements java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(String
the column label
columnLabel
,
Object
the value
x
)

Implements java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(int
(1,2,...)
columnIndex
,
Object
the value
x
,
SQLType
the SQL type
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(int
(1,2,...)
columnIndex
,
Object
the value
x
,
SQLType
the SQL type
targetSqlType
,
int
is ignored
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(String
the column label
columnLabel
,
Object
the value
x
,
SQLType
the SQL type
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateObject(String
the column label
columnLabel
,
Object
the value
x
,
SQLType
the SQL type
targetSqlType
,
int
is ignored
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates a column in the current or insert row.

public void
updateRef(int
the first column is 1, the second is 2, ...
columnIndex
,
Ref
the new column value
x
)

Implements java.sql.ResultSet.updateRef.

[Not supported]

public void
updateRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Ref
the new column value
x
)

Implements java.sql.ResultSet.updateRef.

[Not supported]

public void
updateRow()

Implements java.sql.ResultSet.updateRow.

Updates the current row.

public void
updateRowId(int
(1,2,...)
columnIndex
,
RowId
the value
x
)

Implements java.sql.ResultSet.updateRowId.

[Not supported] Updates a column in the current or insert row.

public void
updateRowId(String
the column label
columnLabel
,
RowId
the value
x
)

Implements java.sql.ResultSet.updateRowId.

[Not supported] Updates a column in the current or insert row.

public void
updateShort(int
(1,2,...)
columnIndex
,
short
the value
x
)

Implements java.sql.ResultSet.updateShort.

Updates a column in the current or insert row.

public void
updateShort(String
the column label
columnLabel
,
short
the value
x
)

Implements java.sql.ResultSet.updateShort.

Updates a column in the current or insert row.

public void
updateSQLXML(int
(1,2,...)
columnIndex
,
SQLXML
the value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates a column in the current or insert row.

public void
updateSQLXML(String
the column label
columnLabel
,
SQLXML
the value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates a column in the current or insert row.

private void
updateSQLXMLImpl(int columnIndex, SQLXML xmlObject)

public void
updateString(int
(1,2,...)
columnIndex
,
String
the value
x
)

Implements java.sql.ResultSet.updateString.

Updates a column in the current or insert row.

public void
updateString(String
the column label
columnLabel
,
String
the value
x
)

Implements java.sql.ResultSet.updateString.

Updates a column in the current or insert row.

public void
updateTime(int
(1,2,...)
columnIndex
,
Time
the value
x
)

Implements java.sql.ResultSet.updateTime.

Updates a column in the current or insert row.

public void
updateTime(String
the column label
columnLabel
,
Time
the value
x
)

Implements java.sql.ResultSet.updateTime.

Updates a column in the current or insert row.

public void
updateTimestamp(int
(1,2,...)
columnIndex
,
Timestamp
the value
x
)

Implements java.sql.ResultSet.updateTimestamp.

Updates a column in the current or insert row.

public void
updateTimestamp(String
the column label
columnLabel
,
Timestamp
the value
x
)

Implements java.sql.ResultSet.updateTimestamp.

Updates a column in the current or insert row.

public boolean

Returns:

true if the last column accessed was null
wasNull
()

Implements java.sql.ResultSet.wasNull.

Returns whether the last column accessed was null.

Inherited from org.h2.message.TraceObject:
debugCodedebugCodeAssigndebugCodeCalldebugCodeCalldebugCodeCallgetNextIdgetTraceIdgetTraceObjectNameisDebugEnabledisInfoEnabledlogAndConvertquotequoteArrayquoteBigDecimalquoteBytesquoteDatequoteIntArrayquoteMapquoteTimequoteTimestampsetTraceunsupported