References Deprecated
PGRefCursorResultSet is deprecated or references (maybe indirectly) at least one deprecated element.
See corresponding docs for further information.
| Modifier and Type | Class and Description |
|---|---|
| public class | |
| pack-priv static class | |
| private class |
| Modifier and Type | Field and Description |
|---|---|
| protected boolean | |
| private static final BigInteger | |
| private static final BigInteger | |
| private @Nullable Map | |
| 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 | |
| private @Nullable String | |
| private final int | |
| private final int | |
| private @Nullable Tuple | |
| protected int | |
| protected @Nullable List | |
| 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 | |
| private boolean | |
| protected @Nullable SQLWarning | |
| protected boolean | wasNullFlag
True if the last obtained column value was SQL NULL as specified by |
| Access | Constructor 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)
|
| Modifier and Type | Method 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. Moves the cursor to the given row number in
this |
| pack-priv void | |
| protected void | |
| public void | afterLast()
Implements java. Moves the cursor to the end of
this |
| public void | beforeFirst()
Implements java. Moves the cursor to the front of
this |
| public void | cancelRowUpdates()
Implements java. Cancels the updates made to the current row in this
|
| protected void | |
| protected void | |
| private void | |
| private void | |
| private void | |
| public void | clearWarnings()
Implements java. Clears all warnings reported on this |
| public void | close()
Implements java. Releases this |
| protected void | |
| private void | |
| public static Map | |
| protected ResultSetMetaData | |
| public void | deleteRow()
Implements java. Deletes the current row from this |
| 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. Maps the given |
| private @NonNegative int | |
| public boolean | first()
Implements java. Moves the cursor to the first row in
this |
| public boolean | Returns: state of adaptive fetch (turned on or off)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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Array | getArray(int
the first column is 1, the second is 2, ... i)Implements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable InputStream | getAsciiStream(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable BigDecimal | getBigDecimal(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable InputStream | getBinaryStream(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Blob | getBlob(int
the first column is 1, the second is 2, ... i)Implements java. Retrieves the value of the designated column in the current row
of this |
| public boolean | Returns: the column value; if the value is SQLNULL, the value returned is
falsethe first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public byte | getByte(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable byte[] | getBytes(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Reader | getCharacterStream(int
the first column is 1, the second is 2, ... i)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Clob | getClob(int
the first column is 1, the second is 2, ... i)Implements java. Retrieves the value of the designated column in the current row
of this |
| public int | |
| public int | getConcurrency()
Implements java. Retrieves the concurrency mode of this |
| public @Nullable String | getCursorName()
Implements java. Retrieves the name of the SQL cursor used by this |
| public @Nullable Date | getDate(int
the first column is 1, the second is 2, ... i, @Nullable Calendar the cal)java.util.Calendar object
to use in constructing the dateImplements java. Retrieves the value of the designated column in the current row
of this |
| 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 cal)java.util.Calendar object
to use in constructing the dateImplements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Date | getDate(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| private Calendar | |
| public double | getDouble(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| private BigDecimal | Returns: The parsed number.integer represented as a sequence of ASCII bytes bytes)Optimised byte[] to number parser. |
| public int | getFetchDirection()
Implements java. Retrieves the fetch direction for this
|
| public int | getFetchSize()
Implements java. Retrieves the fetch size for this
|
| public @Nullable String | Returns: numeric-parsable representation of money string literalcolumn 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public int | getHoldability()
Implements java. Retrieves the holdability of this |
| public int | getInt(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public int | Returns: fetch size used during last fetch.Get fetch size used during last fetch. |
| private @Nullable LocalDate | |
| private @Nullable LocalDateTime | |
| private @Nullable LocalTime | |
| public long | getLong(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public ResultSetMetaData | getMetaData()
Implements java. Retrieves the number, types and properties of
this |
| public @Nullable Reader | getNCharacterStream(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable NClob | getNClob(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable String | getNString(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| private @Nullable Number | |
| public @Nullable Object | getObject(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Gets the value of the designated column in the current row
of this |
| 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. Gets the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| 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 map)java.util.Map object that contains the mapping
from SQL type names to classes in the Java programming languageImplements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Object | getObject(@Positive int
the first column is 1, the second is 2, ... i, @Nullable Map<String, Class<?>> a map)java.util.Map object that contains the mapping
from SQL type names to classes in the Java programming languageImplements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Object | |
| public @Nullable Object | |
| private @Nullable OffsetDateTime | |
| private @Nullable OffsetTime | |
| public BaseStatement | |
| protected String | |
| protected @Nullable byte[] | Returns: raw value or nullThe 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Ref | getRef(int
the first column is 1, the second is 2, ... i)Implements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable String | |
| public int | |
| public @Nullable RowId | getRowId(@Positive int
the first column is 1, the second 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row of this
|
| 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. Retrieves the value of the designated column in the current row of this
|
| public short | getShort(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| protected int | |
| public @Nullable SQLXML | getSQLXML(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row of
this |
| 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. Retrieves the value of the designated column in the current row of
this |
| public Statement | getStatement()
Implements java. Retrieves the |
| public @Nullable String | getString(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Time | getTime(int
the first column is 1, the second is 2, ... i, @Nullable Calendar the cal)java.util.Calendar object
to use in constructing the timeImplements java. Retrieves the value of the designated column in the current row
of this |
| 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 cal)java.util.Calendar object
to use in constructing the timeImplements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Time | getTime(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Timestamp | getTimestamp(int
the first column is 1, the second is 2, ... i, @Nullable Calendar the cal)java.util.Calendar object
to use in constructing the timestampImplements java. Retrieves the value of the designated column in the current row
of this |
| 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 cal)java.util.Calendar object
to use in constructing the dateImplements java. Retrieves the value of the designated column in the current row
of this |
| public @Nullable Timestamp | getTimestamp(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| private TimestampUtils | |
| public int | |
| public @Nullable InputStream | getUnicodeStream(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| public URL | getURL(@Positive int
the index of the column 1 is the first, 2 is the second,... columnIndex)Implements java. Retrieves the value of the designated column in the current row
of this |
| 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. Retrieves the value of the designated column in the current row
of this |
| protected Object | |
| protected Object | |
| public @Nullable SQLWarning | getWarnings()
Implements java. Retrieves the first warning reported by calls on this
|
| private void | |
| private void | |
| public void | insertRow()
Implements java. Inserts the contents of the insert row into this
|
| protected @Nullable Object | |
| public boolean | isAfterLast()
Implements java. Retrieves whether the cursor is after the last row in
this |
| public boolean | isBeforeFirst()
Implements java. Retrieves whether the cursor is before the first row in
this |
| protected boolean | |
| public boolean | isClosed()
Implements java. Retrieves whether this |
| private boolean | |
| public boolean | isFirst()
Implements java. Retrieves whether the cursor is on the first row of
this |
| public boolean | isLast()
Implements java. Retrieves whether the cursor is on the last row of
this Note Calling the method |
| protected boolean | |
| pack-priv boolean | |
| public boolean | isWrapperFor(Class<?>
a Class defining an interface. iface)Implements java. 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. Moves the cursor to the last row in
this |
| protected Array | |
| protected Array | |
| protected Blob | |
| protected Clob | |
| public void | moveToCurrentRow()
Implements java. Moves the cursor to the remembered cursor position, usually the current row. |
| public void | |
| public boolean | next()
Implements java. Moves the cursor forward one row from its current position. |
| private void | |
| public boolean | previous()
Implements java. Moves the cursor to the previous row in this
|
| 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.string that we are trying to crack. Test cases:
fullname)
Table: table
()
"Table": Table
()
Schema.Table:
table (schema)
"Schema"."Table": Table
(Schema)
"Schema"."Dot.Table": Dot.Table
(Schema)
Schema."Dot.Table": Dot.Table
(schema)
Cracks out the table name and schema (if it exists) from a fully qualified table name. |
| private double | Returns: The value as double.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.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. Refreshes the current row with its most recent value in the database. |
| public boolean | relative(int
an rows)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 backwardImplements java. Moves the cursor a relative number of rows, either positive or negative. |
| public boolean | |
| public boolean | rowInserted()
Implements java. Retrieves whether the current row has had an insertion. |
| public boolean | rowUpdated()
Implements java. Retrieves whether the current row has been updated. |
| private BigDecimal | |
| public void | setAdaptiveFetch(boolean
desired state of adaptive fetch. adaptiveFetch)Turn on/off adaptive fetch for ResultSet. |
| public void | setFetchDirection(int
an direction)int specifying the suggested
fetch direction; one of ResultSet.FETCH_FORWARD,
ResultSet.FETCH_REVERSE, or
ResultSet.FETCH_UNKNOWNImplements java. Gives a hint as to the direction in which the rows in this
|
| public void | setFetchSize(int
the number of rows to fetch rows)Implements java. 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
|
| private void | |
| private void | |
| public static @PolyNull BigDecimal | |
| public @PolyNull BigDecimal | |
| public static double | |
| public static float | |
| public static int | |
| public static long | |
| public static short | |
| private byte[] | |
| private @PolyNull String | |
| private String | |
| public <T> T | unwrap(Class<T>
A Class defining an interface that the result must implement. iface)Implements java. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. 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. 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. 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. 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. 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. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. 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. 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. 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. 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. 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. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. 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. 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. 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. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateByte(@Positive int
the first column is 1, the second is 2, ... columnIndex, byte the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateBytes(@Positive int
the first column is 1, the second is 2, ... columnIndex, @Nullable byte[] the new column value x)Implements java. Updates the designated column with a |
| 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. 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. 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 reader, int java.io.Reader object containing
the new column valuethe length of the stream length)Implements java. 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. 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 reader, long java.io.Reader object containing
the new column valuethe length of the stream length)Implements java. 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. 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 reader)java.io.Reader object containing
the new column valueImplements java. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| public void | updateDate(@Positive int
the first column is 1, the second is 2, ... columnIndex, @Nullable Date the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateDouble(@Positive int
the first column is 1, the second is 2, ... columnIndex, double the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateFloat(@Positive int
the first column is 1, the second is 2, ... columnIndex, float the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateInt(@Positive int
the first column is 1, the second is 2, ... columnIndex, int the new column value x)Implements java. Updates the designated column with an |
| 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. Updates the designated column with an |
| public void | updateLong(@Positive int
the first column is 1, the second is 2, ... columnIndex, long the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | |
| public void | |
| public void | updateNCharacterStream(@Positive int
the first column is 1, the second is 2, ... columnIndex, @Nullable Reader the new column value x)Implements java. 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 x)java.io.Reader object containing
the new column valueImplements java. 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. 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 x, long java.io.Reader object containing
the new column valuethe length of the stream length)Implements java. 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| 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. Updates the designated column using the given |
| 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateNull(@Positive int
the first column is 1, the second is 2, ... columnIndex)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateObject(int
the first column is 1, the second is 2, ... columnIndex, @Nullable Object the new column value x)Implements java. Updates the designated column with an |
| 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 scale)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.Implements java. Updates the designated column with an |
| 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 scale)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.Implements java. Updates the designated column with an |
| 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. Updates the designated column with an |
| 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 scaleOrLength)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.Overrides default java. Updates the designated column with an |
| 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 scaleOrLength)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.Overrides default java. Updates the designated column with an |
| 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. Updates the designated column with an |
| 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. Updates the designated column with an |
| 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateRow()
Implements java. Updates the underlying database with the new contents of the
current row of this |
| 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateShort(@Positive int
the first column is 1, the second is 2, ... columnIndex, short the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateString(@Positive int
the first column is 1, the second is 2, ... columnIndex, @Nullable String the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateTime(@Positive int
the first column is 1, the second is 2, ... columnIndex, @Nullable Time the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| public void | updateTimestamp(int
the first column is 1, the second is 2, ... columnIndex, @Nullable Timestamp the new column value x)Implements java. Updates the designated column with a |
| 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. Updates the designated column with a |
| protected void | |
| protected PgResultSet | Returns: PgResultSet
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. Reports whether
the last column read had a value of SQL |