Top Description Fields Constructors Methods
org.apache.derby.impl.jdbc

public Class EmbedResultSet

extends ConnectionChild
implements EngineResultSet, Comparable
Class Inheritance
All Implemented Interfaces
java.lang.Comparable, org.apache.derby.iapi.jdbc.EngineResultSet, java.sql.ResultSet, java.lang.AutoCloseable, java.sql.Wrapper
Known Direct Subclasses
org.apache.derby.impl.jdbc.EmbedResultSet42
Imports
java.io.ByteArrayInputStream, .Reader, .InputStream, .IOException, org.apache.derby.shared.common.sanity.SanityManager, org.apache.derby.shared.common.error.StandardException, .ExceptionSeverity, org.apache.derby.iapi.jdbc.EngineResultSet, .CharacterStreamDescriptor, org.apache.derby.iapi.sql.conn.LanguageConnectionContext, .StatementContext, org.apache.derby.iapi.sql.ResultSet, .ParameterValueSet, .Activation, .ResultDescription, org.apache.derby.iapi.sql.execute.ExecutionFactory, .ExecCursorTableReference, .ExecRow, .NoPutResultSet, .CursorActivation, org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet, org.apache.derby.iapi.types.DataTypeDescriptor, .DataValueDescriptor, .RawToBinaryFormatStream, .ReaderToUTF8Stream, .UserDataValue, .VariableSizeDataValue, .SQLDecimal, .StringDataValue, org.apache.derby.iapi.services.io.LimitInputStream, .CloseFilterInputStream, org.apache.derby.shared.common.reference.SQLState, java.sql.Blob, .Clob, .Statement, .SQLException, .SQLWarning, .ResultSetMetaData, .Date, .Time, .Timestamp, .Types, .Array, .NClob, .Ref, .RowId, .SQLXML, java.math.BigDecimal, java.net.URL, java.util.Arrays, .Calendar, .Map, org.apache.derby.iapi.sql.dictionary.DataDictionary, org.apache.derby.iapi.util.IdUtil, .InterruptStatus

A EmbedResultSet for results from the EmbedStatement family. Supports JDBC 4.1.

Field Summary

Modifier and TypeField and Description
protected static final int
protected static final int
private Statement
applicationStmt

Statement object the application used to create this ResultSet.

protected static final int
private boolean[]
private boolean[]
columnUsedFlags

Indicates which columns have been fetched as a stream or as a LOB for a row.

private final int
private ExecRow
currentRow

The currentRow contains the data of the current row of the resultset.

private boolean
private Object
private int
private static long
fetchedRowBase

For use in debugging setLargeMaxRows() method added by JDBC 4.2

private int
protected static final int
private boolean
private final boolean
pack-priv boolean
isClosed

Set if this ResultSet is definitely closed.

private boolean
protected static final int
private final int
private long
protected static final int
private long
pack-priv final int
private EmbedStatement
owningStmt

The statement that currently owns this ResultSet.

protected static final int
protected static final int
private final ResultDescription
pack-priv Activation
singleUseActivation

This activation is set by EmbedStatement for a single execution Activation.

private final EmbedStatement
stmt

The statement object that originally created us.

private ResultSet
private final long
private SQLWarning
private final ExecRow
protected boolean
Inherited from org.apache.derby.impl.jdbc.ConnectionChild:
factorylocalConn

Constructor Summary

AccessConstructor and Description
public
EmbedResultSet(EmbedConnection conn, ResultSet resultsToWrap, boolean forMetaData, EmbedStatement stmt, boolean isAtomic)

This class provides the glue between the Derby resultset and the JDBC resultset, mapping calls-to-calls.

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if on the result set, false if off.
absolute
(int
the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
row
)

Implements java.sql.ResultSet.absolute.

JDBC 2.0

Move to an absolute row number in the result set.

private void
addWarning(SQLWarning
The warning to add to the warning chain.
w
)

Adds a warning to the end of the warning chain.

protected void
adjustScale(int columnIndex, int scale)

Adjust the scale of a type.

public void
afterLast()

Implements java.sql.ResultSet.afterLast.

JDBC 2.0

Moves to the end of the result set, just after the last row.

public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

JDBC 2.0

Moves to the front of the result set, just before the first row.

public void
cancelRowUpdates()

Implements java.sql.ResultSet.cancelRowUpdates.

JDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row.

pack-priv final void
checkExecIfClosed(String operation)

Throw an exception if this ResultSet is closed or its Connection has been closed.

pack-priv final void
checkIfClosed(String
The operation the caller is trying to perform
operation
)

Throw an exception if this ResultSet is closed.

private void
checkLOBMultiCall(int
1-based index of the LOB column
columnIndex
)

Checks if a stream or a LOB object has already been created for the specified LOB column.

private void
protected final void
private boolean
checkRowPosition(int position, String positionText)

protected void
private void
checksBeforeUpdateAsciiStream(int
the column index (first column is 1)
columnIndex
)

Check whether it is OK to update a column using updateAsciiStream().

private void
checksBeforeUpdateBinaryStream(int
the column index (first column is 1)
columnIndex
)

Check whether it is OK to update a column using updateBinaryStream().

private void
checksBeforeUpdateCharacterStream(int
the column index (first column is 1)
columnIndex
)

Check whether it is OK to update a column using updateCharacterStream().

protected void
checksBeforeUpdateOrDelete(String methodName, int columnIndex)

protected void
checksBeforeUpdateXXX(String methodName, int columnIndex)

private void
checkScrollCursor(String
name of the method which requests the check
methodName
)

Checks if the result set has a scrollable cursor.

private void
public final void
clearWarnings()

Implements java.sql.ResultSet.clearWarnings.

After this call getWarnings returns null until a new warning is reported for this ResultSet.

public void
close()

Implements java.sql.ResultSet.close.

In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.

private final void
closeCurrentStream()

Documented behaviour for streams is that they are implicitly closed on the next get*() method call.

pack-priv final SQLException
public final int
compareTo(Object
the object to be compared.
other
)

Implements java.lang.Comparable.compareTo.

Compares this object with the specified object for order.

private final SQLException
dataTypeConversion(String targetType, int column)

private final SQLException
dataTypeConversion(int column, String targetType)

public void
deleteRow()

Implements java.sql.ResultSet.deleteRow.

JDBC 2.0 Delete the current row from the result set and the underlying database.

public final int

Returns:

the column index
findColumn
(String
the name of the column
columnName
)

Implements java.sql.ResultSet.findColumn.

Map a Resultset column name to a ResultSet column index.

protected int

Returns:

the column index
findColumnName
(String
the name of the column
columnName
)

Map a Resultset column name to a ResultSet column index.

public boolean

Returns:

true if on a valid row, false if no rows in the result set.
first
()

Implements java.sql.ResultSet.first.

JDBC 2.0

Moves to the first row in the result set.

public final Array

Returns:

an object representing an SQL array
getArray
(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getArray.

JDBC 2.0 Get an array column.

public final Array

Returns:

an object representing an SQL array
getArray
(String
the column name
colName
)

Implements java.sql.ResultSet.getArray.

JDBC 2.0 Get an array column.

public final InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
getAsciiStream
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

Pushes a converter on top of getCharacterStream().

public final InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
getAsciiStream
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getAsciiStream.

A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.

public final BigDecimal

Returns:

the column value; if the value is SQL NULL, the result is null
getBigDecimal
(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the number of digits to the right of the decimal
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated

Get the value of a column in the current row as a java.lang.BigDecimal object.

public final BigDecimal
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBigDecimal.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

public final BigDecimal

Returns:

the column value; if the value is SQL NULL, the result is null
getBigDecimal
(String
is the SQL name of the column
columnName
,
int
the number of digits to the right of the decimal
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated

Get the value of a column in the current row as a java.lang.BigDecimal object.

public final BigDecimal
getBigDecimal(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
columnName
)

Implements java.sql.ResultSet.getBigDecimal.

JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object.

public final InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
getBinaryStream
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

Get the column as an InputStream.

public final InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
getBinaryStream
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getBinaryStream.

A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.

public Blob

Returns:

an object representing a BLOB
getBlob
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBlob.

JDBC 2.0 Get a BLOB column.

public final Blob

Returns:

an object representing a BLOB
getBlob
(String
the column name
columnName
)

Implements java.sql.ResultSet.getBlob.

JDBC 2.0 Get a BLOB column.

public final boolean

Returns:

the column value; if the value is SQL NULL, the result is false
getBoolean
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBoolean.

Get the value of a column in the current row as a Java boolean.

public final boolean

Returns:

the column value; if the value is SQL NULL, the result is false
getBoolean
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getBoolean.

Get the value of a column in the current row as a Java boolean.

public final byte

Returns:

the column value; if the value is SQL NULL, the result is 0
getByte
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getByte.

Get the value of a column in the current row as a Java byte.

public final byte

Returns:

the column value; if the value is SQL NULL, the result is 0
getByte
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getByte.

Get the value of a column in the current row as a Java byte.

public final byte[]

Returns:

the column value; if the value is SQL NULL, the result is null
getBytes
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBytes.

Get the value of a column in the current row as a Java byte array.

public final byte[]

Returns:

the column value; if the value is SQL NULL, the result is null
getBytes
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getBytes.

Get the value of a column in the current row as a Java byte array.

public final Reader
getCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getCharacterStream.

JDBC 2.0

Get the value of a column in the current row as a java.io.Reader.

public final Reader
getCharacterStream(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
columnName
)

Implements java.sql.ResultSet.getCharacterStream.

JDBC 2.0

Get the value of a column in the current row as a java.io.Reader.

public final Clob

Returns:

an object representing a CLOB
getClob
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getClob.

JDBC 2.0 Get a CLOB column.

public final Clob

Returns:

an object representing a CLOB
getClob
(String
the column name
columnName
)

Implements java.sql.ResultSet.getClob.

JDBC 2.0 Get a CLOB column.

protected final DataValueDescriptor
getColumn(int columnIndex)

Get the column value for a getXXX() call.

pack-priv final String
getColumnSQLType(int column)

pack-priv final int
getColumnType(int columnIndex)

Check the column is in range *and* return the JDBC type of the column.

public int

Returns:

the concurrency type, CONCUR_READ_ONLY, etc.
getConcurrency
()

Implements java.sql.ResultSet.getConcurrency.

JDBC 2.0 Return the concurrency of this result set.

public final String

Returns:

the ResultSet's SQL cursor name
getCursorName
()

Implements java.sql.ResultSet.getCursorName.

Get the name of the SQL cursor used by this ResultSet.

public final Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDate.

Get the value of a column in the current row as a java.sql.Date object.

public Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the calendar to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object.

public Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(String
is the SQL name of the column
columnName
,
Calendar
the calendar to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object.

public final Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getDate.

Get the value of a column in the current row as a java.sql.Date object.

public final double

Returns:

the column value; if the value is SQL NULL, the result is 0
getDouble
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDouble.

Get the value of a column in the current row as a Java double.

public final double

Returns:

the column value; if the value is SQL NULL, the result is 0
getDouble
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getDouble.

Get the value of a column in the current row as a Java double.

protected DataValueDescriptor
getDVDforColumnToBeUpdated(int columnIndex, String updateMethodName)

public int
getFetchDirection()

Implements java.sql.ResultSet.getFetchDirection.

JDBC 2.0 Return the fetch direction for this result set.

public int
getFetchSize()

Implements java.sql.ResultSet.getFetchSize.

JDBC 2.0 Return the fetch size for this result set.

public final float

Returns:

the column value; if the value is SQL NULL, the result is 0
getFloat
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getFloat.

Get the value of a column in the current row as a Java float.

public final float

Returns:

the column value; if the value is SQL NULL, the result is 0
getFloat
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getFloat.

Get the value of a column in the current row as a Java float.

private String
public final int

Returns:

either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
getHoldability
()

Implements java.sql.ResultSet.getHoldability.

JDBC 4.0

Retrieves the holdability for this ResultSet object.

public final int

Returns:

the column value; if the value is SQL NULL, the result is 0
getInt
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getInt.

Get the value of a column in the current row as a Java int.

public final int

Returns:

the column value; if the value is SQL NULL, the result is 0
getInt
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getInt.

Get the value of a column in the current row as a Java int.

public int
getLength(int
column to access
columnIndex
)

Implements org.apache.derby.iapi.jdbc.EngineResultSet.getLength.

Return the length of the designated columnIndex data value.

public final long

Returns:

the column value; if the value is SQL NULL, the result is 0
getLong
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getLong.

Get the value of a column in the current row as a Java long.

public final long

Returns:

the column value; if the value is SQL NULL, the result is 0
getLong
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getLong.

Get the value of a column in the current row as a Java long.

private final int

Returns:

the maximum length of the column
getMaxColumnWidth
(int
the 1-based index of the column
columnIndex
)

Return the user-defined maximum size of the column.

public final ResultSetMetaData

Returns:

the description of a ResultSet's columns
getMetaData
()

Implements java.sql.ResultSet.getMetaData.

The number, types and properties of a ResultSet's columns are provided by the getMetaData method.

public Reader
getNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Reader
getNCharacterStream(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
columnName
)

Implements java.sql.ResultSet.getNCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public NClob
getNClob(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getNClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public NClob
getNClob(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
colName
)

Implements java.sql.ResultSet.getNClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public String
getNString(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public String
getNString(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
columnName
)

Implements java.sql.ResultSet.getNString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public final Object

Returns:

A java.lang.Object holding the column value.
getObject
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getObject.

Get the value of a column in the current row as a Java object.

public final Object

Returns:

A java.lang.Object holding the column value.
getObject
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getObject.

Get the value of a column in the current row as a Java object.

public Object

Returns:

an object representing the SQL value
getObject
(int
the first column is 1, the second is 2, ...
columnIndex
,
Map<String, Class<?>>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.ResultSet.getObject.

JDBC 2.0 Returns the value of column i as a Java object.

public Object

Returns:

an object representing the SQL value
getObject
(String
the column name
colName
,
Map<String, Class<?>>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.ResultSet.getObject.

JDBC 2.0 Returns the value of column i as a Java object.

public <T> T
getObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Class<T>
Class representing the Java data type to convert the designated column to.
type
)

Implements java.sql.ResultSet.getObject.

Retrieve the column as an object of the desired type.

public <T> T
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
columnName
,
Class<T>
Class representing the Java data type to convert the designated column to.
type
)

Implements java.sql.ResultSet.getObject.

Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.

protected ParameterValueSet

Returns:

null if we cannot figure out what parameter value set is currently using
getParameterValueSet
()

Try to see if we can fish the pvs out of the local statement.

public final Ref

Returns:

an object representing data of an SQL REF type
getRef
(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getRef.

JDBC 2.0 Get a REF(<structured-type>) column.

public final Ref

Returns:

an object representing data of an SQL REF type
getRef
(String
the column name
colName
)

Implements java.sql.ResultSet.getRef.

JDBC 2.0 Get a REF(<structured-type>) column.

public int

Returns:

the current row number, else return 0 if there is no current row
getRow
()

Implements java.sql.ResultSet.getRow.

JDBC 2.0

Determine the current row number.

public RowId
getRowId(int
the first column is 1, the second 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRowId.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public RowId
getRowId(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
columnName
)

Implements java.sql.ResultSet.getRowId.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public final short

Returns:

the column value; if the value is SQL NULL, the result is 0
getShort
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getShort.

Get the value of a column in the current row as a Java short.

public final short

Returns:

the column value; if the value is SQL NULL, the result is 0
getShort
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getShort.

Get the value of a column in the current row as a Java short.

protected String

Returns:

null if we cannot figure out what SQL Statement is currently executing
getSQLText
()

Try to see if we can fish the SQL Statement out of the local statement.

public SQLXML
getSQLXML(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getSQLXML.

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public SQLXML
getSQLXML(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
colName
)

Implements java.sql.ResultSet.getSQLXML.

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public final Statement

Returns:

the Statment that produced the result set, or null if the result was produced some other way.
getStatement
()

Implements java.sql.ResultSet.getStatement.

JDBC 2.0 Return the Statement that produced the ResultSet.

public final String

Returns:

the column value; if the value is SQL NULL, the result is null
getString
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getString.

Get the value of a column in the current row as a Java String.

public final String

Returns:

the column value; if the value is SQL NULL, the result is null
getString
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getString.

Get the value of a column in the current row as a Java String.

public final Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTime.

Get the value of a column in the current row as a java.sql.Time object.

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the calendar to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Time object.

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(String
is the SQL name of the column
columnName
,
Calendar
the calendar to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Time object.

public final Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getTime.

Get the value of a column in the current row as a java.sql.Time object.

public final Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

Get the value of a column in the current row as a java.sql.Timestamp object.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(String
is the SQL name of the column
columnName
,
Calendar
the calendar to use in constructing the timestamp
cal
)

Implements java.sql.ResultSet.getTimestamp.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the calendar to use in constructing the timestamp
cal
)

Implements java.sql.ResultSet.getTimestamp.

JDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object.

public final Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(String
is the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getTimestamp.

Get the value of a column in the current row as a java.sql.Timestamp object.

public int

Returns:

TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, or TYPE_SCROLL_SENSITIVE
getType
()

Implements java.sql.ResultSet.getType.

JDBC 2.0 Return the type of this result set.

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

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated

JDBC 2.0 Deprecated in JDBC 2.0, not supported by JCC.

public final 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
columnName
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated

Deprecated in JDBC 2.0, not supported by JCC.

public URL

Returns:

the column value as a java.net.URL object, if the value is SQL NULL, the value returned is null in the Java programming language
getURL
(int
- the first column is 1, the second is 2
columnIndex
)

Implements java.sql.ResultSet.getURL.

JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

public URL

Returns:

the column value as a java.net.URL object, if the value is SQL NULL, the value returned is null in the Java programming language
getURL
(String
- the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getURL.

JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

public final SQLWarning

Returns:

the first SQLWarning or null
getWarnings
()

Implements java.sql.ResultSet.getWarnings.

The first warning reported by calls on this ResultSet is returned.

private void
initializeUpdateRowModifiers()

Initializes the currentRowHasBeenUpdated and columnGotUpdated fields

public void
insertRow()

Implements java.sql.ResultSet.insertRow.

JDBC 2.0 Insert the contents of the insert row into the result set and the database.

public boolean

Returns:

true if after the last row, false otherwise. Returns false when the result set contains no rows.
isAfterLast
()

Implements java.sql.ResultSet.isAfterLast.

JDBC 2.0

Determine if the cursor is after the last row in the result set.

public boolean

Returns:

true if before the first row, false otherwise. Returns false when the result set contains no rows.
isBeforeFirst
()

Implements java.sql.ResultSet.isBeforeFirst.

JDBC 2.0

Determine if the cursor is before the first row in the result set.

public final boolean

Returns:

true if the ResultSet is closed, false otherwise
isClosed
()

Implements java.sql.ResultSet.isClosed.

JDBC 4.0

Checks whether this ResultSet object has been closed, either automatically or because close() has been called.

public boolean

Returns:

true if on the first row, false otherwise.
isFirst
()

Implements java.sql.ResultSet.isFirst.

JDBC 2.0

Determine if the cursor is on the first row of the result set.

public final boolean
isForUpdate()

Implements org.apache.derby.iapi.jdbc.EngineResultSet.isForUpdate.

Is this result set from a select for update statement?

public boolean

Returns:

true if on the last row, false otherwise.
isLast
()

Implements java.sql.ResultSet.isLast.

JDBC 2.0

Determine if the cursor is on the last row of the result set.

private static boolean
isMaxFieldSizeType(int colType)

public boolean
isNull(int
Column position
columnIndex
)

Implements org.apache.derby.iapi.jdbc.EngineResultSet.isNull.

Is the designated columnIndex a null data value?

public boolean

Returns:

true if this implements the interface or directly or indirectly wraps an object that does.
isWrapperFor
(Class<?>
a Class defining an interface.
interfaces
)

Implements java.sql.Wrapper.isWrapperFor.

Returns false unless interfaces is implemented

public boolean

Returns:

true if on a valid row, false if no rows in the result set.
last
()

Implements java.sql.ResultSet.last.

JDBC 2.0

Moves to the last row in the result set.

private void
markClosed()

Mark this ResultSet as closed and trigger the closing of the Statement if necessary.

private SQLException
mismatchException(String targetTypeName, int columnIndex)

protected boolean
movePosition(int position, String positionText)

protected boolean
movePosition(int position, int row, String positionText)

public void
moveToCurrentRow()

Implements java.sql.ResultSet.moveToCurrentRow.

JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row.

public void
moveToInsertRow()

Implements java.sql.ResultSet.moveToInsertRow.

JDBC 2.0 Move to the insert row.

public boolean

Returns:

true if the new current row is valid; false if there are no more rows
next
()

Implements java.sql.ResultSet.next.

A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.

If an input stream from the previous row is open, it is implicitly closed.

pack-priv static final SQLException
noStateChangeException(Throwable thrownException)

An exception on many method calls to JDBC objects does not change the state of the transaction or statement, or even the underlying object.

public boolean

Returns:

true if on a valid row, false if off the result set.
previous
()

Implements java.sql.ResultSet.previous.

JDBC 2.0

Moves to the previous row in the result set.

public void
refreshRow()

Implements java.sql.ResultSet.refreshRow.

JDBC 2.0 Refresh the value of the current row with its current value in the database.

public boolean

Returns:

true if on a row, false otherwise.
relative
(int
an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
row
)

Implements java.sql.ResultSet.relative.

JDBC 2.0

Moves a relative number of rows, either positive or negative.

public boolean

Returns:

true if deleted and deletes are detected
rowDeleted
()

Implements java.sql.ResultSet.rowDeleted.

JDBC 2.0 Determine if this row has been deleted.

public boolean

Returns:

true if inserted and inserts are detected
rowInserted
()

Implements java.sql.ResultSet.rowInserted.

JDBC 2.0 Determine if the current row has been inserted.

public boolean

Returns:

true if the row has been visibly updated by the owner or another, and updates are detected
rowUpdated
()

Implements java.sql.ResultSet.rowUpdated.

JDBC 2.0 Determine if the current row has been updated.

public final void
setApplicationStatement(Statement applicationStmt)

Set the application Statement object that created this ResultSet.

pack-priv void
setDynamicResultSet(EmbedStatement owningStmt)

A dynamic result was created in a procedure by a nested connection.

public void
setFetchDirection(int
an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
direction
)

Implements java.sql.ResultSet.setFetchDirection.

JDBC 2.0 Give a hint as to the direction in which the rows in this result set will be processed.

public static void
setFetchedRowBase(long newBase)

Debug method used to test the setLargeMaxRows() method added by JDBC 4.2.

public void
setFetchSize(int
the number of rows to fetch
rows
)

Implements java.sql.ResultSet.setFetchSize.

JDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set.

public <T> T

Returns:

an object that implements the interface
unwrap
(Class<T>
a Class defining an interface
interfaces
)

Implements java.sql.Wrapper.unwrap.

Returns this if this class implements the interface

public void
updateArray(int
- the first column is 1, the second is 2
columnIndex
,
Array
- the new column value
x
)

Implements java.sql.ResultSet.updateArray.

JDBC 3.0 Updates the designated column with a java.sql.Array value.

public void
updateArray(String
- the SQL name of the column
columnName
,
Array
- the new column value
x
)

Implements java.sql.ResultSet.updateArray.

JDBC 3.0 Updates the designated column with a java.sql.Array value.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Update a column with an ascii stream value.

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

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with a character stream value.

public void
updateAsciiStream(String
the name of the column
columnName
,
InputStream
the new column value
x
,
int
of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

JDBC 2.0 Update a column with an ascii stream value.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

JDBC 2.0 Update a column with an ascii stream value.

public void
updateAsciiStream(String
the name of the column
columnName
,
InputStream
the new column value
x
,
long
of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

JDBC 4.0 Update a column with an ascii stream value.

public void
updateAsciiStream(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
columnName
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with a character stream value.

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

Implements java.sql.ResultSet.updateBigDecimal.

Updates the designated column with a java.math.BigDecimal value.

public void
updateBigDecimal(String
the name of the column
columnName
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

JDBC 2.0 Update a column with a BigDecimal value.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Update a column with a binary stream value.

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

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBinaryStream(String
the name of the column
columnName
,
InputStream
the new column value
x
,
int
of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

JDBC 2.0 Update a column with a binary stream value.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

JDBC 2.0 Update a column with a binary stream value.

public void
updateBinaryStream(String
the name of the column
columnName
,
InputStream
the new column value
x
,
long
of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

JDBC 4.0 Update a column with a binary stream value.

public void
updateBinaryStream(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
columnName
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

private void
updateBinaryStreamInternal(int
the 1-based index of the parameter to set.
columnIndex
,
InputStream
the data.
x
,
final boolean
tells whether we know the length of the data or not.
lengthLess
,
long
the length of the data. Ignored if lengthLess is true.
length
,
String
the name of the method calling us. Used in error messages.
updateMethodName
)

Set the given binary stream for the specified parameter.

public void
updateBlob(int
- the first column is 1, the second is 2
columnIndex
,
Blob
- the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

JDBC 3.0 Updates the designated column with a java.sql.Blob value.

public void
updateBlob(String
- the SQL name of the column
columnName
,
Blob
- the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

JDBC 3.0 Updates the designated column with a java.sql.Blob value.

public void
updateBlob(int
- the first column is 1, the second is 2
columnIndex
,
InputStream
- the new column value
x
,
long
- the length of the Blob datatype
length
)

Implements java.sql.ResultSet.updateBlob.

JDBC 4.0 Updates the designated column with a java.sql.Blob value.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
an object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

public void
updateBlob(String
- the name of the column to be updated
columnName
,
InputStream
- the new column value
x
,
long
- the length of the Blob datatype
length
)

Implements java.sql.ResultSet.updateBlob.

JDBC 4.0 Updates the designated column with a java.sql.Blob value.

public void
updateBlob(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
columnName
,
InputStream
an object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

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

Implements java.sql.ResultSet.updateBoolean.

JDBC 2.0 Update a column with a boolean value.

public void
updateBoolean(String
the name of the column
columnName
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

JDBC 2.0 Update a column with a boolean value.

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

Implements java.sql.ResultSet.updateByte.

JDBC 2.0 Update a column with a byte value.

public void
updateByte(String
the name of the column
columnName
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

JDBC 2.0 Update a column with a byte value.

public void
updateBytes(int
the first column is 1, the second is 2, ...
columnIndex
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

JDBC 2.0 Update a column with a byte array value.

public void
updateBytes(String
the name of the column
columnName
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

JDBC 2.0 Update a column with a byte array value.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

JDBC 4.0 Update a column with a character stream value.

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

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateCharacterStream(String
the name of the column
columnName
,
Reader
the new column value
reader
,
int
length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

JDBC 2.0 Update a column with a character stream value.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

JDBC 2.0 Update a column with a character stream value.

public void
updateCharacterStream(String
the name of the column
columnName
,
Reader
the new column value
reader
,
long
length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

JDBC 4.0 Update a column with a character stream value.

public void
updateCharacterStream(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
columnName
,
Reader
the new column value
reader
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

private void
updateCharacterStreamInternal(int
the 1-based index of the parameter to set.
columnIndex
,
Reader
the data.
reader
,
final boolean
tells whether we know the length of the data or not.
lengthLess
,
long
the length of the data. Ignored if lengthLess is true.
length
,
String updateMethodName)

Set the given character stream for the specified parameter.

public void
updateClob(int
- the first column is 1, the second is 2
columnIndex
,
Clob
- the new column value
x
)

Implements java.sql.ResultSet.updateClob.

JDBC 3.0 Updates the designated column with a java.sql.Clob value.

public void
updateClob(String
- the SQL name of the column
columnName
,
Clob
- the new column value
x
)

Implements java.sql.ResultSet.updateClob.

JDBC 3.0 Updates the designated column with a java.sql.Clob value.

public void
updateClob(int
- the first column is 1, the second is 2
columnIndex
,
Reader
- the new column value
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

JDBC 4.0 Updates the designated column with a java.sql.Clob value.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
an object that contains the data to set the parameter value to
x
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

public void
updateClob(String
- the name of the Clob column
columnName
,
Reader
- the new column value
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

JDBC 4.0 Updates the designated column with a java.sql.Clob value.

public void
updateClob(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
columnName
,
Reader
an object that contains the data to set the parameter value to
x
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

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

Implements java.sql.ResultSet.updateDate.

JDBC 2.0 Update a column with a Date value.

public void
updateDate(String
the name of the column
columnName
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

JDBC 2.0 Update a column with a Date value.

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

Implements java.sql.ResultSet.updateDouble.

JDBC 2.0 Update a column with a Double value.

public void
updateDouble(String
the name of the column
columnName
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

JDBC 2.0 Update a column with a double value.

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

Implements java.sql.ResultSet.updateFloat.

JDBC 2.0 Update a column with a float value.

public void
updateFloat(String
the name of the column
columnName
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

JDBC 2.0 Update a column with a float value.

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

Implements java.sql.ResultSet.updateInt.

JDBC 2.0 Update a column with an integer value.

public void
updateInt(String
the name of the column
columnName
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

JDBC 2.0 Update a column with an integer value.

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

Implements java.sql.ResultSet.updateLong.

JDBC 2.0 Update a column with a long value.

public void
updateLong(String
the name of the column
columnName
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

JDBC 2.0 Update a column with a long value.

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

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(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
columnName
,
Reader
the java.io.Reader object containing the new column value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNCharacterStream(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
columnName
,
Reader
the java.io.Reader object containing the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
NClob
the value for the column to be updated
nClob
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.

public void
updateNClob(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
columnName
,
NClob
the value for the column to be updated
nClob
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(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
columnName
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object.

public void
updateNClob(int
- the first column is 1, the second is 2
columnIndex
,
Reader
- the new column value
x
,
long
- the length of the stream
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(String
- the Name of the column to be updated
columnName
,
Reader
- the new column value
x
,
long
- the length of the stream
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNString(int
the first column is 1, the second 2, ...
columnIndex
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String value.

public void
updateNString(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
columnName
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String value.

public void
updateNull(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.updateNull.

JDBC 2.0 Give a nullable column a null value.

public void
updateNull(String
the name of the column
columnName
)

Implements java.sql.ResultSet.updateNull.

JDBC 2.0 Update a column with a null value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
,
int
For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

JDBC 2.0 Update a column with an Object value.

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

Implements java.sql.ResultSet.updateObject.

JDBC 2.0 Update a column with an Object value.

public void
updateObject(String
the name of the column
columnName
,
Object
the new column value
x
,
int
For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

JDBC 2.0 Update a column with an Object value.

public void
updateObject(String
the name of the column
columnName
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

JDBC 2.0 Update a column with an Object value.

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.

JDBC 3.0 Updates the designated column with a java.sql.Ref value.

public void
updateRef(String
- the SQL name of the column
columnName
,
Ref
- the new column value
x
)

Implements java.sql.ResultSet.updateRef.

JDBC 3.0 Updates the designated column with a java.sql.Ref value.

public void
updateRow()

Implements java.sql.ResultSet.updateRow.

JDBC 2.0 Update the underlying database with the new contents of the current row.

public void
updateRowId(int
the first column is 1, the second 2, ...
columnIndex
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

public void
updateRowId(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
columnName
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

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

Implements java.sql.ResultSet.updateShort.

JDBC 2.0 Update a column with a short value.

public void
updateShort(String
the name of the column
columnName
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

JDBC 2.0 Update a column with a short value.

public void
updateSQLXML(int
the first column is 1, the second 2, ...
columnIndex
,
SQLXML
the value for the column to be updated
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

public void
updateSQLXML(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
columnName
,
SQLXML
the column value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

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

Implements java.sql.ResultSet.updateString.

JDBC 2.0 Update a column with a String value.

public void
updateString(String
the name of the column
columnName
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

JDBC 2.0 Update a column with a String value.

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

Implements java.sql.ResultSet.updateTime.

JDBC 2.0 Update a column with a Time value.

public void
updateTime(String
the name of the column
columnName
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

JDBC 2.0 Update a column with a Time value.

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

Implements java.sql.ResultSet.updateTimestamp.

JDBC 2.0 Update a column with a Timestamp value.

public void
updateTimestamp(String
the name of the column
columnName
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

JDBC 2.0 Update a column with a Timestamp value.

pack-priv final void
useStreamOrLOB(int
1-based column index
columnIndex
)

Mark a column as already having a stream or LOB accessed from it.

public final boolean

Returns:

true if last column read was SQL NULL
wasNull
()

Implements java.sql.ResultSet.wasNull.

A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.

Inherited from org.apache.derby.impl.jdbc.ConnectionChild:
commitIfAutoCommitcommitIfNeededgetCalgetConnectionSynchronizationgetEmbedConnectiongetLanguageConnectionContextgetLCChandleExceptionneedCommitnewSQLExceptionrestoreContextStackrestoreIntrFlagIfSeensetupContextStack