Top Description Inners Fields Constructors Methods
com.mysql.cj.jdbc.result

public Class UpdatableResultSet

extends ResultSetImpl
Class Inheritance
Imports
java.io.InputStream, .Reader, .UnsupportedEncodingException, java.math.BigDecimal, java.sql.Clob, .JDBCType, .NClob, .SQLException, .SQLFeatureNotSupportedException, .SQLType, .SQLXML, .Timestamp, .Types, java.time.LocalDateTime, java.util.ArrayList, .HashMap, .HashSet, .List, .Map, .Set, .TreeMap, java.util.concurrent.locks.Lock, java.util.stream.Collectors, .IntStream, com.mysql.cj.Messages, .MysqlType, com.mysql.cj.conf.PropertyDefinitions.DatabaseTerm, .PropertyKey, com.mysql.cj.exceptions.AssertionFailedException, .ExceptionFactory, .FeatureNotAvailableException, .MysqlErrorNumbers, com.mysql.cj.jdbc.ClientPreparedStatement, .CloseOption, .JdbcConnection, .MysqlSQLXML, .StatementImpl, com.mysql.cj.jdbc.exceptions.NotUpdatable, .SQLError, com.mysql.cj.log.ProfilerEvent, com.mysql.cj.protocol.ResultsetRow, .ResultsetRows, com.mysql.cj.protocol.a.result.ByteArrayRow, com.mysql.cj.result.Field, .Row, com.mysql.cj.util.StringUtils
A result set that is updatable.

Nested and Inner Type Summary

Modifier and TypeClass and Description
pack-priv static interface
UpdatableResultSet.SetterWithException

Field Summary

Modifier and TypeField and Description
private String
charEncoding

private Set<Integer>
columnsToUpdate

private Map<String, Map<String, Map<String, Integer>>>
databasesUsedToTablesUsed

private byte[][]
defaultColumnValue

What is the default value for the column?

private ClientPreparedStatement
deleter

PreparedStatement used to delete data

private String
deleteSQL

protected boolean
doingUpdates

Are we in the middle of doing updates to the current row?

private List<String>
fieldsToUpdate

private boolean
hasLongColumnInfo

protected ClientPreparedStatement
inserter

PreparedStatement used to insert data

private String
insertSQL

private boolean
isUpdatable

Is this result set updatable?

private StringBuilder
keyValues

private String
notUpdatableReason

Reason the result set is not updatable

private boolean
onInsertRow

Are we on the insert row?

private boolean
pedantic

private boolean
populateInserterWithDefaultValues

private List<Integer>
primaryKeyIndices

List of primary keys

private String
qualifiedAndQuotedTableName

private String
quotedIdChar

private ClientPreparedStatement
refresher

PreparedStatement used to refresh data

private String
refreshSQL

private Row
savedCurrentRow

The binary data for the 'current' row

pack-priv Map<Integer, UpdatableResultSet.SetterWithException>
setters

pack-priv static final byte[]
STREAM_DATA_MARKER

Marker for 'stream' data when doing INSERT rows

protected ClientPreparedStatement
updater

PreparedStatement used to delete data

Inherited from com.mysql.cj.jdbc.result.ResultSetImpl:
columnUsedconnectioncurrentRowdbemulateLocatorseventSinkfastClientCalfastDefaultCalfetchDirectionfetchSizefirstCharOfQuerygatherPerfMetricsisClosedresultCounterresultSetConcurrencyresultSetTypescrollTolerantsessionstatementUsedForFetchingRowstreatMysqlDatetimeAsTimestampuseUsageAdvisorwarningChainwrapperStatementyearIsDateType

Constructor Summary

AccessConstructor and Description
public
UpdatableResultSet(ResultsetRows
actual row data
tuples, JdbcConnection
the Connection that created us.
conn, StatementImpl
statement owning this result set
creatorStmt)

Creates a new ResultSet object.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.absolute.

Implements java.sql.ResultSet.absolute.

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

public void
afterLast()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.afterLast.

Implements java.sql.ResultSet.afterLast.

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

public void
beforeFirst()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.beforeFirst.

Implements java.sql.ResultSet.beforeFirst.

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

public void
cancelRowUpdates()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.cancelRowUpdates.

Implements java.sql.ResultSet.cancelRowUpdates.

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

protected void
checkRowPos()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.checkRowPos.

Ensures that the cursor is positioned on a valid row and that the result set is not closed

public void
checkUpdatability()

Is this ResultSet updatable?

public void
deleteRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.deleteRow.

Implements java.sql.ResultSet.deleteRow.

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

public void
doClose(CloseOption...
options indicating how the close was initiated and/or what should be performed during the close
options)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.doClose.

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.doClose.

Close this ResultSet and release resources.

private void
extractDefaultValues()

public boolean
first()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.first.

Implements java.sql.ResultSet.first.

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

private String
generateFilteredUpdateSQL()

protected void
generateStatements()

Figure out whether or not this ResultSet is updatable, and if so, generate the PreparedStatements to support updates.

private Map<String, Integer>
getColumnsToIndexMapForTableAndDB(String databaseName, String tableName)

public int
getConcurrency()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getConcurrency.

Implements java.sql.ResultSet.getConcurrency.

Retrieves the concurrency mode of this ResultSet object.

public int
getHoldability()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getHoldability.

Implements java.sql.ResultSet.getHoldability.

Retrieves the holdability of this ResultSet object

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNCharacterStream.

Implements java.sql.ResultSet.getNCharacterStream.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNCharacterStream.

Implements java.sql.ResultSet.getNCharacterStream.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNClob.

Implements java.sql.ResultSet.getNClob.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNClob.

Implements java.sql.ResultSet.getNClob.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNString.

Implements java.sql.ResultSet.getNString.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getNString.

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 String
getQuotedIdChar()

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getSQLXML.

Implements java.sql.ResultSet.getSQLXML.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.getSQLXML.

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.

private String
getStringForNClob(int columnIndex)

Hides com.mysql.cj.jdbc.result.ResultSetImpl.getStringForNClob.

public void
insertRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.insertRow.

Implements java.sql.ResultSet.insertRow.

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

public boolean
isAfterLast()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.isAfterLast.

Implements java.sql.ResultSet.isAfterLast.

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

public boolean
isBeforeFirst()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.isBeforeFirst.

Implements java.sql.ResultSet.isBeforeFirst.

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

public boolean
isClosed()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.isClosed.

Implements java.sql.ResultSet.isClosed.

Retrieves whether this ResultSet object has been closed.

public boolean
isFirst()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.isFirst.

Implements java.sql.ResultSet.isFirst.

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

public boolean
isLast()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.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.

pack-priv boolean
isUpdatable()

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.isWrapperFor.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.last.

Implements java.sql.ResultSet.last.

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

public void
moveToCurrentRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.moveToCurrentRow.

Implements java.sql.ResultSet.moveToCurrentRow.

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

public void
moveToInsertRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.moveToInsertRow.

Implements java.sql.ResultSet.moveToInsertRow.

Moves the cursor to the insert row.

public boolean
next()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.next.

Implements java.sql.ResultSet.next.

Moves the cursor forward one row from its current position.

public boolean
prev()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.prev.

The prev method is not part of JDBC, but because of the architecture of this driver it is possible to move both forward and backward within the result set.

public boolean
previous()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.previous.

Implements java.sql.ResultSet.previous.

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

public void
refreshRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.refreshRow.

Implements java.sql.ResultSet.refreshRow.

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

private void
refreshRow(ClientPreparedStatement updateInsertStmt, Row rowToRefresh)

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)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.relative.

Implements java.sql.ResultSet.relative.

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

private void
resetInserter()

public boolean
rowDeleted()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.rowDeleted.

Implements java.sql.ResultSet.rowDeleted.

Retrieves whether a row has been deleted.

public boolean
rowInserted()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.rowInserted.

Implements java.sql.ResultSet.rowInserted.

Retrieves whether the current row has had an insertion.

public boolean
rowUpdated()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.rowUpdated.

Implements java.sql.ResultSet.rowUpdated.

Retrieves whether the current row has been updated.

private void
setParamValue(ClientPreparedStatement ps, int psIdx, Row row, int rsIdx, Field field)

public void
setResultSetConcurrency(int
CONCUR_UPDATABLE or CONCUR_READONLY
concurrencyFlag)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.setResultSetConcurrency.

Sets the concurrency

protected void
syncUpdate()

Reset UPDATE prepared statement to value in current row.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.unwrap.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, int
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

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
columnLabel, InputStream
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

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
columnLabel, InputStream
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateAsciiStream.

Implements java.sql.ResultSet.updateAsciiStream.

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

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
columnLabel, BigDecimal
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBigDecimal.

Implements java.sql.ResultSet.updateBigDecimal.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBigDecimal.

Implements java.sql.ResultSet.updateBigDecimal.

Updates the designated column with a java.math.BigDecimal 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
columnLabel, InputStream
the new column value
x, int
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, int
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

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
columnLabel, InputStream
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

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
columnLabel, InputStream
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBinaryStream.

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, 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
columnLabel, Blob
the new column value
blob)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

Implements java.sql.ResultSet.updateBlob.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

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(int
the first column is 1, the second is 2, ...
columnIndex, InputStream
An object that contains the data to set the parameter value to.
inputStream, long
the number of bytes in the parameter data.
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBlob.

Implements java.sql.ResultSet.updateBlob.

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

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
columnLabel, boolean
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBoolean.

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBoolean.

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean 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
columnLabel, byte
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateByte.

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateByte.

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte 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
columnLabel, byte[]
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBytes.

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateBytes.

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array 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
columnLabel, Reader
the java.io.Reader object containing the new column value
reader, int
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, int
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateCharacterStream.

Implements java.sql.ResultSet.updateCharacterStream.

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

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
columnLabel, Clob
the new column value
clob)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

Implements java.sql.ResultSet.updateClob.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateClob.

Implements java.sql.ResultSet.updateClob.

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

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
columnLabel, Date
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateDate.

Implements java.sql.ResultSet.updateDate.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateDate.

Implements java.sql.ResultSet.updateDate.

Updates the designated column with a java.sql.Date 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
columnLabel, double
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateDouble.

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateDouble.

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double 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
columnLabel, float
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateFloat.

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateFloat.

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float 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
columnLabel, int
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateInt.

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateInt.

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int 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
columnLabel, long
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateLong.

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateLong.

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long 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
columnLabel, Reader
the java.io.Reader object containing the new column value
reader)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNCharacterStream.

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNCharacterStream.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNCharacterStream.

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(int
the first column is 1, the second is 2, ...
columnIndex, Reader
the new column value
x, long
the length of the stream
length)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNCharacterStream.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

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
columnLabel, NClob
the value for the column to be updated
nClob)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

Implements java.sql.ResultSet.updateNClob.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNClob.

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob 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
columnLabel, String
the value for the column to be updated
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNString.

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNString.

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String 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
columnLabel)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNull.

Implements java.sql.ResultSet.updateNull.

Updates the designated column with a null value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateNull.

Implements java.sql.ResultSet.updateNull.

Updates the designated column with a null 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, Object
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

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, Object
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

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
columnLabel, 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)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

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
columnLabel, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

Overrides default 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, Object
the new column value
x, SQLType
the SQL type to be sent to the database
targetSqlType)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

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, 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 com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

Overrides default 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, 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 com.mysql.cj.jdbc.result.ResultSetImpl.updateObject.

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

protected void
updateObjectInternal(int
column index
columnIndex, Object
value
x, Integer
target type
targetType, int
scale or length, depending on target type
scaleOrLength)

Internal setObject implementation.

protected void
updateObjectInternal(int
column index
columnIndex, Object
value
x, SQLType
target type
targetType, int
scale or length, depending on target type
scaleOrLength)

Internal setObject implementation.

public void
updateRow()

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateRow.

Implements java.sql.ResultSet.updateRow.

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

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
columnLabel, short
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateShort.

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateShort.

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short 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
columnLabel, SQLXML
the column value
xmlObject)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateSQLXML.

Implements java.sql.ResultSet.updateSQLXML.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateSQLXML.

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML 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
columnLabel, String
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateString.

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String value.

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateString.

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String 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
columnLabel, Time
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateTime.

Implements java.sql.ResultSet.updateTime.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateTime.

Implements java.sql.ResultSet.updateTime.

Updates the designated column with a java.sql.Time 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
columnLabel, Timestamp
the new column value
x)

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateTimestamp.

Implements java.sql.ResultSet.updateTimestamp.

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

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

Overrides com.mysql.cj.jdbc.result.ResultSetImpl.updateTimestamp.

Implements java.sql.ResultSet.updateTimestamp.

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

Inherited from com.mysql.cj.jdbc.result.ResultSetImpl:
checkClosedcheckColumnBoundsclearWarningsclosecloseOwnerfindColumngetArraygetArraygetAsciiStreamgetAsciiStreamgetBigDecimalgetBigDecimalgetBigDecimalgetBigDecimalgetBigIntegergetBinaryStreamgetBinaryStreamgetBlobgetBlobgetBooleangetBooleangetBytegetBytegetBytesgetBytesgetCharacterStreamgetCharacterStreamgetClobgetClobgetConnectiongetCursorNamegetDategetDategetDategetDategetDoublegetDoublegetExceptionInterceptorgetFetchDirectiongetFetchSizegetFirstCharOfQuerygetFloatgetFloatgetIntgetIntgetLocalDategetLocalDateTimegetLocalTimegetLockgetLonggetLonggetMetaDatagetMetadatagetObjectgetObjectgetObjectgetObjectgetObjectgetObjectgetObjectStoredProcgetObjectStoredProcgetObjectStoredProcgetObjectStoredProcgetOwnerFetchSizegetOwningQuerygetOwningStatementgetOwningStatementFetchSizegetOwningStatementMaxRowsgetOwningStatementServerIdgetPointOfOrigingetRefgetRefgetRowgetRowIdgetRowIdgetSessiongetShortgetShortgetStatementgetStringgetStringgetTimegetTimegetTimegetTimegetTimestampgetTimestampgetTimestampgetTimestampgetTypegetUnicodeStreamgetUnicodeStreamgetURLgetURLgetUtilCalendargetWarningsinitializeWithMetadataisStrictlyForwardOnlypopulateCachedMetaDatasetFetchDirectionsetFetchSizesetFirstCharOfQuerysetOwningStatementsetResultSetTypesetServerInfosetStatementUsedForFetchingRowssetWrapperStatementtoStringupdateArrayupdateArrayupdateRefupdateRefupdateRowIdupdateRowIdwarningEncounteredwasNull