Class AS400JDBCResultSet
- java.lang.Object
-
- com.ibm.as400.access.AS400JDBCResultSet
-
- All Implemented Interfaces:
- java.sql.ResultSet, java.sql.Wrapper
public class AS400JDBCResultSet extends java.lang.Object implements java.sql.ResultSet
The AS400JDBCResultSet class provides access to a table of data generated by a database query.
A result set maintains a cursor pointing to its current row of data. Initially, the cursor is positioned before the first row. If the result set is scrollable, use any of the cursor positioning methods to move the cursor within the result set. If the result set is not scrollable, then only use next() to move the cursor.
The get methods retrieve column values for the current row. Values can be retrieved using either the column index or the column name. In general, using the column index is more efficient. Column indexes are numbered starting with 1. Column names are not case sensitive. If several columns have the same name, then the first matching column is used.
Columns can have two names: a column name ("long name") and a system column name ("short name"). The get methods and findColumn() only support using the column name.
In each get method, the driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. If such a conversion is not appropriate, an SQLException is thrown.
If the result set is updatable, the update methods modify column values for the current row, but not in the underlying database. updateRow() causes all updates to the current row to be written to the database. Use deleteRow() to delete the current row in the database.
For updatable result sets, there is also an insert row, which is used as a staging area for the contents of a new row. Use moveToInsertRow() to position the cursor to the insert row. Once all updates to the insert row have been made, use insertRow() to insert the row into the database.
In the following cases, result sets are always read only regardless of the concurrency set in the statement:
- Stored procedure calls
- DatabaseMetaData catalog methods
In the following case, result sets are always read only regardless of the concurrency set in the statement if connecting to a system running OS/400 V4R5 or a previous release:
- SELECT statements which do not specify FOR UPDATE
In the following case, result sets are always forward only regardless of the type set in the statement:
- Stored procedure calls
A result set is automatically closed by the statement that generated it when the statement is closed, run again, or used to retrieve the next result set from a sequence of multiple result sets.
The new JDBC 3.0 methods add the ability to retrieve information by column name in addition to column index. Be aware you will see better performance accessing columns by their index rather than accessing them by their name.
-
-
Method Summary
Methods Modifier and Type Method and Description boolean
absolute(int rowNumber)
Positions the cursor to an absolute row number.protected void
addSavedException(java.sql.SQLException savedException)
void
afterLast()
Positions the cursor after the last row.void
beforeFirst()
Positions the cursor before the first row.void
cancelRowUpdates()
Cancels all pending updates that have been made since the last call to updateRow().void
clearWarnings()
Clears all warnings that have been reported for the result set.void
close()
Releases the result set's resources immediately instead of waiting for them to be automatically released.void
deleteRow()
Deletes the current row from the result set and the database.protected void
finalize()
Closes the result set if not explicitly closed by the caller.int
findColumn(java.lang.String columnName)
Returns the column index for the specified column name.boolean
first()
Positions the cursor to the first row.java.sql.Array
getArray(int columnIndex)
Returns the value of a column as an Array object.java.sql.Array
getArray(java.lang.String columnName)
Returns the value of a column as an Array object.java.io.InputStream
getAsciiStream(int columnIndex)
Returns the value of a column as a stream of ASCII characters.java.io.InputStream
getAsciiStream(java.lang.String columnName)
Returns the value of a column as a stream of ASCII characters.java.math.BigDecimal
getBigDecimal(int columnIndex)
Returns the value of a column as a BigDecimal object.java.math.BigDecimal
getBigDecimal(int columnIndex, int scale)
Deprecated.Use getBigDecimal(int) instead.java.math.BigDecimal
getBigDecimal(java.lang.String columnName)
Returns the value of a column as a BigDecimal object.java.math.BigDecimal
getBigDecimal(java.lang.String columnName, int scale)
Deprecated.Use getBigDecimal(String) instead.java.io.InputStream
getBinaryStream(int columnIndex)
Returns the value of a column as a stream of uninterpreted bytes.java.io.InputStream
getBinaryStream(java.lang.String columnName)
Returns the value of a column as a stream of uninterpreted bytes.java.sql.Blob
getBlob(int columnIndex)
Returns the value of a column as a Blob object.java.sql.Blob
getBlob(java.lang.String columnName)
Returns the value of a column as a Blob object.boolean
getBoolean(int columnIndex)
Returns the value of a column as a Java boolean value.boolean
getBoolean(java.lang.String columnName)
Returns the value of a column as a Java boolean value.byte
getByte(int columnIndex)
Returns the value of a column as a Java byte value.byte
getByte(java.lang.String columnName)
Returns the value of a column as a Java byte value.byte[]
getBytes(int columnIndex)
Returns the value of a column as a Java byte array.byte[]
getBytes(java.lang.String columnName)
Returns the value of a column as a Java byte array.java.io.Reader
getCharacterStream(int columnIndex)
Returns the value of a column as a character stream.java.io.Reader
getCharacterStream(java.lang.String columnName)
Returns the value of a column as a character stream.java.sql.Clob
getClob(int columnIndex)
Returns the value of a column as a Clob object.java.sql.Clob
getClob(java.lang.String columnName)
Returns the value of a column as a Clob object.int
getConcurrency()
Returns the result set concurrency.java.lang.String
getCursorName()
Returns the name of the SQL cursor in use by the result set.java.sql.Date
getDate(int columnIndex)
Returns the value of a column as a java.sql.Date object using the default calendar.java.sql.Date
getDate(int columnIndex, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default.java.sql.Date
getDate(java.lang.String columnName)
Returns the value of a column as a java.sql.Date object using the default calendar.java.sql.Date
getDate(java.lang.String columnName, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default.double
getDouble(int columnIndex)
Returns the value of a column as a Java double value.double
getDouble(java.lang.String columnName)
Returns the value of a column as a Java double value.int
getFetchDirection()
Returns the fetch direction.int
getFetchSize()
Returns the fetch size.float
getFloat(int columnIndex)
Returns the value of a column as a Java float value.float
getFloat(java.lang.String columnName)
Returns the value of a column as a Java float value.int
getHoldability()
Retrieves the holdability of thisResultSet
objectint
getInt(int columnIndex)
Returns the value of a column as a Java int value.int
getInt(java.lang.String columnName)
Returns the value of a column as a Java int value.long
getLong(int columnIndex)
Returns the value of a column as a Java long value.long
getLong(java.lang.String columnName)
Returns the value of a column as a Java long value.java.sql.ResultSetMetaData
getMetaData()
Returns the ResultSetMetaData object that describes the result set's columns.java.io.Reader
getNCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.java.io.Reader
getNCharacterStream(java.lang.String columnName)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object.java.sql.NClob
getNClob(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.java.sql.NClob
getNClob(java.lang.String columnName)
Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.java.lang.String
getNString(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.java.lang.String
getNString(java.lang.String columnName)
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language.java.lang.Object
getObject(int columnIndex)
Returns the value of a column as a Java Object.java.lang.Object
getObject(int columnIndex, java.lang.Class type)
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.java.lang.Object
getObject(int columnIndex, java.util.Map typeMap)
Returns the value of a column as a Java Object.java.lang.Object
getObject(java.lang.String columnName)
Returns the value of a column as a Java Object.java.lang.Object
getObject(java.lang.String columnLabel, java.lang.Class type)
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.java.lang.Object
getObject(java.lang.String columnName, java.util.Map typeMap)
Returns the value of a column as a Java Object.java.sql.Ref
getRef(int columnIndex)
Returns the value of a column as a Ref object.java.sql.Ref
getRef(java.lang.String columnName)
Returns the value of a column as a Ref object.int
getRow()
Returns the current row number, or 0.java.sql.RowId
getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.java.sql.RowId
getRowId(java.lang.String columnName)
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.short
getShort(int columnIndex)
Returns the value of a column as a Java short value.short
getShort(java.lang.String columnName)
Returns the value of a column as a Java short value.java.sql.SQLXML
getSQLXML(int columnIndex)
Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.java.sql.SQLXML
getSQLXML(java.lang.String columnName)
Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.java.sql.Statement
getStatement()
Returns the statement for this result set.java.lang.String
getString(int columnIndex)
Returns the value of a column as a String object.java.lang.String
getString(java.lang.String columnName)
Returns the value of a column as a String object.java.sql.Time
getTime(int columnIndex)
Returns the value of a column as a java.sql.Time object using the default calendar.java.sql.Time
getTime(int columnIndex, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Time object using a calendar other than the default.java.sql.Time
getTime(java.lang.String columnName)
Returns the value of a column as a java.sql.Time object using the default calendar.java.sql.Time
getTime(java.lang.String columnName, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Time object using a calendar other than the default.java.sql.Timestamp
getTimestamp(int columnIndex)
Returns the value of a column as a java.sql.Timestamp object using the default calendar.java.sql.Timestamp
getTimestamp(int columnIndex, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.java.sql.Timestamp
getTimestamp(java.lang.String columnName)
Returns the value of a column as a java.sql.Timestamp object using the default calendar.java.sql.Timestamp
getTimestamp(java.lang.String columnName, java.util.Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.int
getType()
Returns the result set type.java.io.InputStream
getUnicodeStream(int columnIndex)
Deprecated.Use getCharacterStream(int) instead.java.io.InputStream
getUnicodeStream(java.lang.String columnName)
Deprecated.Use getCharacterStream(String) instead.java.net.URL
getURL(int columnIndex)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.java.net.URL
getURL(java.lang.String columnName)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.protected java.lang.String[]
getValidWrappedList()
java.sql.SQLWarning
getWarnings()
Returns the first warning reported for the result set.void
insertRow()
Inserts the contents of the insert row into the result set and the database.boolean
isAfterLast()
Indicates if the cursor is positioned after the last row.boolean
isBeforeFirst()
Indicates if the cursor is positioned before the first row.boolean
isClosed()
Indicates if the result set is closed.boolean
isFirst()
Indicates if the cursor is positioned on the first row.boolean
isLast()
Indicates if the cursor is positioned on the last row.boolean
isWrapperFor(java.lang.Class<?> iface)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.boolean
last()
Positions the cursor to the last row.void
moveToCurrentRow()
Positions the cursor to the current row.void
moveToInsertRow()
Positions the cursor to the insert row.boolean
next()
Positions the cursor to the next row.boolean
previous()
Positions the cursor to the previous row.void
refreshRow()
Refreshes the current row from the database and cancels all pending updates that have been made since the last call to updateRow().boolean
relative(int rowNumber)
Positions the cursor to a relative row number.boolean
rowDeleted()
Indicates if the current row has been deleted.boolean
rowInserted()
Indicates if the current row has been inserted.boolean
rowUpdated()
Indicates if the current row has been updated.void
setFetchDirection(int fetchDirection)
Sets the direction in which the rows in a result set are processed.void
setFetchSize(int fetchSize)
Sets the number of rows to be fetched from the database when more rows are needed.java.lang.String
toString()
Returns the name of the SQL cursor in use by the result set.<T> T
unwrap(java.lang.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
updateArray(int columnIndex, java.sql.Array columnValue)
Updates the value of a column as an Array object.void
updateArray(java.lang.String columnName, java.sql.Array columnValue)
Updates the value of a column as an Array object.void
updateAsciiStream(int columnIndex, java.io.InputStream x)
Updates the designated column with an ascii stream value.void
updateAsciiStream(int columnIndex, java.io.InputStream columnValue, int length)
Updates a column in the current row using an ASCII stream value.void
updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with an ascii stream value.void
updateAsciiStream(java.lang.String columnName, java.io.InputStream columnValue, int length)
Updates a column in the current row using an ASCII stream value.void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.void
updateBigDecimal(int columnIndex, java.math.BigDecimal columnValue)
Updates a column in the current row using a BigDecimal value.void
updateBigDecimal(java.lang.String columnName, java.math.BigDecimal columnValue)
Updates a column in the current row using a BigDecimal value.void
updateBinaryStream(int columnIndex, java.io.InputStream x)
Updates the designated column with a binary stream value.void
updateBinaryStream(int columnIndex, java.io.InputStream columnValue, int length)
Updates a column in the current row using a binary stream value.void
updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with a binary stream value.void
updateBinaryStream(java.lang.String columnName, java.io.InputStream columnValue, int length)
Updates a column in the current row using a binary stream value.void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.void
updateBlob(int columnIndex, java.sql.Blob columnValue)
Updates a column in the current row using a Java Blob value.void
updateBlob(int columnIndex, java.io.InputStream inputStream)
Updates the designated column using the given input stream.void
updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.void
updateBlob(java.lang.String columnName, java.sql.Blob columnValue)
Updates a column in the current row using a Java Blob value.void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
Updates the designated column using the given input stream.void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.void
updateBoolean(int columnIndex, boolean columnValue)
Updates a column in the current row using a Java boolean value.void
updateBoolean(java.lang.String columnName, boolean columnValue)
Updates a column in the current row using a Java boolean value.void
updateByte(int columnIndex, byte columnValue)
Updates a column in the current row using a Java byte value.void
updateByte(java.lang.String columnName, byte columnValue)
Updates a column in the current row using a Java byte value.void
updateBytes(int columnIndex, byte[] columnValue)
Updates a column in the current row using a Java byte array value.void
updateBytes(java.lang.String columnName, byte[] columnValue)
Updates a column in the current row using a Java byte array value.void
updateCharacterStream(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value.void
updateCharacterStream(int columnIndex, java.io.Reader columnValue, int length)
Updates a column in the current row using a Reader value.void
updateCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value.void
updateCharacterStream(java.lang.String columnName, java.io.Reader columnValue, int length)
Updates a column in the current row using a Reader value.void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
updateClob(int columnIndex, java.sql.Clob columnValue)
Updates a column in the current row using a Java Clob value.void
updateClob(int columnIndex, java.io.Reader reader)
Updates the designated column using the givenReader
object.void
updateClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
updateClob(java.lang.String columnName, java.sql.Clob columnValue)
Updates a column in the current row using a Java Clob value.void
updateClob(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the givenReader
object.void
updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
updateDate(int columnIndex, java.sql.Date columnValue)
Updates a column in the current row using a java.sql.Date value.void
updateDate(java.lang.String columnName, java.sql.Date columnValue)
Updates a column in the current row using a java.sql.Date value.void
updateDB2Default(int columnIndex)
Updates a column in the current row to the SQL Default.void
updateDB2Default(java.lang.String columnName)
Updates a column in the current row to the SQL Default.void
updateDB2Unassigned(int columnIndex)
Updates a column in the current row to the SQL Unassigned.void
updateDB2Unassigned(java.lang.String columnName)
Updates a column in the current row to the SQL Unassigned.void
updateDBDefault(int columnIndex)
Updates a column in the current row to the SQL Default.void
updateDBDefault(java.lang.String columnName)
Updates a column in the current row to the SQL Default.void
updateDBUnassigned(int columnIndex)
Updates a column in the current row to the SQL Unassigned.void
updateDBUnassigned(java.lang.String columnName)
Updates a column in the current row to the SQL Unassigned.void
updateDouble(int columnIndex, double columnValue)
Updates a column in the current row using a Java double value.void
updateDouble(java.lang.String columnName, double columnValue)
Updates a column in the current row using a Java double value.void
updateFloat(int columnIndex, float columnValue)
Updates a column in the current row using a Java float value.void
updateFloat(java.lang.String columnName, float columnValue)
Updates a column in the current row using a Java float value.void
updateInt(int columnIndex, int columnValue)
Updates a column in the current row using a Java int value.void
updateInt(java.lang.String columnName, int columnValue)
Updates a column in the current row using a Java int value.void
updateLong(int columnIndex, long columnValue)
Updates a column in the current row using a Java long value.void
updateLong(java.lang.String columnName, long columnValue)
Updates a column in the current row using a Java long value.void
updateNCharacterStream(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value.void
updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value.void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.void
updateNClob(int columnIndex, java.sql.NClob nClob)
Updates the designated column with ajava.sql.NClob
value.void
updateNClob(int columnIndex, java.io.Reader reader)
Updates the designated column using the givenReader
The data will be read from the stream as needed until end-of-stream is reached.void
updateNClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
updateNClob(java.lang.String columnName, java.sql.NClob nClob)
Updates the designated column with ajava.sql.NClob
value.void
updateNClob(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the givenReader
object.void
updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the givenReader
object, which is the given number of characters long.void
updateNString(int columnIndex, java.lang.String nString)
Updates the designated column with aString
value.void
updateNString(java.lang.String columnName, java.lang.String nString)
Updates the designated column with aString
value.void
updateNull(int columnIndex)
Updates a column in the current row using SQL NULL.void
updateNull(java.lang.String columnName)
Updates a column in the current row using SQL NULL.void
updateObject(int columnIndex, java.lang.Object columnValue)
Updates a column in the current row using an Object value.void
updateObject(int columnIndex, java.lang.Object columnValue, int scale)
Updates a column in the current row using an Object value.void
updateObject(java.lang.String columnName, java.lang.Object columnValue)
Updates a column in the current row using an Object value.void
updateObject(java.lang.String columnName, java.lang.Object columnValue, int scale)
Updates a column in the current row using an Object value.void
updateRef(int columnIndex, java.sql.Ref columnValue)
Updates the value of an SQL REF output parameter as a Ref value.void
updateRef(java.lang.String columnName, java.sql.Ref columnValue)
Updates the value of an SQL REF output parameter as a Ref value.void
updateRow()
Updates the database with the new contents of the current row.void
updateRowId(int columnIndex, java.sql.RowId x)
Updates the designated column with aRowId
value.void
updateRowId(java.lang.String columnName, java.sql.RowId x)
Updates the designated column with aRowId
value.void
updateShort(int columnIndex, short columnValue)
Updates a column in the current row using a Java short value.void
updateShort(java.lang.String columnName, short columnValue)
Updates a column in the current row using a Java short value.void
updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
Updates the designated column with ajava.sql.SQLXML
value.void
updateSQLXML(java.lang.String columnName, java.sql.SQLXML xmlObject)
Updates the designated column with ajava.sql.SQLXML
value.void
updateString(int columnIndex, java.lang.String columnValue)
Updates a column in the current row using a String value.void
updateString(java.lang.String columnName, java.lang.String columnValue)
Updates a column in the current row using a String value.void
updateTime(int columnIndex, java.sql.Time columnValue)
Updates a column in the current row using a java.sql.Time value.void
updateTime(java.lang.String columnName, java.sql.Time columnValue)
Updates a column in the current row using a java.sql.Time value.void
updateTimestamp(int columnIndex, java.sql.Timestamp columnValue)
Updates a column in the current row using a java.sql.Timestamp value.void
updateTimestamp(java.lang.String columnName, java.sql.Timestamp columnValue)
Updates a column in the current row using a java.sql.Timestamp value.boolean
wasNull()
Indicates if the last column read has the value of SQL NULL.
-
-
-
Method Detail
-
clearWarnings
public void clearWarnings() throws java.sql.SQLException
Clears all warnings that have been reported for the result set. After this call, getWarnings() returns null until a new warning is reported for the result set.- Specified by:
clearWarnings
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If an error occurs.
-
close
public void close() throws java.sql.SQLException
Releases the result set's resources immediately instead of waiting for them to be automatically released.- Specified by:
close
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If an error occurs.
-
finalize
protected void finalize() throws java.lang.Throwable
Closes the result set if not explicitly closed by the caller.- Overrides:
finalize
in classjava.lang.Object
- Throws:
java.lang.Throwable
- If an error occurs.
-
findColumn
public int findColumn(java.lang.String columnName) throws java.sql.SQLException
Returns the column index for the specified column name. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.findColumn("\"MixedCase\"").- Specified by:
findColumn
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column index (1-based).
- Throws:
java.sql.SQLException
- If the result set is not open or the column name is not found.
-
getConcurrency
public int getConcurrency() throws java.sql.SQLException
Returns the result set concurrency.- Specified by:
getConcurrency
in interfacejava.sql.ResultSet
- Returns:
- The result set concurrency. Valid values are:
- CONCUR_READ_ONLY
- CONCUR_UPDATABLE
- Throws:
java.sql.SQLException
- If the result set is not open.
-
getCursorName
public java.lang.String getCursorName() throws java.sql.SQLException
Returns the name of the SQL cursor in use by the result set. In SQL, results are retrieved through a named cursor. The current row of a result can be updated or deleted using a positioned UPDATE or DELETE statement that references a cursor name.Cursor names are case sensitive. However, when using a cursor name within other SQL positioned UPDATE or DELETE statements, the cursor name will be uppercased. If you use a cursor name with lowercase characters, you need to enclose it in double quotes when referring to it in other SQL statements.
- Specified by:
getCursorName
in interfacejava.sql.ResultSet
- Returns:
- The cursor name.
- Throws:
java.sql.SQLException
- If the result is not open.
-
getFetchDirection
public int getFetchDirection() throws java.sql.SQLException
Returns the fetch direction.- Specified by:
getFetchDirection
in interfacejava.sql.ResultSet
- Returns:
- The fetch direction.
Valid values are:
- FETCH_FORWARD
- FETCH_REVERSE
- FETCH_UNKNOWN
- Throws:
java.sql.SQLException
- If the result is not open.
-
getFetchSize
public int getFetchSize() throws java.sql.SQLException
Returns the fetch size.- Specified by:
getFetchSize
in interfacejava.sql.ResultSet
- Returns:
- The fetch size.
- Throws:
java.sql.SQLException
- If the result is not open.
-
getStatement
public java.sql.Statement getStatement() throws java.sql.SQLException
Returns the statement for this result set.- Specified by:
getStatement
in interfacejava.sql.ResultSet
- Returns:
- The statement for this result set, or null if the result set was returned by a DatabaseMetaData catalog method.
- Throws:
java.sql.SQLException
- If an error occurs.
-
getType
public int getType() throws java.sql.SQLException
Returns the result set type. If the statement requested a result set type ResultSet.TYPE_FORWARD_ONLY, then the result set type will be ResultSet.TYPE_FORWARD_ONLY. Otherwise, the result set type may be a type other than the requested type if the SQL statement that generated the result set specified a different cursor type when opening the cursor.- Specified by:
getType
in interfacejava.sql.ResultSet
- Returns:
- The result set type. Valid values are:
- TYPE_FORWARD_ONLY
- TYPE_SCROLL_INSENSITIVE
- TYPE_SCROLL_SENSITIVE
- Throws:
java.sql.SQLException
- If the result set is not open.- Since:
- Modification 5
-
getURL
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.- Specified by:
getURL
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The parameter value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter name is not registered as an output parameter, the statement was not executed or the requested conversion is not valid.- Since:
- Modification 5
-
getURL
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.- Specified by:
getURL
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The parameter value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter name is not registered as an output parameter, the statement was not executed or the requested conversion is not valid.
-
getWarnings
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
Returns the first warning reported for the result set. Subsequent warnings may be chained to this warning.- Specified by:
getWarnings
in interfacejava.sql.ResultSet
- Returns:
- The first warning or null if no warnings have been reported.
- Throws:
java.sql.SQLException
- If an error occurs.
-
isClosed
public boolean isClosed() throws java.sql.SQLException
Indicates if the result set is closed.- Specified by:
isClosed
in interfacejava.sql.ResultSet
- Returns:
- true if this result set is closed; false otherwise.
- Throws:
java.sql.SQLException
-
setFetchDirection
public void setFetchDirection(int fetchDirection) throws java.sql.SQLException
Sets the direction in which the rows in a result set are processed.- Specified by:
setFetchDirection
in interfacejava.sql.ResultSet
- Parameters:
fetchDirection
- The fetch direction for processing rows. Valid values are:- FETCH_FORWARD
- FETCH_REVERSE
- FETCH_UNKNOWN
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is scrollable and the input value is not ResultSet.FETCH_FORWARD, or the input value is not valid.
-
setFetchSize
public void setFetchSize(int fetchSize) throws java.sql.SQLException
Sets the number of rows to be fetched from the database when more rows are needed. This may be changed at any time. If the value specified is zero, then the driver will choose an appropriate fetch size.This setting only affects statements that meet the criteria specified in the "block criteria" property. The fetch size is only used if the "block size" property is set to "0".
- Specified by:
setFetchSize
in interfacejava.sql.ResultSet
- Parameters:
fetchSize
- The number of rows. This must be greater than or equal to 0 and less than or equal to the maximum rows limit. The default is the statement's fetch size.- Throws:
java.sql.SQLException
- If the result set is not open or the input value is not valid.
-
toString
public java.lang.String toString()
Returns the name of the SQL cursor in use by the result set.- Overrides:
toString
in classjava.lang.Object
- Returns:
- The cursor name.
-
absolute
public boolean absolute(int rowNumber) throws java.sql.SQLException
Positions the cursor to an absolute row number.Attempting to move any number of positions before the first row positions the cursor to before the first row. Attempting to move beyond the last row positions the cursor after the last row.
If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
- Specified by:
absolute
in interfacejava.sql.ResultSet
- Parameters:
rowNumber
- The absolute row number. If the absolute row number is positive, this positions the cursor with respect to the beginning of the result set. If the absolute row number is negative, this positions the cursor with respect to the end of result set.- Returns:
- true if the requested cursor position is valid; false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, the row number is 0, or an error occurs.
-
afterLast
public void afterLast() throws java.sql.SQLException
Positions the cursor after the last row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
afterLast
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
beforeFirst
public void beforeFirst() throws java.sql.SQLException
Positions the cursor before the first row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
beforeFirst
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
first
public boolean first() throws java.sql.SQLException
Positions the cursor to the first row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
first
in interfacejava.sql.ResultSet
- Returns:
- true if the requested cursor position is valid; false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
getRow
public int getRow() throws java.sql.SQLException
Returns the current row number, or 0.0 is returned if the cursor is not on a valid row (such as before the first row, after the last row, or on the insert row), or if the result set is empty.
This method may be slow if cursor movement based on the end of the result set is used. Methods such as last(), afterLast() and absolute() with a negative value will move the cursor based on the end of the result set. This method will be slow in these cases because internally the method must get every row to determine how many rows are in the result set before calculating the current row. The system does not know how many rows are in the result set until every row is touched. That is why this method may start at the highest row retrieved so far, then do next() until the last row is retrieved.
Once the maximum number of rows in the result set is determined, it does not change until the result set is closed.
- Specified by:
getRow
in interfacejava.sql.ResultSet
- Returns:
- The current row number (1-based), or 0 if the current row is not valid.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
isAfterLast
public boolean isAfterLast() throws java.sql.SQLException
Indicates if the cursor is positioned after the last row.- Specified by:
isAfterLast
in interfacejava.sql.ResultSet
- Returns:
- true if the cursor is positioned after the last row; false if the cursor is not positioned after the last row or if the result set contains no rows.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
isBeforeFirst
public boolean isBeforeFirst() throws java.sql.SQLException
Indicates if the cursor is positioned before the first row.- Specified by:
isBeforeFirst
in interfacejava.sql.ResultSet
- Returns:
- true if the cursor is positioned before the first row; false if the cursor is not positioned before the first row or if the result set contains no rows.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
isFirst
public boolean isFirst() throws java.sql.SQLException
Indicates if the cursor is positioned on the first row.- Specified by:
isFirst
in interfacejava.sql.ResultSet
- Returns:
- true if the cursor is positioned on the first row; false if the cursor is not positioned on the first row or the row number can not be determined.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
isLast
public boolean isLast() throws java.sql.SQLException
Indicates if the cursor is positioned on the last row.- Specified by:
isLast
in interfacejava.sql.ResultSet
- Returns:
- true if the cursor is positioned on the last row; false if the cursor is not positioned on the last row or the row number can not be determined.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
last
public boolean last() throws java.sql.SQLException
Positions the cursor to the last row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
last
in interfacejava.sql.ResultSet
- Returns:
- true if the requested cursor position is valid; false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
moveToCurrentRow
public void moveToCurrentRow() throws java.sql.SQLException
Positions the cursor to the current row. This is the row where the cursor was positioned before moving it to the insert row. If the cursor is not on the insert row, then this has no effect.If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
- Specified by:
moveToCurrentRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
moveToInsertRow
public void moveToInsertRow() throws java.sql.SQLException
Positions the cursor to the insert row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
moveToInsertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, the result set is not updatable, or an error occurs.
-
next
public boolean next() throws java.sql.SQLException
Positions the cursor to the next row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
next
in interfacejava.sql.ResultSet
- Returns:
- true if the requested cursor position is valid; false if there are no more rows.
- Throws:
java.sql.SQLException
- If the result set is not open, or an error occurs.
-
previous
public boolean previous() throws java.sql.SQLException
Positions the cursor to the previous row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
previous
in interfacejava.sql.ResultSet
- Returns:
- true if the requested cursor position is valid; false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.
-
refreshRow
public void refreshRow() throws java.sql.SQLException
Refreshes the current row from the database and cancels all pending updates that have been made since the last call to updateRow(). This method provides a way for an application to explicitly refetch a row from the database. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.- Specified by:
refreshRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, the cursor is not positioned on a row, the cursor is positioned on the insert row or an error occurs.
-
relative
public boolean relative(int rowNumber) throws java.sql.SQLException
Positions the cursor to a relative row number.Attempting to move beyond the first row positions the cursor before the first row. Attempting to move beyond the last row positions the cursor after the last row.
If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
- Specified by:
relative
in interfacejava.sql.ResultSet
- Parameters:
rowNumber
- The relative row number. If the relative row number is positive, this positions the cursor after the current position. If the relative row number is negative, this positions the cursor before the current position. If the relative row number is 0, then the cursor position does not change.- Returns:
- true if the requested cursor position is valid, false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, the cursor is not positioned on a valid row, or an error occurs.
-
getArray
public java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
Returns the value of a column as an Array object. DB2 for IBM i does not support arrays.- Specified by:
getArray
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support arrays.
-
getArray
public java.sql.Array getArray(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as an Array object. DB2 for IBM i does not support arrays. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getArray("\"MixedCase\"").- Specified by:
getArray
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support arrays.
-
getAsciiStream
public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a stream of ASCII characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getAsciiStream
public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a stream of ASCII characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getAsciiStream("\"MixedCase\"").- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBigDecimal("\"MixedCase\"").- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
Deprecated. Use getBigDecimal(int) instead.Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).scale
- The number of digits after the decimal.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the scale is not valid, or the requested conversion is not valid.- See Also:
getBigDecimal(int)
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
Deprecated. Use getBigDecimal(String) instead.Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBigDecimal("\"MixedCase\"", 0).- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.scale
- The number of digits after the decimal.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, the scale is not valid, or the requested conversion is not valid.- See Also:
getBigDecimal(String)
-
getBinaryStream
public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a stream of uninterpreted bytes. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getBinaryStream
public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a stream of uninterpreted bytes. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBinaryStream("\"MixedCase\"").- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getBlob
public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Blob object. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB.- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getBlob
public java.sql.Blob getBlob(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Blob object. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBlob("\"MixedCase\"").- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getBoolean
public boolean getBoolean(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java boolean value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or false if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getBoolean
public boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java boolean value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBoolean("\"MixedCase\"").- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or false if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getByte
public byte getByte(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java byte value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getByte
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getByte
public byte getByte(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java byte value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getByte("\"MixedCase\"").- Specified by:
getByte
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getBytes
public byte[] getBytes(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java byte array. This can be used to get values from columns with SQL types BINARY and VARBINARY.This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.
- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getBytes
public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java byte array. This can be used to get values from columns with SQL types BINARY and VARBINARY. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getBytes("\"MixedCase\"").This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.
- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getCharacterStream
public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a character stream. This can be used to to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a character stream. This can be used to to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getCharacterStream("\"MixedCase\"").- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not valid, or the requested conversion is not valid.
-
getClob
public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Clob object. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and CLOB.- Specified by:
getClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getClob
public java.sql.Clob getClob(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Clob object. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and CLOB. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getClob("\"MixedCase\"").- Specified by:
getClob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getDate
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getDate
public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getDate("\"MixedCase\"").- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getDate
public java.sql.Date getDate(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.
-
getDate
public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getDate("\"MixedCase\"", calendar).- Specified by:
getDate
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.
-
getDouble
public double getDouble(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java double value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getDouble
public double getDouble(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java double value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getDouble("\"MixedCase\"").- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getFloat
public float getFloat(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java float value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getFloat
public float getFloat(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java float value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getFloat("\"MixedCase\"").- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getInt
public int getInt(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java int value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getInt
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getInt
public int getInt(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java int value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getInt("\"MixedCase\"").- Specified by:
getInt
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getLong
public long getLong(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java long value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getLong
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getLong
public long getLong(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java long value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getLong("\"MixedCase\"").- Specified by:
getLong
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
Returns the ResultSetMetaData object that describes the result set's columns.- Specified by:
getMetaData
in interfacejava.sql.ResultSet
- Returns:
- The metadata object.
- Throws:
java.sql.SQLException
- If an error occurs.
-
getObject
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types. If the column is a user-defined type, then the connection's type map is used to created the object.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getObject
public java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types. If the column is a user-defined type, then the connection's type map is used to created the object. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getObject("\"MixedCase\"").- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getObject
public java.lang.Object getObject(int columnIndex, java.util.Map typeMap) throws java.sql.SQLException
Returns the value of a column as a Java Object.- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).typeMap
- The type map. This is not used.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the type map is null, or the requested conversion is not valid.
-
getObject
public java.lang.Object getObject(java.lang.String columnName, java.util.Map typeMap) throws java.sql.SQLException
Returns the value of a column as a Java Object. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getObject("\"MixedCase\"", typeMap).- Specified by:
getObject
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.typeMap
- The type map. This is not used.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, the type map is null, or the requested conversion is not valid.
-
getRef
public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Ref object. DB2 for IBM i does not support structured types.- Specified by:
getRef
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support structured types.
-
getRef
public java.sql.Ref getRef(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Ref object. DB2 for IBM i does not support structured types. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getRef("\"MixedCase\"").- Specified by:
getRef
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support structured types.
-
getShort
public short getShort(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a Java short value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.- Specified by:
getShort
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getShort
public short getShort(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a Java short value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getShort("\"MixedCase\"").- Specified by:
getShort
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or 0 if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getString
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a String object. This can be used to get values from columns with any SQL type.- Specified by:
getString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getString
public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a String object. This can be used to get values from columns with any SQL type. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getString("\"MixedCase\"").- Specified by:
getString
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getTime
public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getTime
public java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getTime("\"MixedCase\"").- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getTime
public java.sql.Time getTime(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.
-
getTime
public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getTime("\"MixedCase\"", calendar).- Specified by:
getTime
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getTimestamp("\"MixedCase\"").- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getTimestamp("\"MixedCase\"", calendar).- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.calendar
- The calendar.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.
-
getUnicodeStream
public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
Deprecated. Use getCharacterStream(int) instead.Returns the value of a column as a stream of Unicode characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.- See Also:
getCharacterStream(int)
-
getUnicodeStream
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
Deprecated. Use getCharacterStream(String) instead.Returns the value of a column as a stream of Unicode characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.getUnicodeStream("\"MixedCase\"").- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Returns:
- The column value or null if the value is SQL NULL.
- Throws:
java.sql.SQLException
- If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.- See Also:
getCharacterStream(String)
-
wasNull
public boolean wasNull() throws java.sql.SQLException
Indicates if the last column read has the value of SQL NULL.- Specified by:
wasNull
in interfacejava.sql.ResultSet
- Returns:
- true if the value is SQL NULL; false otherwise.
- Throws:
java.sql.SQLException
- If the result set is not open.
-
cancelRowUpdates
public void cancelRowUpdates() throws java.sql.SQLException
Cancels all pending updates that have been made since the last call to updateRow(). If no updates have been made or updateRow() has already been called, then this method has no effect.- Specified by:
cancelRowUpdates
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open or the result set is not updatable.
-
deleteRow
public void deleteRow() throws java.sql.SQLException
Deletes the current row from the result set and the database. After deleting a row, the cursor position is no longer valid, so it must be explicitly repositioned.- Specified by:
deleteRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the cursor is positioned on the insert row, or an error occurs.
-
insertRow
public void insertRow() throws java.sql.SQLException
Inserts the contents of the insert row into the result set and the database.- Specified by:
insertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on the insert row, a column that is not nullable was not specified, or an error occurs.
-
rowDeleted
public boolean rowDeleted() throws java.sql.SQLException
Indicates if the current row has been deleted. A result set of type TYPE_SCROLL_INSENSITIVE may contain rows that have been deleted.- Specified by:
rowDeleted
in interfacejava.sql.ResultSet
- Returns:
- true if current row has been deleted; false otherwise.
- Throws:
java.sql.SQLException
- If an error occurs.
-
rowInserted
public boolean rowInserted() throws java.sql.SQLException
Indicates if the current row has been inserted. This driver does not support this method.- Specified by:
rowInserted
in interfacejava.sql.ResultSet
- Returns:
- Always false.
- Throws:
java.sql.SQLException
- If an error occurs.
-
rowUpdated
public boolean rowUpdated() throws java.sql.SQLException
Indicates if the current row has been updated. This driver does not support this method.- Specified by:
rowUpdated
in interfacejava.sql.ResultSet
- Returns:
- Always false.
- Throws:
java.sql.SQLException
- If an error occurs.
-
updateArray
public void updateArray(int columnIndex, java.sql.Array columnValue) throws java.sql.SQLException
Updates the value of a column as an Array object. DB2 for IBM i does not support arrays.- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null if the value is SQL NULL.- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support arrays.- Since:
- Modification 5
-
updateArray
public void updateArray(java.lang.String columnName, java.sql.Array columnValue) throws java.sql.SQLException
Updates the value of a column as an Array object. DB2 for IBM i does not support arrays. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateArray("\"MixedCase\"", columnValue).- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null if the value is SQL NULL.- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support arrays.
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using an ASCII stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, the requested conversion is not valid, the length is not valid, the input stream does not contain ASCII characters, or an error happens while reading the input stream.
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using an ASCII stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateAsciiStream("\"MixedCase\"", columnValue, length).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, the requested conversion is not valid, the length is not valid, the input stream does not contain ASCII characters, or an error happens while reading the input stream.
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, java.math.BigDecimal columnValue) throws java.sql.SQLException
Updates a column in the current row using a BigDecimal value. The driver converts this to an SQL NUMERIC value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateBigDecimal
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal columnValue) throws java.sql.SQLException
Updates a column in the current row using a BigDecimal value. The driver converts this to an SQL NUMERIC value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateBigDecimal("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using a binary stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using a binary stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateBinaryStream("\"MixedCase\"", columnValue, length).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.
-
updateBoolean
public void updateBoolean(int columnIndex, boolean columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java boolean value. The driver converts this to an SQL SMALLINT value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateBoolean
public void updateBoolean(java.lang.String columnName, boolean columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java boolean value. The driver converts this to an SQL SMALLINT value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateBoolean("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.- Since:
- Modification 5
-
updateBlob
public void updateBlob(int columnIndex, java.sql.Blob columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java Blob value. The driver converts this to an SQL BLOB value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.- Since:
- Modification 5
-
updateBlob
public void updateBlob(java.lang.String columnName, java.sql.Blob columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java Blob value. The driver converts this to an SQL BLOB value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateBlob("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateByte
public void updateByte(int columnIndex, byte columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java byte value. The driver converts this to an SQL SMALLINT value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateByte
public void updateByte(java.lang.String columnName, byte columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java byte value. The driver converts this to an SQL SMALLINT value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateByte("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateBytes
public void updateBytes(int columnIndex, byte[] columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java byte array value. The driver converts this to an SQL VARBINARY value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateBytes
public void updateBytes(java.lang.String columnName, byte[] columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java byte array value. The driver converts this to an SQL VARBINARY value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateBytes("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using a Reader value. The driver reads the data from the Reader as needed until no more characters are available. The driver converts this to an SQL VARCHAR value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnName, java.io.Reader columnValue, int length) throws java.sql.SQLException
Updates a column in the current row using a Reader value. The driver reads the data from the Reader as needed until no more characters are available. The driver converts this to an SQL VARCHAR value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateCharacterStream("\"MixedCase\"", columnValue, length).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.length
- The length.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.- Since:
- Modification 5
-
updateClob
public void updateClob(int columnIndex, java.sql.Clob columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java Clob value. The driver converts this to an SQL CLOB value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.- Since:
- Modification 5
-
updateClob
public void updateClob(java.lang.String columnName, java.sql.Clob columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java Clob value. The driver converts this to an SQL CLOB value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateClob("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateDate
public void updateDate(int columnIndex, java.sql.Date columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateDate
public void updateDate(java.lang.String columnName, java.sql.Date columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateDate("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateDouble
public void updateDouble(int columnIndex, double columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java double value. The driver converts this to an SQL DOUBLE value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateDouble
public void updateDouble(java.lang.String columnName, double columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java double value. The driver converts this to an SQL DOUBLE value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateDouble("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateFloat
public void updateFloat(int columnIndex, float columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java float value. The driver converts this to an SQL REAL value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateFloat
public void updateFloat(java.lang.String columnName, float columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java float value. The driver converts this to an SQL REAL value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateFloat("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateInt
public void updateInt(int columnIndex, int columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java int value. The driver converts this to an SQL INTEGER value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateInt
public void updateInt(java.lang.String columnName, int columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java int value. The driver converts this to an SQL INTEGER value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateInt("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateLong
public void updateLong(int columnIndex, long columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java long value. If the connected system supports SQL BIGINT data, the driver converts this to an SQL BIGINT value. Otherwise, the driver converts this to an SQL INTEGER value. SQL BIGINT data is supported on V4R5 and later.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateLong
public void updateLong(java.lang.String columnName, long columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java long value. If the connected system supports SQL BIGINT data, the driver converts this to an SQL BIGINT value. Otherwise, the driver converts this to an SQL INTEGER value. SQL BIGINT data is supported on V4R5 and later. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateLong("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateNull
public void updateNull(int columnIndex) throws java.sql.SQLException
Updates a column in the current row using SQL NULL.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateNull
public void updateNull(java.lang.String columnName) throws java.sql.SQLException
Updates a column in the current row using SQL NULL. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateNull("\"MixedCase\"").This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateDB2Default
public void updateDB2Default(int columnIndex) throws java.sql.SQLException
Updates a column in the current row to the SQL Default.- Parameters:
columnIndex
- The column index (1-based).- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDBDefault
public void updateDBDefault(int columnIndex) throws java.sql.SQLException
Updates a column in the current row to the SQL Default. Same as updateDB2Default.- Parameters:
columnIndex
- The column index (1-based).- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDB2Default
public void updateDB2Default(java.lang.String columnName) throws java.sql.SQLException
Updates a column in the current row to the SQL Default.- Parameters:
columnName
- The column name.- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDBDefault
public void updateDBDefault(java.lang.String columnName) throws java.sql.SQLException
Updates a column in the current row to the SQL Default. Same as updateDB2Default.- Parameters:
columnName
- The column name.- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDB2Unassigned
public void updateDB2Unassigned(int columnIndex) throws java.sql.SQLException
Updates a column in the current row to the SQL Unassigned.- Parameters:
columnIndex
- The column index (1-based).- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDBUnassigned
public void updateDBUnassigned(int columnIndex) throws java.sql.SQLException
Updates a column in the current row to the SQL Unassigned. Same as updtaeDB2Unassigned.- Parameters:
columnIndex
- The column index (1-based).- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDB2Unassigned
public void updateDB2Unassigned(java.lang.String columnName) throws java.sql.SQLException
Updates a column in the current row to the SQL Unassigned.- Parameters:
columnName
- The column name.- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateDBUnassigned
public void updateDBUnassigned(java.lang.String columnName) throws java.sql.SQLException
Updates a column in the current row to the SQL Unassigned. Same as updateDB2Unassigned.- Parameters:
columnName
- The column name.- Throws:
java.sql.SQLException
- If the statement is not open, the index is not valid, the parameter is not an input parameter.
-
updateObject
public void updateObject(int columnIndex, java.lang.Object columnValue) throws java.sql.SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types. In the cases where an SQL type is not supported by DB2 for IBM i, the next closest matching type is used.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object columnValue) throws java.sql.SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types. In the cases where an SQL type is not supported by DB2 for IBM i, the next closest matching type is used. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateObject("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateObject
public void updateObject(int columnIndex, java.lang.Object columnValue, int scale) throws java.sql.SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types. In the cases where an SQL type is not supported by DB2 for IBM i, the next closest matching type is used.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.scale
- The number of digits after the decimal if SQL type is DECIMAL or NUMERIC.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, the scale is not valid, or the requested conversion is not valid.
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object columnValue, int scale) throws java.sql.SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types. In the cases where an SQL type is not supported by DB2 for IBM i, the next closest matching type is used. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateObject("\"MixedCase\"", columnValue, scale).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.scale
- The number of digits after the decimal if SQL type is DECIMAL or NUMERIC.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, the scale is not valid, or the requested conversion is not valid.- Since:
- Modification 5
-
updateRef
public void updateRef(int columnIndex, java.sql.Ref columnValue) throws java.sql.SQLException
Updates the value of an SQL REF output parameter as a Ref value. DB2 for IBM i does not support structured types.- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support REFs.- Since:
- Modification 5
-
updateRef
public void updateRef(java.lang.String columnName, java.sql.Ref columnValue) throws java.sql.SQLException
Updates the value of an SQL REF output parameter as a Ref value. DB2 for IBM i does not support structured types. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateRef("\"MixedCase\"", columnValue).- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- Always thrown because DB2 for IBM i does not support REFs.
-
updateRow
public void updateRow() throws java.sql.SQLException
Updates the database with the new contents of the current row.- Specified by:
updateRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the cursor is positioned on the insert row, or an error occurs.
-
updateShort
public void updateShort(int columnIndex, short columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java short value. The driver converts this to an SQL SMALLINT value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateShort
public void updateShort(java.lang.String columnName, short columnValue) throws java.sql.SQLException
Updates a column in the current row using a Java short value. The driver converts this to an SQL SMALLINT value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateShort("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateString
public void updateString(int columnIndex, java.lang.String columnValue) throws java.sql.SQLException
Updates a column in the current row using a String value. The driver converts this to an SQL VARCHAR value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateString
public void updateString(java.lang.String columnName, java.lang.String columnValue) throws java.sql.SQLException
Updates a column in the current row using a String value. The driver converts this to an SQL VARCHAR value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateString("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateString
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateTime
public void updateTime(int columnIndex, java.sql.Time columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Time value. The driver converts this to an SQL TIME value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateTime
public void updateTime(java.lang.String columnName, java.sql.Time columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Time value. The driver converts this to an SQL TIME value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateTime("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
updateTimestamp
public void updateTimestamp(int columnIndex, java.sql.Timestamp columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value.This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
-
updateTimestamp
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp columnValue) throws java.sql.SQLException
Updates a column in the current row using a java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value. To perform a case-sensitive search use a quoted String for columnName as in: ResultSet.updateTimestamp("\"MixedCase\"", columnValue).This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Parameters:
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.- Throws:
java.sql.SQLException
- If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.
-
getHoldability
public int getHoldability() throws java.sql.SQLException
Retrieves the holdability of thisResultSet
object- Specified by:
getHoldability
in interfacejava.sql.ResultSet
- Returns:
- either
ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
The holdability is derived in this order of precedence:- 1. The holdability, if any, that was specified on statement creation using the methods createStatement(), prepareCall(), or prepareStatement() on the Connection object.
- 2. The holdability specified using the method setHoldability(int) if this method was called on the Connection object.
- 3. If neither of above methods were called, the value of the
cursor hold
driver property.
- Throws:
java.sql.SQLException
- if a database error occurs
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object. It is intended for use when accessingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-- Returns:
- a
java.io.Reader
object that contains the column value; if the value is SQLNULL
, the value returned isnull
in the Java programming language. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String columnName) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.io.Reader
object. It is intended for use when accessingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the column- Returns:
- a
java.io.Reader
object that contains the column value; if the value is SQLNULL
, the value returned isnull
in the Java programming language - Throws:
java.sql.SQLException
- if a database access error occurs
-
getNClob
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-- Returns:
- a
NClob
object representing the SQLNCLOB
value in the specified column - Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurss
-
getNClob
public java.sql.NClob getNClob(java.lang.String columnName) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as aNClob
object in the Java programming language.- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the column from which to retrieve the value- Returns:
- a
NClob
object representing the SQLNCLOB
value in the specified column - Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
-
getNString
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language. It is intended for use when accessingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.- Specified by:
getNString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-- Returns:
- the column value; if the value is SQL
NULL
, the value returned isnull
- Throws:
java.sql.SQLException
- if a database access error occurs
-
getNString
public java.lang.String getNString(java.lang.String columnName) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as aString
in the Java programming language. It is intended for use when accessingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.- Specified by:
getNString
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the SQL name of the column- Returns:
- the column value; if the value is SQL
NULL
, the value returned isnull
- Throws:
java.sql.SQLException
- if a database access error occurs
-
getRowId
public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
- the column number- Returns:
- the column value ; if the value is a SQL
NULL
the value returned isnull
- Throws:
java.sql.SQLException
- if a database access error occurs
-
getRowId
public java.sql.RowId getRowId(java.lang.String columnName) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
object as ajava.sql.RowId
object in the Java programming language.- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the column- Returns:
- the column value ; if the value is a SQL
NULL
the value returned isnull
- Throws:
java.sql.SQLException
- if a database access error occurs
-
getSQLXML
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-- Returns:
- a
SQLXML
object that maps anSQL XML
value - Throws:
java.sql.SQLException
- if a database access error occurs
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String columnName) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of thisResultSet
as ajava.sql.SQLXML
object in the Java programming language.- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the column from which to retrieve the value- Returns:
- a
SQLXML
object that maps anSQL XML
value - Throws:
java.sql.SQLException
- if a database access error occurs
-
updateNClob
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
Updates the designated column with ajava.sql.NClob
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-nClob
- the value for the column to be updated- Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
-
updateNClob
public void updateNClob(java.lang.String columnName, java.sql.NClob nClob) throws java.sql.SQLException
Updates the designated column with ajava.sql.NClob
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnName
- name of the columnnClob
- the value for the column to be updated- Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
-
updateNString
public void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
Updates the designated column with aString
value. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-nString
- the value for the column to be updated- Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
-
updateNString
public void updateNString(java.lang.String columnName, java.lang.String nString) throws java.sql.SQLException
Updates the designated column with aString
value. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Parameters:
columnName
- name of the ColumnnString
- the value for the column to be updated- Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
-
updateRowId
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
Updates the designated column with aRowId
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the column value- Throws:
java.sql.SQLException
- if a database access occurs
-
updateRowId
public void updateRowId(java.lang.String columnName, java.sql.RowId x) throws java.sql.SQLException
Updates the designated column with aRowId
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the columnx
- the column value- Throws:
java.sql.SQLException
- if a database access occurs
-
updateSQLXML
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
Updates the designated column with ajava.sql.SQLXML
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-xmlObject
- the value for the column to be updated- Throws:
java.sql.SQLException
- if a database access error occurs
-
updateSQLXML
public void updateSQLXML(java.lang.String columnName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
Updates the designated column with ajava.sql.SQLXML
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Parameters:
columnName
- the name of the columnxmlObject
- the column value- Throws:
java.sql.SQLException
- if a database access occurs
-
getValidWrappedList
protected java.lang.String[] getValidWrappedList()
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- the column namex
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
Updates the designated column with a binary stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
Updates the designated column with a binary stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnx
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
Updates the designated column using the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-inputStream
- An object that contains the data to set the parameter value to.length
- the number of bytes in the parameter data.- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
Updates the designated column using the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columninputStream
- An object that contains the data to set the parameter value to.length
- the number of bytes in the parameter data.- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates the designated column with a character stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column with a character stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column using the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-reader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column using the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- thejava.io.Reader
object containing the new column valuelength
- the length of the stream- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column using the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-reader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.- Throws:
java.sql.SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency isCONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
Updates the designated column using the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.- Throws:
java.sql.SQLException
- if a database access error occurs, the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
Updates the designated column with an ascii stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column value- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
Updates the designated column with an ascii stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnx
- the new column value- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column value- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnx
- the new column value- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateBlob
which takes a length parameter.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-inputStream
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateBlob
which takes a length parameter.- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columninputStream
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column value- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- thejava.io.Reader
object containing the new column value- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column using the givenReader
object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateClob
which takes a length parameter.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-reader
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column using the givenReader
object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateClob
which takes a length parameter.- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-x
- the new column value- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
columns.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- thejava.io.Reader
object containing the new column value- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column using the givenReader
The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateNClob
which takes a length parameter.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnIndex
-reader
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency isCONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Updates the designated column using the givenReader
object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the
updateRow
orinsertRow
methods are called to update the database.Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of
updateNClob
which takes a length parameter.- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Parameters:
columnLabel
- 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 columnreader
- An object that contains the data to set the parameter value to.- Throws:
java.sql.SQLException
- if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency isCONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
getObject
public java.lang.Object getObject(int columnIndex, java.lang.Class type) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException is thrown.At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData, or Struct. Additional conversions may be supported and are vendor defined.
- Parameters:
columnIndex
- - the first column is 1, the second is 2, ...type
- - Class representing the Java data type to convert the designated column to.- Throws:
java.sql.SQLException
- - if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occursSQLFeatureNotSupportedException
- - if the JDBC driver does not support this method
-
getObject
public java.lang.Object getObject(java.lang.String columnLabel, java.lang.Class type) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException is thrown.At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData, or Struct. Additional conversions may be supported and are vendor defined.
- Parameters:
columnLabel
- - 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 columntype
- - Class representing the Java data type to convert the designated column to.- Returns:
- an instance of type holding the column value
- Throws:
java.sql.SQLException
- - if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occursSQLFeatureNotSupportedException
- - if the JDBC driver does not support this method
-
addSavedException
protected void addSavedException(java.sql.SQLException savedException)
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.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 callingisWrapperFor
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 tounwrap
so that callers can use this method to avoid expensiveunwrap
calls that may fail. If this method returns true then callingunwrap
with the same argument should succeed.- Specified by:
isWrapperFor
in interfacejava.sql.Wrapper
- Parameters:
iface
- a Class defining an interface.- Returns:
- true if this implements the interface or directly or indirectly wraps an object that does.
- Throws:
java.sql.SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface.
-
unwrap
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of callingunwrap
recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then anSQLException
is thrown.- Specified by:
unwrap
in interfacejava.sql.Wrapper
- 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:
java.sql.SQLException
- If no object found that implements the interface
-
-