Package com.mysql.cj.jdbc.result
Class UpdatableResultSet
java.lang.Object
com.mysql.cj.protocol.a.result.NativeResultset
com.mysql.cj.jdbc.result.ResultSetImpl
com.mysql.cj.jdbc.result.UpdatableResultSet
- All Implemented Interfaces:
ResultSetInternalMethods
,ProtocolEntity
,Resultset
,ResultsetRowsOwner
,WarningListener
,java.lang.AutoCloseable
,java.sql.ResultSet
,java.sql.Wrapper
public class UpdatableResultSet extends ResultSetImpl
A result set that is updatable.
-
Nested Class Summary
Nested classes/interfaces inherited from interface com.mysql.cj.protocol.Resultset
Resultset.Concurrency, Resultset.Type
-
Field Summary
Fields Modifier and Type Field Description protected boolean
doingUpdates
Are we in the middle of doing updates to the current row?protected ClientPreparedStatement
inserter
PreparedStatement used to insert dataprotected ClientPreparedStatement
updater
PreparedStatement used to delete dataFields inherited from class com.mysql.cj.jdbc.result.ResultSetImpl
columnUsed, connection, currentRow, db, emulateLocators, eventSink, fetchDirection, fetchSize, firstCharOfQuery, gatherPerfMetrics, isClosed, resultSetConcurrency, resultSetType, session, useUsageAdvisor, warningChain, wrapperStatement, yearIsDateType
Fields inherited from class com.mysql.cj.protocol.a.result.NativeResultset
columnDefinition, nextResultset, resultId, rowData, serverInfo, thisRow, updateCount, updateId
-
Constructor Summary
Constructors Constructor Description UpdatableResultSet(ResultsetRows tuples, JdbcConnection conn, StatementImpl creatorStmt)
Creates a new ResultSet object. -
Method Summary
Modifier and Type Method Description boolean
absolute(int row)
void
afterLast()
void
beforeFirst()
void
cancelRowUpdates()
protected void
checkRowPos()
Ensures that the cursor is positioned on a valid row and that the result set is not closedvoid
checkUpdatability()
Is this ResultSet updatable?void
deleteRow()
boolean
first()
protected void
generateStatements()
Figure out whether or not this ResultSet is updatable, and if so, generate the PreparedStatements to support updates.int
getConcurrency()
int
getHoldability()
java.io.Reader
getNCharacterStream(int columnIndex)
java.io.Reader
getNCharacterStream(java.lang.String columnLabel)
java.sql.NClob
getNClob(int columnIndex)
java.sql.NClob
getNClob(java.lang.String columnLabel)
java.lang.String
getNString(int columnIndex)
java.lang.String
getNString(java.lang.String columnLabel)
java.sql.SQLXML
getSQLXML(int columnIndex)
java.sql.SQLXML
getSQLXML(java.lang.String columnLabel)
void
insertRow()
boolean
isAfterLast()
boolean
isBeforeFirst()
boolean
isClosed()
boolean
isFirst()
boolean
isLast()
boolean
isWrapperFor(java.lang.Class<?> iface)
boolean
last()
void
moveToCurrentRow()
void
moveToInsertRow()
boolean
next()
boolean
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.boolean
previous()
void
realClose(boolean calledExplicitly)
Closes this ResultSet and releases resources.void
refreshRow()
boolean
relative(int rows)
boolean
rowDeleted()
boolean
rowInserted()
boolean
rowUpdated()
void
setResultSetConcurrency(int concurrencyFlag)
Sets the concurrencyprotected void
syncUpdate()
Reset UPDATE prepared statement to value in current row.<T> T
unwrap(java.lang.Class<T> iface)
void
updateAsciiStream(int columnIndex, java.io.InputStream x)
void
updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
void
updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length)
void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void
updateBigDecimal(int columnIndex, java.math.BigDecimal x)
void
updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x)
void
updateBinaryStream(int columnIndex, java.io.InputStream x)
void
updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
void
updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length)
void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void
updateBlob(int columnIndex, java.io.InputStream inputStream)
void
updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
void
updateBlob(int columnIndex, java.sql.Blob blob)
void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
void
updateBlob(java.lang.String columnLabel, java.sql.Blob blob)
void
updateBoolean(int columnIndex, boolean x)
void
updateBoolean(java.lang.String columnLabel, boolean x)
void
updateByte(int columnIndex, byte x)
void
updateByte(java.lang.String columnLabel, byte x)
void
updateBytes(int columnIndex, byte[] x)
void
updateBytes(java.lang.String columnLabel, byte[] x)
void
updateCharacterStream(int columnIndex, java.io.Reader x)
void
updateCharacterStream(int columnIndex, java.io.Reader x, int length)
void
updateCharacterStream(int columnIndex, java.io.Reader x, long length)
void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length)
void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateClob(int columnIndex, java.io.Reader reader)
void
updateClob(int columnIndex, java.io.Reader reader, long length)
void
updateClob(int columnIndex, java.sql.Clob clob)
void
updateClob(java.lang.String columnLabel, java.io.Reader reader)
void
updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateClob(java.lang.String columnLabel, java.sql.Clob clob)
void
updateDate(int columnIndex, java.sql.Date x)
void
updateDate(java.lang.String columnLabel, java.sql.Date x)
void
updateDouble(int columnIndex, double x)
void
updateDouble(java.lang.String columnLabel, double x)
void
updateFloat(int columnIndex, float x)
void
updateFloat(java.lang.String columnLabel, float x)
void
updateInt(int columnIndex, int x)
void
updateInt(java.lang.String columnLabel, int x)
void
updateLong(int columnIndex, long x)
void
updateLong(java.lang.String columnLabel, long x)
void
updateNCharacterStream(int columnIndex, java.io.Reader x)
void
updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateNClob(int columnIndex, java.io.Reader reader)
void
updateNClob(int columnIndex, java.io.Reader reader, long length)
void
updateNClob(int columnIndex, java.sql.NClob nClob)
void
updateNClob(java.lang.String columnLabel, java.io.Reader reader)
void
updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateNClob(java.lang.String columnLabel, java.sql.NClob nClob)
void
updateNString(int columnIndex, java.lang.String x)
void
updateNString(java.lang.String columnLabel, java.lang.String x)
void
updateNull(int columnIndex)
void
updateNull(java.lang.String columnLabel)
void
updateObject(int columnIndex, java.lang.Object x)
void
updateObject(int columnIndex, java.lang.Object x, int scale)
void
updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType)
void
updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
void
updateObject(java.lang.String columnLabel, java.lang.Object x)
void
updateObject(java.lang.String columnLabel, java.lang.Object x, int scale)
void
updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType)
void
updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
protected void
updateObjectInternal(int columnIndex, java.lang.Object x, java.lang.Integer targetType, int scaleOrLength)
Internal setObject implementation.protected void
updateObjectInternal(int columnIndex, java.lang.Object x, java.sql.SQLType targetType, int scaleOrLength)
Internal setObject implementation.void
updateRow()
void
updateShort(int columnIndex, short x)
void
updateShort(java.lang.String columnLabel, short x)
void
updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
void
updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)
void
updateString(int columnIndex, java.lang.String x)
void
updateString(java.lang.String columnLabel, java.lang.String x)
void
updateTime(int columnIndex, java.sql.Time x)
void
updateTime(java.lang.String columnLabel, java.sql.Time x)
void
updateTimestamp(int columnIndex, java.sql.Timestamp x)
void
updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x)
Methods inherited from class com.mysql.cj.jdbc.result.ResultSetImpl
checkClosed, checkColumnBounds, clearWarnings, close, closeOwner, findColumn, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBigInteger, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConnection, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getExceptionInterceptor, getFetchDirection, getFetchSize, getFirstCharOfQuery, getFloat, getFloat, getInt, getInt, getLocalDate, getLocalDateTime, getLocalTime, getLong, getLong, getMetadata, getMetaData, getObject, getObject, getObject, getObject, getObject, getObject, getObjectStoredProc, getObjectStoredProc, getObjectStoredProc, getObjectStoredProc, getOwnerFetchSize, getOwningQuery, getOwningStatement, getOwningStatementFetchSize, getOwningStatementMaxRows, getOwningStatementServerId, getPointOfOrigin, getRef, getRef, getRow, getRowId, getRowId, getSession, getShort, getShort, getStatement, getString, getString, getSyncMutex, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getUtilCalendar, getWarnings, initializeWithMetadata, populateCachedMetaData, setFetchDirection, setFetchSize, setFirstCharOfQuery, setOwningStatement, setResultSetType, setServerInfo, setStatementUsedForFetchingRows, setWrapperStatement, toString, updateArray, updateArray, updateRef, updateRef, updateRowId, updateRowId, warningEncountered, wasNull
Methods inherited from class com.mysql.cj.protocol.a.result.NativeResultset
clearNextResultset, getColumnDefinition, getNextResultset, getResultId, getRows, getServerInfo, getUpdateCount, getUpdateID, hasRows, initRowsWithMetadata, setColumnDefinition, setNextResultset
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface com.mysql.cj.protocol.Resultset
clearNextResultset, getColumnDefinition, getNextResultset, getResultId, getRows, getServerInfo, getUpdateCount, getUpdateID, hasRows, initRowsWithMetadata, setColumnDefinition, setNextResultset
-
Field Details
-
inserter
PreparedStatement used to insert data -
updater
PreparedStatement used to delete data -
doingUpdates
protected boolean doingUpdatesAre we in the middle of doing updates to the current row?
-
-
Constructor Details
-
UpdatableResultSet
public UpdatableResultSet(ResultsetRows tuples, JdbcConnection conn, StatementImpl creatorStmt) throws java.sql.SQLExceptionCreates a new ResultSet object.- Parameters:
tuples
- actual row dataconn
- the Connection that created us.creatorStmt
- statement owning this result set- Throws:
java.sql.SQLException
- if an error occurs
-
-
Method Details
-
absolute
public boolean absolute(int row) throws java.sql.SQLException- Specified by:
absolute
in interfacejava.sql.ResultSet
- Overrides:
absolute
in classResultSetImpl
- Throws:
java.sql.SQLException
-
afterLast
public void afterLast() throws java.sql.SQLException- Specified by:
afterLast
in interfacejava.sql.ResultSet
- Overrides:
afterLast
in classResultSetImpl
- Throws:
java.sql.SQLException
-
beforeFirst
public void beforeFirst() throws java.sql.SQLException- Specified by:
beforeFirst
in interfacejava.sql.ResultSet
- Overrides:
beforeFirst
in classResultSetImpl
- Throws:
java.sql.SQLException
-
cancelRowUpdates
public void cancelRowUpdates() throws java.sql.SQLException- Specified by:
cancelRowUpdates
in interfacejava.sql.ResultSet
- Overrides:
cancelRowUpdates
in classResultSetImpl
- Throws:
java.sql.SQLException
-
checkRowPos
protected void checkRowPos() throws java.sql.SQLExceptionDescription copied from class:ResultSetImpl
Ensures that the cursor is positioned on a valid row and that the result set is not closed- Overrides:
checkRowPos
in classResultSetImpl
- Throws:
java.sql.SQLException
- if the result set is not in a valid state for traversal
-
checkUpdatability
public void checkUpdatability() throws java.sql.SQLExceptionIs this ResultSet updatable?- Throws:
java.sql.SQLException
- if an error occurs
-
deleteRow
public void deleteRow() throws java.sql.SQLException- Specified by:
deleteRow
in interfacejava.sql.ResultSet
- Overrides:
deleteRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
first
public boolean first() throws java.sql.SQLException- Specified by:
first
in interfacejava.sql.ResultSet
- Overrides:
first
in classResultSetImpl
- Throws:
java.sql.SQLException
-
generateStatements
protected void generateStatements() throws java.sql.SQLExceptionFigure out whether or not this ResultSet is updatable, and if so, generate the PreparedStatements to support updates.- Throws:
java.sql.SQLException
- if an error occursNotUpdatable
- if result set was marked as not updatable
-
getConcurrency
public int getConcurrency() throws java.sql.SQLException- Specified by:
getConcurrency
in interfacejava.sql.ResultSet
- Overrides:
getConcurrency
in classResultSetImpl
- Throws:
java.sql.SQLException
-
insertRow
public void insertRow() throws java.sql.SQLException- Specified by:
insertRow
in interfacejava.sql.ResultSet
- Overrides:
insertRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isAfterLast
public boolean isAfterLast() throws java.sql.SQLException- Specified by:
isAfterLast
in interfacejava.sql.ResultSet
- Overrides:
isAfterLast
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isBeforeFirst
public boolean isBeforeFirst() throws java.sql.SQLException- Specified by:
isBeforeFirst
in interfacejava.sql.ResultSet
- Overrides:
isBeforeFirst
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isFirst
public boolean isFirst() throws java.sql.SQLException- Specified by:
isFirst
in interfacejava.sql.ResultSet
- Overrides:
isFirst
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isLast
public boolean isLast() throws java.sql.SQLException- Specified by:
isLast
in interfacejava.sql.ResultSet
- Overrides:
isLast
in classResultSetImpl
- Throws:
java.sql.SQLException
-
last
public boolean last() throws java.sql.SQLException- Specified by:
last
in interfacejava.sql.ResultSet
- Overrides:
last
in classResultSetImpl
- Throws:
java.sql.SQLException
-
moveToCurrentRow
public void moveToCurrentRow() throws java.sql.SQLException- Specified by:
moveToCurrentRow
in interfacejava.sql.ResultSet
- Overrides:
moveToCurrentRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
moveToInsertRow
public void moveToInsertRow() throws java.sql.SQLException- Specified by:
moveToInsertRow
in interfacejava.sql.ResultSet
- Overrides:
moveToInsertRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
next
public boolean next() throws java.sql.SQLException- Specified by:
next
in interfacejava.sql.ResultSet
- Overrides:
next
in classResultSetImpl
- Throws:
java.sql.SQLException
-
prev
public boolean prev() throws java.sql.SQLExceptionDescription copied from class:ResultSetImpl
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.If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read
- Overrides:
prev
in classResultSetImpl
- Returns:
- true if the new current is valid; false if there are no more rows
- Throws:
java.sql.SQLException
- if a database access error occurs
-
previous
public boolean previous() throws java.sql.SQLException- Specified by:
previous
in interfacejava.sql.ResultSet
- Overrides:
previous
in classResultSetImpl
- Throws:
java.sql.SQLException
-
realClose
public void realClose(boolean calledExplicitly) throws java.sql.SQLExceptionDescription copied from interface:ResultSetInternalMethods
Closes this ResultSet and releases resources.- Specified by:
realClose
in interfaceResultSetInternalMethods
- Overrides:
realClose
in classResultSetImpl
- Parameters:
calledExplicitly
- was realClose called by the standard ResultSet.close() method, or was it closed internally by the driver?- Throws:
java.sql.SQLException
- if an error occurs
-
refreshRow
public void refreshRow() throws java.sql.SQLException- Specified by:
refreshRow
in interfacejava.sql.ResultSet
- Overrides:
refreshRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
relative
public boolean relative(int rows) throws java.sql.SQLException- Specified by:
relative
in interfacejava.sql.ResultSet
- Overrides:
relative
in classResultSetImpl
- Throws:
java.sql.SQLException
-
rowDeleted
public boolean rowDeleted() throws java.sql.SQLException- Specified by:
rowDeleted
in interfacejava.sql.ResultSet
- Overrides:
rowDeleted
in classResultSetImpl
- Throws:
java.sql.SQLException
-
rowInserted
public boolean rowInserted() throws java.sql.SQLException- Specified by:
rowInserted
in interfacejava.sql.ResultSet
- Overrides:
rowInserted
in classResultSetImpl
- Throws:
java.sql.SQLException
-
rowUpdated
public boolean rowUpdated() throws java.sql.SQLException- Specified by:
rowUpdated
in interfacejava.sql.ResultSet
- Overrides:
rowUpdated
in classResultSetImpl
- Throws:
java.sql.SQLException
-
setResultSetConcurrency
public void setResultSetConcurrency(int concurrencyFlag)Description copied from class:ResultSetImpl
Sets the concurrency- Overrides:
setResultSetConcurrency
in classResultSetImpl
- Parameters:
concurrencyFlag
- CONCUR_UPDATABLE or CONCUR_READONLY
-
syncUpdate
protected void syncUpdate() throws java.sql.SQLExceptionReset UPDATE prepared statement to value in current row. This_Row MUST point to current, valid row.- Throws:
java.sql.SQLException
- if an error occurs
-
updateRow
public void updateRow() throws java.sql.SQLException- Specified by:
updateRow
in interfacejava.sql.ResultSet
- Overrides:
updateRow
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getHoldability
public int getHoldability() throws java.sql.SQLException- Specified by:
getHoldability
in interfacejava.sql.ResultSet
- Overrides:
getHoldability
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBigDecimal
public void updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Overrides:
updateBigDecimal
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Overrides:
updateBigDecimal
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.sql.Blob blob) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.sql.Blob blob) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBoolean
public void updateBoolean(java.lang.String columnLabel, boolean x) throws java.sql.SQLException- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Overrides:
updateBoolean
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Overrides:
updateBoolean
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateByte
public void updateByte(java.lang.String columnLabel, byte x) throws java.sql.SQLException- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Overrides:
updateByte
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateByte
public void updateByte(int columnIndex, byte x) throws java.sql.SQLException- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Overrides:
updateByte
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBytes
public void updateBytes(java.lang.String columnLabel, byte[] x) throws java.sql.SQLException- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Overrides:
updateBytes
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Overrides:
updateBytes
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnLabel, java.sql.Clob clob) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.sql.Clob clob) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateDate
public void updateDate(java.lang.String columnLabel, java.sql.Date x) throws java.sql.SQLException- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Overrides:
updateDate
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateDate
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Overrides:
updateDate
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateDouble
public void updateDouble(java.lang.String columnLabel, double x) throws java.sql.SQLException- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Overrides:
updateDouble
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateDouble
public void updateDouble(int columnIndex, double x) throws java.sql.SQLException- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Overrides:
updateDouble
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateFloat
public void updateFloat(java.lang.String columnLabel, float x) throws java.sql.SQLException- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Overrides:
updateFloat
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateFloat
public void updateFloat(int columnIndex, float x) throws java.sql.SQLException- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Overrides:
updateFloat
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateInt
public void updateInt(java.lang.String columnLabel, int x) throws java.sql.SQLException- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Overrides:
updateInt
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateInt
public void updateInt(int columnIndex, int x) throws java.sql.SQLException- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Overrides:
updateInt
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateLong
public void updateLong(java.lang.String columnLabel, long x) throws java.sql.SQLException- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Overrides:
updateLong
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateLong
public void updateLong(int columnIndex, long x) throws java.sql.SQLException- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Overrides:
updateLong
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNull
public void updateNull(java.lang.String columnLabel) throws java.sql.SQLException- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Overrides:
updateNull
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNull
public void updateNull(int columnIndex) throws java.sql.SQLException- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Overrides:
updateNull
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, int scale) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObjectInternal
protected void updateObjectInternal(int columnIndex, java.lang.Object x, java.lang.Integer targetType, int scaleOrLength) throws java.sql.SQLExceptionInternal setObject implementation. Although targetType is not part of default ResultSet methods signatures, it is used for type conversions from JDBC42UpdatableResultSet new JDBC 4.2 updateObject() methods.- Parameters:
columnIndex
- column indexx
- valuetargetType
- target typescaleOrLength
- scale or length, depending on target type- Throws:
java.sql.SQLException
- if an error occurs
-
updateObjectInternal
protected void updateObjectInternal(int columnIndex, java.lang.Object x, java.sql.SQLType targetType, int scaleOrLength) throws java.sql.SQLExceptionInternal setObject implementation.- Parameters:
columnIndex
- column indexx
- valuetargetType
- target typescaleOrLength
- scale or length, depending on target type- Throws:
java.sql.SQLException
- if an error occurs
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Overrides:
updateObject
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateShort
public void updateShort(java.lang.String columnLabel, short x) throws java.sql.SQLException- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Overrides:
updateShort
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateShort
public void updateShort(int columnIndex, short x) throws java.sql.SQLException- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Overrides:
updateShort
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateString
public void updateString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException- Specified by:
updateString
in interfacejava.sql.ResultSet
- Overrides:
updateString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateString
public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException- Specified by:
updateString
in interfacejava.sql.ResultSet
- Overrides:
updateString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateTime
public void updateTime(java.lang.String columnLabel, java.sql.Time x) throws java.sql.SQLException- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Overrides:
updateTime
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateTime
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Overrides:
updateTime
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateTimestamp
public void updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Overrides:
updateTimestamp
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateTimestamp
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Overrides:
updateTimestamp
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Overrides:
updateAsciiStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Overrides:
updateBinaryStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Overrides:
updateBlob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Overrides:
updateClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
updateNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Overrides:
updateNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Overrides:
updateSQLXML
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Overrides:
updateSQLXML
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Overrides:
updateNString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(int columnIndex, java.lang.String x) throws java.sql.SQLException- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Overrides:
updateNString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
getNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Overrides:
getNCharacterStream
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Overrides:
getNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Overrides:
getNClob
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException- Specified by:
getNString
in interfacejava.sql.ResultSet
- Overrides:
getNString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException- Specified by:
getNString
in interfacejava.sql.ResultSet
- Overrides:
getNString
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Overrides:
getSQLXML
in classResultSetImpl
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Overrides:
getSQLXML
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isClosed
public boolean isClosed() throws java.sql.SQLException- Specified by:
isClosed
in interfacejava.sql.ResultSet
- Overrides:
isClosed
in classResultSetImpl
- Throws:
java.sql.SQLException
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException- Specified by:
isWrapperFor
in interfacejava.sql.Wrapper
- Overrides:
isWrapperFor
in classResultSetImpl
- Throws:
java.sql.SQLException
-
unwrap
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException- Specified by:
unwrap
in interfacejava.sql.Wrapper
- Overrides:
unwrap
in classResultSetImpl
- Throws:
java.sql.SQLException
-