Top Inners Fields Constructors Methods
org.postgresql.jdbc

public Class PgResultSet

extends Object
implements ResultSet, PGRefCursorResultSet
Class Inheritance
All Implemented Interfaces
org.postgresql.PGRefCursorResultSet, java.sql.ResultSet, java.lang.AutoCloseable, java.sql.Wrapper
Static Imports
org.postgresql.util.internal.Nullness.castNonNull

References Deprecated

PGRefCursorResultSet is deprecated or references (maybe indirectly) at least one deprecated element.

See corresponding docs for further information.

Nested and Inner Type Summary

Modifier and TypeClass and Description
public class
pack-priv static class
private class

Field Summary

Modifier and TypeField and Description
protected boolean
private static final BigInteger
private static final BigInteger
private @Nullable Map<String, Integer>
protected final BaseConnection
protected int
protected @Nullable ResultCursor
private @Nullable TimeZone
private @Nullable PreparedStatement
private boolean
private static final NumberFormatException
FAST_NUMBER_FAILED

A dummy exception thrown when fast byte[] to number parsing fails and no value can be returned.

private int
protected int
protected final Field[]
private static final BigInteger
private static final BigInteger
protected int
private static final LocalDate
private final ResourceLock
private static final double
private static final float
private static final double
private static final float
private static final BigInteger
private static final BigInteger
protected final int
protected final int
protected boolean
private String
protected final @Nullable Query
private @Nullable List<PgResultSet.PrimaryKey>
private @Nullable String
private final int
private final int
private @Nullable Tuple
protected int
protected @Nullable List<Tuple>
private @Nullable ResultSetMetaData
private static final BigInteger
private static final BigInteger
private boolean
protected final BaseStatement
private @Nullable String
protected @Nullable Tuple
private @Nullable TimestampUtils
private boolean
private @Nullable HashMap<String, Object>
private boolean
protected @Nullable SQLWarning
protected boolean
wasNullFlag

True if the last obtained column value was SQL NULL as specified by wasNull.

Constructor Summary

AccessConstructor and Description
pack-priv
PgResultSet(@Nullable Query originalQuery, BaseStatement statement, Field[] fields, List<Tuple> tuples, @Nullable ResultCursor cursor, int maxRows, int maxFieldSize, int rsType, int rsConcurrency, int rsHoldability, boolean adaptiveFetch)

Method Summary

Modifier and TypeMethod and Description
public boolean
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
index
)

Implements java.sql.ResultSet.absolute.

Moves the cursor to the given row number in this ResultSet object.

pack-priv void
addRows(List<Tuple> tuples)

Used to add rows to an already existing ResultSet that exactly match the existing rows.

protected void
public void
afterLast()

Implements java.sql.ResultSet.afterLast.

Moves the cursor to the end of this ResultSet object, just after the last row.

public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

Moves the cursor to the front of this ResultSet object, just before the first row.

public void
cancelRowUpdates()

Implements java.sql.ResultSet.cancelRowUpdates.

Cancels the updates made to the current row in this ResultSet object.

protected void
protected void
private void
private void
private void
clearRowBuffer(boolean copyCurrentRow)

public void
clearWarnings()

Implements java.sql.ResultSet.clearWarnings.

Clears all warnings reported on this ResultSet object.

public void
close()

Implements java.sql.ResultSet.close.

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

protected void
private void
closeRefCursor()

Closes <unnamed portal 1> if no more fetch calls expected (cursor==null)

public static Map<String, Integer>
createColumnNameIndexMap(Field[] fields, boolean isSanitiserDisabled)

protected ResultSetMetaData
public void
deleteRow()

Implements java.sql.ResultSet.deleteRow.

Deletes the current row from this ResultSet object and from the underlying database.

public @NonNegative int
findColumn(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.findColumn.

Maps the given ResultSet column label to its ResultSet column index.

private @NonNegative int
findColumnIndex(String columnName)

public boolean
first()

Implements java.sql.ResultSet.first.

Moves the cursor to the first row in this ResultSet object.

public boolean

Returns:

state of adaptive fetch (turned on or off)
getAdaptiveFetch
()

Get state of adaptive fetch for resultSet.

public @Nullable Array
getArray(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.getArray.

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

public @Nullable Array
getArray(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getArray.

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

public @Nullable InputStream
getAsciiStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public @Nullable InputStream
getAsciiStream(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.getAsciiStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public @Nullable BigDecimal
getBigDecimal(@Positive 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 @Nullable 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.

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

public @Nullable BigDecimal
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

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

public @Nullable 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
,
int
the number of digits to the right of the decimal point
scale
)

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 in the Java programming language.

public @Nullable InputStream
getBinaryStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public @Nullable InputStream
getBinaryStream(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.getBinaryStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public @Nullable Blob
getBlob(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.getBlob.

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

public @Nullable Blob
getBlob(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getBlob.

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

public boolean

Returns:

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

Implements java.sql.ResultSet.getBoolean.

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

public boolean
getBoolean(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.getBoolean.

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

public byte
getByte(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getByte.

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

public byte
getByte(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.getByte.

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

public @Nullable byte[]
getBytes(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBytes.

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

public @Nullable byte[]
getBytes(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.getBytes.

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

public @Nullable 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.

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

public @Nullable Reader
getCharacterStream(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getCharacterStream.

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

public @Nullable Clob
getClob(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.getClob.

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

public @Nullable Clob
getClob(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getClob.

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

public int

Returns:

OID of a field
getColumnOID
(int
field index
field
)

Returns the OID of a field.

public int
getConcurrency()

Implements java.sql.ResultSet.getConcurrency.

Retrieves the concurrency mode of this ResultSet object.

public @Nullable String
getCursorName()

Implements java.sql.ResultSet.getCursorName.

Retrieves the name of the SQL cursor used by this ResultSet object.

public @Nullable Date
getDate(int
the first column is 1, the second is 2, ...
i
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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

public @Nullable Date
getDate(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
c
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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

public @Nullable Date
getDate(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDate.

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

public @Nullable Date
getDate(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.getDate.

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

private Calendar
public double
getDouble(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDouble.

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

public double
getDouble(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.getDouble.

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

private BigDecimal

Returns:

The parsed number.
getFastBigDecimal
(byte[]
integer represented as a sequence of ASCII bytes
bytes
)

Optimised byte[] to number parser.

public int
getFetchDirection()

Implements java.sql.ResultSet.getFetchDirection.

Retrieves the fetch direction for this ResultSet object.

public int
getFetchSize()

Implements java.sql.ResultSet.getFetchSize.

Retrieves the fetch size for this ResultSet object.

public @Nullable String

Returns:

numeric-parsable representation of money string literal
getFixedString
(int
column position (1-based)
col
)

This is used to fix get*() methods on Money fields.

public float
getFloat(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getFloat.

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

public float
getFloat(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.getFloat.

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

public int
getHoldability()

Implements java.sql.ResultSet.getHoldability.

Retrieves the holdability of this ResultSet object

public int
getInt(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getInt.

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

public int
getInt(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.getInt.

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

public int

Returns:

fetch size used during last fetch.
getLastUsedFetchSize
()

Get fetch size used during last fetch.

private @Nullable LocalDate
getLocalDate(int i)

private @Nullable LocalDateTime
private @Nullable LocalTime
getLocalTime(int i)

public long
getLong(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getLong.

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

public long
getLong(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.getLong.

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

public ResultSetMetaData
getMetaData()

Implements java.sql.ResultSet.getMetaData.

Retrieves the number, types and properties of this ResultSet object's columns.

public @Nullable Reader
getNCharacterStream(@Positive 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 @Nullable 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 @Nullable NClob
getNClob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

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 @Nullable 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
columnName
)

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 @Nullable String
getNString(@Positive 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 @Nullable 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.

private @Nullable Number
getNumeric(int columnIndex, int scale, boolean allowNaN)

public @Nullable Object
getObject(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getObject.

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public @Nullable 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
columnName
)

Implements java.sql.ResultSet.getObject.

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public <T> @Nullable T
getObject(@Positive 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.

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.

public <T> @Nullable 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
columnLabel
,
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.

public @Nullable 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
s
,
@Nullable 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.

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

public @Nullable Object
getObject(@Positive int
the first column is 1, the second is 2, ...
i
,
@Nullable 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.

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

public @Nullable Object
getObjectImpl(String columnName, @Nullable Map<String, Class<?>> map)

public @Nullable Object
private @Nullable OffsetDateTime
private @Nullable OffsetTime
public BaseStatement
protected String
getPGType(@Positive int column)

protected @Nullable byte[]

Returns:

raw value or null
getRawValue
(@Positive int
The column number to check. Range starts from 1.
column
)

Checks that the result set is not closed, it's positioned on a valid row and that the given column number is valid.

public @Nullable 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
columnName
)

Implements java.sql.ResultSet.getRef.

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

public @Nullable Ref
getRef(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getRef.

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

public @Nullable String
public int
getRow()

Implements java.sql.ResultSet.getRow.

Retrieves the current row number.

public @Nullable RowId
getRowId(@Positive 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 @Nullable 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 short
getShort(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getShort.

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

public short
getShort(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.getShort.

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

protected int
getSQLType(@Positive int column)

public @Nullable SQLXML
getSQLXML(@Positive 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 @Nullable 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
columnName
)

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 Statement
getStatement()

Implements java.sql.ResultSet.getStatement.

Retrieves the Statement object that produced this ResultSet object.

public @Nullable String
getString(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getString.

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

public @Nullable String
getString(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.getString.

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

public @Nullable Time
getTime(int
the first column is 1, the second is 2, ...
i
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

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

public @Nullable Time
getTime(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
c
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

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

public @Nullable Time
getTime(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTime.

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

public @Nullable Time
getTime(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.getTime.

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

public @Nullable Timestamp
getTimestamp(int
the first column is 1, the second is 2, ...
i
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the timestamp
cal
)

Implements java.sql.ResultSet.getTimestamp.

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

public @Nullable Timestamp
getTimestamp(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
c
,
@Nullable Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTimestamp.

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

public @Nullable Timestamp
getTimestamp(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

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

public @Nullable Timestamp
getTimestamp(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.getTimestamp.

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

private TimestampUtils
public int
getType()

Implements java.sql.ResultSet.getType.

Retrieves the type of this ResultSet object.

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

Implements java.sql.ResultSet.getUnicodeStream.

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters.

public @Nullable 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.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters.

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

Implements java.sql.ResultSet.getURL.

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

Implements java.sql.ResultSet.getURL.

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.

protected Object
protected Object
getUUID(byte[] data)

public @Nullable SQLWarning
getWarnings()

Implements java.sql.ResultSet.getWarnings.

Retrieves the first warning reported by calls on this ResultSet object.

private void
private void
public void
insertRow()

Implements java.sql.ResultSet.insertRow.

Inserts the contents of the insert row into this ResultSet object and into the database.

protected @Nullable Object
internalGetObject(@Positive int columnIndex, Field field)

public boolean
isAfterLast()

Implements java.sql.ResultSet.isAfterLast.

Retrieves whether the cursor is after the last row in this ResultSet object.

public boolean
isBeforeFirst()

Implements java.sql.ResultSet.isBeforeFirst.

Retrieves whether the cursor is before the first row in this ResultSet object.

protected boolean

Returns:

True if the column is in binary format.
isBinary
(@Positive int
The column to check. Range starts from 1.
column
)

Returns true if the value of the given column is in binary format.

public boolean
isClosed()

Implements java.sql.ResultSet.isClosed.

Retrieves whether this ResultSet object has been closed.

private boolean
isColumnTrimmable(@Positive int columnIndex)

public boolean
isFirst()

Implements java.sql.ResultSet.isFirst.

Retrieves whether the cursor is on the first row of this ResultSet object.

public boolean
isLast()

Implements java.sql.ResultSet.isLast.

Retrieves whether the cursor is on the last row of this ResultSet object

Note

Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

protected boolean
pack-priv boolean
isUpdateable()

Is this ResultSet updateable?

public boolean
isWrapperFor(Class<?>
a Class defining an interface.
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

public boolean
last()

Implements java.sql.ResultSet.last.

Moves the cursor to the last row in this ResultSet object.

protected Array
makeArray(int oid, byte[] value)

protected Array
makeArray(int oid, String value)

protected Blob
makeBlob(long oid)

protected Clob
makeClob(long oid)

public void
moveToCurrentRow()

Implements java.sql.ResultSet.moveToCurrentRow.

Moves the cursor to the remembered cursor position, usually the current row.

public void
moveToInsertRow()

Implements java.sql.ResultSet.moveToInsertRow.

Moves the cursor to the insert row.

public boolean
next()

Implements java.sql.ResultSet.next.

Moves the cursor forward one row from its current position.

private void
public boolean
previous()

Implements java.sql.ResultSet.previous.

Moves the cursor to the previous row in this ResultSet object.

public static @Nullable String[]

Returns:

String array with element zero always being the tablename and element 1 the schema name which may be a zero length string.
quotelessTableName
(String
string that we are trying to crack. Test cases:

                Table: table
                                ()

                "Table": Table
                                ()

                Schema.Table:
                                table (schema)

                                "Schema"."Table": Table
                                                (Schema)

                                "Schema"."Dot.Table": Dot.Table
                                                (Schema)

                                Schema."Dot.Table": Dot.Table
                                                (schema)

       
fullname
)

Cracks out the table name and schema (if it exists) from a fully qualified table name.

private double

Returns:

The value as double.
readDoubleValue
(byte[]
The bytes of the numeric field.
bytes
,
int
The oid of the field.
oid
,
String
The target type. Used for error reporting.
targetType
)

Converts any numeric binary field to double value.

private long

Returns:

The value as long.
readLongValue
(byte[]
The bytes of the numeric field.
bytes
,
int
The oid of the field.
oid
,
long
the minimum value allowed.
minVal
,
long
the maximum value allowed.
maxVal
,
String
The target type. Used for error reporting.
targetType
)

Converts any numeric binary field to long value.

public void
refreshRow()

Implements java.sql.ResultSet.refreshRow.

Refreshes the current row with its most recent value in the database.

public boolean
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
rows
)

Implements java.sql.ResultSet.relative.

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

public boolean
rowDeleted()

Implements java.sql.ResultSet.rowDeleted.

Retrieves whether a row has been deleted.

public boolean
rowInserted()

Implements java.sql.ResultSet.rowInserted.

Retrieves whether the current row has had an insertion.

public boolean
rowUpdated()

Implements java.sql.ResultSet.rowUpdated.

Retrieves whether the current row has been updated.

private BigDecimal
scaleBigDecimal(BigDecimal val, int scale)

public void
setAdaptiveFetch(boolean
desired state of adaptive fetch.
adaptiveFetch
)

Turn on/off adaptive fetch for ResultSet.

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.

Gives a hint as to the direction in which the rows in this ResultSet object will be processed.

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

Implements java.sql.ResultSet.setFetchSize.

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.

private void
setRefCursor(String refCursorName)

private void
setRowBufferColumn(Tuple rowBuffer, int columnIndex, @Nullable Object valueObject)

public static @PolyNull BigDecimal
public @PolyNull BigDecimal
public static double
public static float
public static int
public static long
public static short
private byte[]
trimBytes(@Positive int columnIndex, byte[] bytes)

private @PolyNull String
private String
trimString(@Positive int columnIndex, String string)

public <T> T
unwrap(Class<T>
A Class defining an interface that the result must implement.
iface
)

Implements java.sql.Wrapper.unwrap.

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public void
updateArray(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Array
the new column value
x
)

Implements java.sql.ResultSet.updateArray.

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

public void
updateArray(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
,
@Nullable Array
the new column value
x
)

Implements java.sql.ResultSet.updateArray.

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

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

Implements java.sql.ResultSet.updateAsciiStream.

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

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
,
@Nullable InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

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

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

Implements java.sql.ResultSet.updateAsciiStream.

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

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
,
@Nullable InputStream
the new column value
inputStream
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

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

public void
updateAsciiStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable InputStream
the new column value
inputStream
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated 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
,
@Nullable InputStream
the new column value
inputStream
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

public void
updateBigDecimal(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable 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 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
,
@Nullable BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

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

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

Implements java.sql.ResultSet.updateBinaryStream.

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

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
,
@Nullable InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

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

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

Implements java.sql.ResultSet.updateBinaryStream.

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

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
,
@Nullable InputStream
the new column value
inputStream
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

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

public void
updateBinaryStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable InputStream
the new column value
inputStream
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated 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
,
@Nullable InputStream
the new column value
inputStream
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBlob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Blob
the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

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
,
@Nullable Blob
the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

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

public void
updateBlob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

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
,
@Nullable InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

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
,
@Nullable InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

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

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean value.

public void
updateBoolean(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
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean value.

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

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte value.

public void
updateByte(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
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte value.

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

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array value.

public void
updateBytes(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
,
@Nullable byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array value.

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

Implements java.sql.ResultSet.updateCharacterStream.

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

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
,
@Nullable Reader
the java.io.Reader object containing the new column value
reader
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

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

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

Implements java.sql.ResultSet.updateCharacterStream.

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

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
,
@Nullable Reader
the java.io.Reader object containing the new column value
reader
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

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

public void
updateCharacterStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Reader
the new column value
reader
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated 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
,
@Nullable Reader
the java.io.Reader object containing the new column value
reader
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateClob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Clob
the new column value
x
)

Implements java.sql.ResultSet.updateClob.

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
,
@Nullable Clob
the new column value
x
)

Implements java.sql.ResultSet.updateClob.

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

public void
updateClob(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

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

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
,
@Nullable Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

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

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

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

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
,
@Nullable Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

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

Implements java.sql.ResultSet.updateDate.

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

public void
updateDate(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
,
@Nullable Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

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

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

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double value.

public void
updateDouble(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
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double value.

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

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float value.

public void
updateFloat(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
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float value.

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

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int value.

public void
updateInt(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
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int value.

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

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long value.

public void
updateLong(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
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long value.

public void
updateNCharacterStream(@Positive int columnIndex, @Nullable Reader x, int length)

public void
updateNCharacterStream(String columnName, @Nullable Reader x, int length)

public void
updateNCharacterStream(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Reader
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
,
@Nullable 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(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable 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
,
@Nullable 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(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable 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
,
@Nullable 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(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable 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
,
@Nullable 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(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
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 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
,
@Nullable Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
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(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable 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
,
@Nullable 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(@Positive int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.updateNull.

Updates the designated column with a null value.

public void
updateNull(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.updateNull.

Updates the designated column with a null value.

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

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(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
,
@Nullable Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(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
,
@Nullable Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(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
,
@Nullable Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(@Positive int
the first column is 1, the second is 2, ...
columnIndex
,
@Nullable Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(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
,
@Nullable Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

private void
updateQueryInsideAdaptiveFetchCache(boolean
new state of adaptive fetch
newAdaptiveFetch
)

Update adaptive fetch cache during changing state of adaptive fetch inside ResultSet.

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

Implements java.sql.ResultSet.updateRef.

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

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
columnName
,
@Nullable Ref
the new column value
x
)

Implements java.sql.ResultSet.updateRef.

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

public void
updateRow()

Implements java.sql.ResultSet.updateRow.

Updates the underlying database with the new contents of the current row of this ResultSet object.

private void
updateRowBuffer(@Nullable PreparedStatement insertStatement, Tuple rowBuffer, HashMap<String, Object> updateValues)

public void
updateRowId(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable 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
,
@Nullable RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

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

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short value.

public void
updateShort(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
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short value.

public void
updateSQLXML(@Positive int
the first column is 1, the second 2, ...
columnIndex
,
@Nullable 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
,
@Nullable SQLXML
the column value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

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

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

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String value.

public void
updateString(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
,
@Nullable String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String value.

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

Implements java.sql.ResultSet.updateTime.

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

public void
updateTime(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
,
@Nullable Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

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

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

Implements java.sql.ResultSet.updateTimestamp.

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

public void
updateTimestamp(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
,
@Nullable Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

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

protected void
updateValue(@Positive int columnIndex, @Nullable Object value)

protected PgResultSet

Returns:

PgResultSet
upperCaseFieldLabels
()
References Deprecated PgResultSet is deprecated or references (maybe indirectly) at least one deprecated element.

This is here to be used by metadata functions to make all column labels upper case.

public boolean
wasNull()

Implements java.sql.ResultSet.wasNull.

Reports whether the last column read had a value of SQL NULL.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait