Class JDBC4UpdatableResultSet

java.lang.Object

com.mysql.jdbc.ResultSetImpl

com.mysql.jdbc.UpdatableResultSet

com.mysql.jdbc.JDBC4UpdatableResultSet

All Implemented Interfaces:

ResultSetInternalMethods, AutoCloseable, ResultSet, Wrapper

Direct Known Subclasses:

JDBC42UpdatableResultSet

public class JDBC4UpdatableResultSet
extends UpdatableResultSet

Field Summary

Fields inherited from class UpdatableResultSet

charConverter, inserter, STREAM_DATA_MARKER, updater

Fields inherited from class ResultSetImpl

catalog, columnLabelToIndex, columnNameToIndex, columnToIndexCache, columnUsed, connection, currentRow, doingUpdates, EMPTY_SPACE, fastClientCal, fastDefaultCal, fetchDirection, fetchSize, fields, firstCharOfQuery, fullColumnNameToIndex, gmtCalendar, hasBuiltIndexMapping, isBinaryEncoded, isClosed, MAX_DIFF_PREC, MIN_DIFF_PREC, nextResultSet, onInsertRow, owningStatement, pointOfOrigin, reallyResult, resultCounter, resultId, resultSetConcurrency, resultSetType, retainOwningStatement, rowData, serverInfo, statementUsedForFetchingRows, thisRow, updateCount, updateId, useFastDateParsing, useLegacyDatetimeCode, useUsageAdvisor, warningChain, wasNullFlag, wrapperStatement

Fields inherited from interface ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors

Constructor	Description
JDBC4UpdatableResultSet(String catalog, Field[] fields, RowData tuples, MySQLConnection conn, StatementImpl creatorStmt)

Method Summary

Modifier and Type	Method	Description
int	getHoldability()
protected NClob	getNativeNClob(int columnIndex)	JDBC 4.0 Get a NCLOB column.
Reader	getNCharacterStream(int columnIndex)	JDBC 4.0
Reader	getNCharacterStream(String columnName)	JDBC 4.0
NClob	getNClob(int columnIndex)	JDBC 4.0 Get a NCLOB column.
NClob	getNClob(String columnName)	JDBC 4.0 Get a NCLOB column.
String	getNString(int columnIndex)	JDBC 4.0 Get the value of a column in the current row as a Java String
String	getNString(String columnName)	JDBC 4.0 The following routines simply convert the columnName into a columnIndex and then call the appropriate routine above.
RowId	getRowId(int columnIndex)
RowId	getRowId(String columnLabel)
SQLXML	getSQLXML(int columnIndex)
SQLXML	getSQLXML(String columnLabel)
boolean	isClosed()	Returns true if this ResultSet is closed.
boolean	isWrapperFor(Class<?> iface)	Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
<T> T	unwrap(Class<T> iface)	Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
void	updateAsciiStream(int columnIndex, InputStream x)
void	updateAsciiStream(int columnIndex, InputStream x, long length)
void	updateAsciiStream(String columnLabel, InputStream x)
void	updateAsciiStream(String columnLabel, InputStream x, long length)
void	updateBinaryStream(int columnIndex, InputStream x)
void	updateBinaryStream(int columnIndex, InputStream x, long length)
void	updateBinaryStream(String columnLabel, InputStream x)
void	updateBinaryStream(String columnLabel, InputStream x, long length)
void	updateBlob(int columnIndex, InputStream inputStream)
void	updateBlob(int columnIndex, InputStream inputStream, long length)
void	updateBlob(String columnLabel, InputStream inputStream)
void	updateBlob(String columnLabel, InputStream inputStream, long length)
void	updateCharacterStream(int columnIndex, Reader x)
void	updateCharacterStream(int columnIndex, Reader x, long length)
void	updateCharacterStream(String columnLabel, Reader reader)
void	updateCharacterStream(String columnLabel, Reader reader, long length)
void	updateClob(int columnIndex, Reader reader)
void	updateClob(int columnIndex, Reader reader, long length)
void	updateClob(String columnLabel, Reader reader)
void	updateClob(String columnLabel, Reader reader, long length)
void	updateNCharacterStream(int columnIndex, Reader x)
void	updateNCharacterStream(int columnIndex, Reader x, int length)	JDBC 4.0 Update a column with a character stream value.
void	updateNCharacterStream(int columnIndex, Reader x, long length)
void	updateNCharacterStream(String columnLabel, Reader reader)
void	updateNCharacterStream(String columnName, Reader reader, int length)	JDBC 4.0 Update a column with a character stream value.
void	updateNCharacterStream(String columnLabel, Reader reader, long length)
void	updateNClob(int columnIndex, Reader reader)
void	updateNClob(int columnIndex, Reader reader, long length)
void	updateNClob(int columnIndex, NClob nClob)
void	updateNClob(String columnLabel, Reader reader)
void	updateNClob(String columnLabel, Reader reader, long length)
void	updateNClob(String columnName, NClob nClob)
void	updateNString(int columnIndex, String x)	JDBC 4.0 Update a column with NATIONAL CHARACTER.
void	updateNString(String columnName, String x)	JDBC 4.0 Update a column with NATIONAL CHARACTER.
void	updateRowId(int columnIndex, RowId x)
void	updateSQLXML(int columnIndex, SQLXML xmlObject)
void	updateSQLXML(String columnLabel, SQLXML xmlObject)

Methods inherited from class UpdatableResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, checkRowPos, checkUpdatability, deleteRow, first, generateStatements, getConcurrency, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, isUpdatable, last, moveToCurrentRow, moveToInsertRow, next, prev, previous, realClose, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setResultSetConcurrency, syncUpdate, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObjectInternal, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp

Methods inherited from class ResultSetImpl

arraysEqual, buildIndexMapping, checkClosed, checkColumnBounds, clearNextResult, clearWarnings, close, convertLongToUlong, copy, fastDateCreate, fastTimeCreate, fastTimestampCreate, findColumn, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getBytes, getBytesSize, getCalendarInstanceForSessionOrNew, getCharacterStream, getCharacterStream, getClob, getClob, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getDoubleInternal, getDoubleInternal, getExceptionInterceptor, getFetchDirection, getFetchSize, getFirstCharOfQuery, getFloat, getFloat, getGmtCalendar, getId, getInstance, getInstance, getInt, getInt, getLong, getLong, getMetaData, getNativeArray, getNativeAsciiStream, getNativeBigDecimal, getNativeBigDecimal, getNativeBinaryStream, getNativeBlob, getNativeByte, getNativeByte, getNativeBytes, getNativeCharacterStream, getNativeClob, getNativeDate, getNativeDate, getNativeDateViaParseConversion, getNativeDouble, getNativeFloat, getNativeInt, getNativeInt, getNativeLong, getNativeLong, getNativeRef, getNativeShort, getNativeShort, getNativeString, getNativeTimestampViaParseConversion, getNativeTimeViaParseConversion, getNativeUnicodeStream, getNativeURL, getNextResultSet, getObject, getObject, getObject, getObject, getObject, getObject, getObjectStoredProc, getObjectStoredProc, getObjectStoredProc, getObjectStoredProc, getRef, getRef, getRow, getServerInfo, getShort, getShort, getStatement, getString, getString, getStringInternal, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getUpdateCount, getUpdateID, getURL, getURL, getWarnings, initializeFromCachedMetaData, initializeWithMetadata, populateCachedMetaData, reallyResult, redefineFieldsForDBMD, setBinaryEncoded, setFetchDirection, setFetchSize, setFirstCharOfQuery, setNextResultSet, setOwningStatement, setResultSetType, setServerInfo, setStatementUsedForFetchingRows, setWrapperStatement, toString, updateArray, updateArray, updateClob, updateRef, updateRef, wasNull

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface ResultSet

updateObject, updateObject, updateObject, updateObject, updateRowId

Constructor Details

JDBC4UpdatableResultSet

public JDBC4UpdatableResultSet(String catalog,
 Field[] fields,
 RowData tuples,
 MySQLConnection conn,
 StatementImpl creatorStmt)
                        throws SQLException

Throws:

SQLException

Method Details

updateAsciiStream

public void updateAsciiStream(int columnIndex,
 InputStream x)
                       throws SQLException

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
 InputStream x,
 long length)
                       throws SQLException

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
 InputStream x)
                        throws SQLException

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
 InputStream x,
 long length)
                        throws SQLException

Throws:

SQLException

updateBlob

public void updateBlob(int columnIndex,
 InputStream inputStream)
                throws SQLException

Throws:

SQLException

updateBlob

public void updateBlob(int columnIndex,
 InputStream inputStream,
 long length)
                throws SQLException

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
 Reader x)
                           throws SQLException

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
 Reader x,
 long length)
                           throws SQLException

Throws:

SQLException

updateClob

public void updateClob(int columnIndex,
 Reader reader)
                throws SQLException

Throws:

SQLException

updateClob

public void updateClob(int columnIndex,
 Reader reader,
 long length)
                throws SQLException

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
 Reader x)
                            throws SQLException

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
 Reader x,
 long length)
                            throws SQLException

Throws:

SQLException

updateNClob

public void updateNClob(int columnIndex,
 Reader reader)
                 throws SQLException

Throws:

SQLException

updateNClob

public void updateNClob(int columnIndex,
 Reader reader,
 long length)
                 throws SQLException

Throws:

SQLException

updateSQLXML

public void updateSQLXML(int columnIndex,
 SQLXML xmlObject)
                  throws SQLException

Throws:

SQLException

updateRowId

public void updateRowId(int columnIndex,
 RowId x)
                 throws SQLException

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
 InputStream x)
                       throws SQLException

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
 InputStream x,
 long length)
                       throws SQLException

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
 InputStream x)
                        throws SQLException

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
 InputStream x,
 long length)
                        throws SQLException

Throws:

SQLException

updateBlob

public void updateBlob(String columnLabel,
 InputStream inputStream)
                throws SQLException

Throws:

SQLException

updateBlob

public void updateBlob(String columnLabel,
 InputStream inputStream,
 long length)
                throws SQLException

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
 Reader reader)
                           throws SQLException

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
 Reader reader,
 long length)
                           throws SQLException

Throws:

SQLException

updateClob

public void updateClob(String columnLabel,
 Reader reader)
                throws SQLException

Throws:

SQLException

updateClob

public void updateClob(String columnLabel,
 Reader reader,
 long length)
                throws SQLException

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
 Reader reader)
                            throws SQLException

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
 Reader reader,
 long length)
                            throws SQLException

Throws:

SQLException

updateNClob

public void updateNClob(String columnLabel,
 Reader reader)
                 throws SQLException

Throws:

SQLException

updateNClob

public void updateNClob(String columnLabel,
 Reader reader,
 long length)
                 throws SQLException

Throws:

SQLException

updateSQLXML

public void updateSQLXML(String columnLabel,
 SQLXML xmlObject)
                  throws SQLException

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
 Reader x,
 int length)
                            throws SQLException

JDBC 4.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

length - the length of the stream

Throws:

SQLException - if a database-access error occurs

updateNCharacterStream

public void updateNCharacterStream(String columnName,
 Reader reader,
 int length)
                            throws SQLException

JDBC 4.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.

Parameters:

columnName - the name of the column

reader - the new column value

length - of the stream

Throws:

SQLException - if a database-access error occurs

updateNClob

public void updateNClob(int columnIndex,
 NClob nClob)
                 throws SQLException

Throws:

SQLException

See Also:

• invalid reference

  ResultSet#updateNClob(int, NClob)

updateNClob

public void updateNClob(String columnName,
 NClob nClob)
                 throws SQLException

Throws:

SQLException

See Also:

• invalid reference

  ResultSet#updateClob(int, Clob)

updateNString

public void updateNString(int columnIndex,
 String x)
                   throws SQLException

JDBC 4.0 Update a column with NATIONAL CHARACTER. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

SQLException - if a database-access error occurs

updateNString

public void updateNString(String columnName,
 String x)
                   throws SQLException

JDBC 4.0 Update a column with NATIONAL CHARACTER. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.

Parameters:

columnName - the name of the column

x - the new column value

Throws:

SQLException - if a database-access error occurs

getHoldability

public int getHoldability()
                   throws SQLException

Throws:

SQLException

getNativeNClob

protected NClob getNativeNClob(int columnIndex)
                        throws SQLException

JDBC 4.0 Get a NCLOB column.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

an object representing a NCLOB

Throws:

SQLException - if an error occurs

getNCharacterStream

public Reader getNCharacterStream(int columnIndex)
                           throws SQLException

JDBC 4.0

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

Parameters:

columnIndex - the column to get the value from

Returns:

the value in the column as a java.io.Reader.

Throws:

SQLException - if an error occurs

getNCharacterStream

public Reader getNCharacterStream(String columnName)
                           throws SQLException

JDBC 4.0

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

Parameters:

columnName - the column name to retrieve the value from

Returns:

the value as a java.io.Reader

Throws:

SQLException - if an error occurs

getNClob

public NClob getNClob(int columnIndex)
               throws SQLException

JDBC 4.0 Get a NCLOB column.

Parameters:

i - the first column is 1, the second is 2, ...

Returns:

an object representing a NCLOB

Throws:

SQLException - if an error occurs

getNClob

public NClob getNClob(String columnName)
               throws SQLException

JDBC 4.0 Get a NCLOB column.

Parameters:

colName - the column name

Returns:

an object representing a NCLOB

Throws:

SQLException - if an error occurs

getNString

public String getNString(int columnIndex)
                  throws SQLException

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

Parameters:

columnIndex - the first column is 1, the second is 2...

Returns:

the column value, null for SQL NULL

Throws:

SQLException - if a database access error occurs

getNString

public String getNString(String columnName)
                  throws SQLException

JDBC 4.0 The following routines simply convert the columnName into a columnIndex and then call the appropriate routine above.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value

Throws:

SQLException - if a database access error occurs

getRowId

public RowId getRowId(int columnIndex)
               throws SQLException

Throws:

SQLException

getRowId

public RowId getRowId(String columnLabel)
               throws SQLException

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(int columnIndex)
                 throws SQLException

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(String columnLabel)
                 throws SQLException

Throws:

SQLException

isClosed

public boolean isClosed()
                 throws SQLException

Description copied from class: ResultSetImpl

Returns true if this ResultSet is closed.

Specified by:

isClosed in interface ResultSet

Specified by:

isClosed in interface ResultSetInternalMethods

Overrides:

isClosed in class ResultSetImpl

Throws:

SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.

Parameters:

interfaces - a Class defining an interface.

Returns:

true if this implements the interface or directly or indirectly wraps an object that does.

Throws:

SQLException - if an error occurs while determining whether this is a wrapper for an object with the given interface.

Since:

1.6

unwrap

public <T> T unwrap(Class<T> iface)
             throws SQLException

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. The result may be either the object found to implement the interface or a proxy for that object. If the receiver implements the interface then that is the object. If the receiver is a wrapper and the wrapped object implements the interface then that is the object. Otherwise the object is the result of calling unwrap recursively on the wrapped object. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.

Parameters:

iface - A Class defining an interface that the result must implement.

Returns:

an object that implements the interface. May be a proxy for the actual implementing object.

Throws:

SQLException - If no object found that implements the interface

Since:

1.6