Class EmbedResultSet
- java.lang.Object
-
- org.apache.derby.impl.jdbc.EmbedResultSet
-
- All Implemented Interfaces:
- java.lang.AutoCloseable, java.lang.Comparable, java.sql.ResultSet, java.sql.Wrapper, EngineResultSet
- Direct Known Subclasses:
- EmbedResultSet42
public class EmbedResultSet extends java.lang.Object implements EngineResultSet, java.lang.Comparable
A EmbedResultSet for results from the EmbedStatement family. Supports JDBC 4.1.
-
-
Constructor Summary
Constructors Constructor and Description EmbedResultSet(EmbedConnection conn, ResultSet resultsToWrap, boolean forMetaData, EmbedStatement stmt, boolean isAtomic)This class provides the glue between the Derby resultset and the JDBC resultset, mapping calls-to-calls.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method and Description booleanabsolute(int row)JDBC 2.0voidafterLast()JDBC 2.0voidbeforeFirst()JDBC 2.0voidcancelRowUpdates()JDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row.voidclearWarnings()After this call getWarnings returns null until a new warning is reported for this ResultSet.voidclose()In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.intcompareTo(java.lang.Object other)voiddeleteRow()JDBC 2.0 Delete the current row from the result set and the underlying database.intfindColumn(java.lang.String columnName)Map a Resultset column name to a ResultSet column index.booleanfirst()JDBC 2.0java.sql.ArraygetArray(int i)JDBC 2.0 Get an array column.java.sql.ArraygetArray(java.lang.String colName)JDBC 2.0 Get an array column.java.io.InputStreamgetAsciiStream(int columnIndex)Pushes a converter on top of getCharacterStream().java.io.InputStreamgetAsciiStream(java.lang.String columnName)A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.java.math.BigDecimalgetBigDecimal(int columnIndex)java.math.BigDecimalgetBigDecimal(int columnIndex, int scale)Deprecated.java.math.BigDecimalgetBigDecimal(java.lang.String columnName)JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object.java.math.BigDecimalgetBigDecimal(java.lang.String columnName, int scale)Deprecated.java.io.InputStreamgetBinaryStream(int columnIndex)Get the column as an InputStream.java.io.InputStreamgetBinaryStream(java.lang.String columnName)A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.java.sql.BlobgetBlob(int columnIndex)JDBC 2.0 Get a BLOB column.java.sql.BlobgetBlob(java.lang.String columnName)JDBC 2.0 Get a BLOB column.booleangetBoolean(int columnIndex)Get the value of a column in the current row as a Java boolean.booleangetBoolean(java.lang.String columnName)Get the value of a column in the current row as a Java boolean.bytegetByte(int columnIndex)Get the value of a column in the current row as a Java byte.bytegetByte(java.lang.String columnName)Get the value of a column in the current row as a Java byte.byte[]getBytes(int columnIndex)Get the value of a column in the current row as a Java byte array.byte[]getBytes(java.lang.String columnName)Get the value of a column in the current row as a Java byte array.java.io.ReadergetCharacterStream(int columnIndex)JDBC 2.0java.io.ReadergetCharacterStream(java.lang.String columnName)JDBC 2.0java.sql.ClobgetClob(int columnIndex)JDBC 2.0 Get a CLOB column.java.sql.ClobgetClob(java.lang.String columnName)JDBC 2.0 Get a CLOB column.intgetConcurrency()JDBC 2.0 Return the concurrency of this result set.java.lang.StringgetCursorName()Get the name of the SQL cursor used by this ResultSet.java.sql.DategetDate(int columnIndex)Get the value of a column in the current row as a java.sql.Date object.java.sql.DategetDate(int columnIndex, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object.java.sql.DategetDate(java.lang.String columnName)Get the value of a column in the current row as a java.sql.Date object.java.sql.DategetDate(java.lang.String columnName, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object.doublegetDouble(int columnIndex)Get the value of a column in the current row as a Java double.doublegetDouble(java.lang.String columnName)Get the value of a column in the current row as a Java double.intgetFetchDirection()JDBC 2.0 Return the fetch direction for this result set.intgetFetchSize()JDBC 2.0 Return the fetch size for this result set.floatgetFloat(int columnIndex)Get the value of a column in the current row as a Java float.floatgetFloat(java.lang.String columnName)Get the value of a column in the current row as a Java float.intgetHoldability()JDBC 4.0intgetInt(int columnIndex)Get the value of a column in the current row as a Java int.intgetInt(java.lang.String columnName)Get the value of a column in the current row as a Java int.intgetLength(int columnIndex)Return the length of the designated columnIndex data value.longgetLong(int columnIndex)Get the value of a column in the current row as a Java long.longgetLong(java.lang.String columnName)Get the value of a column in the current row as a Java long.java.sql.ResultSetMetaDatagetMetaData()The number, types and properties of a ResultSet's columns are provided by the getMetaData method.java.io.ReadergetNCharacterStream(int columnIndex)java.io.ReadergetNCharacterStream(java.lang.String columnName)java.sql.NClobgetNClob(int i)java.sql.NClobgetNClob(java.lang.String colName)java.lang.StringgetNString(int columnIndex)java.lang.StringgetNString(java.lang.String columnName)java.lang.ObjectgetObject(int columnIndex)Get the value of a column in the current row as a Java object.<T> TgetObject(int columnIndex, java.lang.Class<T> type)Retrieve the column as an object of the desired type.java.lang.ObjectgetObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)JDBC 2.0 Returns the value of columnias a Java object.java.lang.ObjectgetObject(java.lang.String columnName)Get the value of a column in the current row as a Java object.<T> TgetObject(java.lang.String columnName, java.lang.Class<T> type)java.lang.ObjectgetObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map)JDBC 2.0 Returns the value of columnias a Java object.java.sql.RefgetRef(int i)JDBC 2.0 Get a REF(<structured-type>) column.java.sql.RefgetRef(java.lang.String colName)JDBC 2.0 Get a REF(<structured-type>) column.intgetRow()JDBC 2.0java.sql.RowIdgetRowId(int columnIndex)java.sql.RowIdgetRowId(java.lang.String columnName)shortgetShort(int columnIndex)Get the value of a column in the current row as a Java short.shortgetShort(java.lang.String columnName)Get the value of a column in the current row as a Java short.java.sql.SQLXMLgetSQLXML(int columnIndex)java.sql.SQLXMLgetSQLXML(java.lang.String colName)java.sql.StatementgetStatement()JDBC 2.0 Return the Statement that produced the ResultSet.java.lang.StringgetString(int columnIndex)Get the value of a column in the current row as a Java String.java.lang.StringgetString(java.lang.String columnName)Get the value of a column in the current row as a Java String.java.sql.TimegetTime(int columnIndex)Get the value of a column in the current row as a java.sql.Time object.java.sql.TimegetTime(int columnIndex, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Time object.java.sql.TimegetTime(java.lang.String columnName)Get the value of a column in the current row as a java.sql.Time object.java.sql.TimegetTime(java.lang.String columnName, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Time object.java.sql.TimestampgetTimestamp(int columnIndex)Get the value of a column in the current row as a java.sql.Timestamp object.java.sql.TimestampgetTimestamp(int columnIndex, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object.java.sql.TimestampgetTimestamp(java.lang.String columnName)Get the value of a column in the current row as a java.sql.Timestamp object.java.sql.TimestampgetTimestamp(java.lang.String columnName, java.util.Calendar cal)JDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object.intgetType()JDBC 2.0 Return the type of this result set.java.io.InputStreamgetUnicodeStream(int columnIndex)Deprecated.java.io.InputStreamgetUnicodeStream(java.lang.String columnName)Deprecated.java.net.URLgetURL(int columnIndex)JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.java.net.URLgetURL(java.lang.String columnName)JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.java.sql.SQLWarninggetWarnings()The first warning reported by calls on this ResultSet is returned.voidinsertRow()JDBC 2.0 Insert the contents of the insert row into the result set and the database.booleanisAfterLast()JDBC 2.0booleanisBeforeFirst()JDBC 2.0booleanisClosed()JDBC 4.0booleanisFirst()JDBC 2.0booleanisForUpdate()* Is this result set from a select for update statement?booleanisLast()JDBC 2.0booleanisNull(int columnIndex)Is the designated columnIndex a null data value? This is used by EXTDTAInputStream to get the null value without retrieving the underlying data value.booleanisWrapperFor(java.lang.Class<?> interfaces)Returns false unlessinterfacesis implementedbooleanlast()JDBC 2.0voidmoveToCurrentRow()JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row.voidmoveToInsertRow()JDBC 2.0 Move to the insert row.booleannext()A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.booleanprevious()JDBC 2.0voidrefreshRow()JDBC 2.0 Refresh the value of the current row with its current value in the database.booleanrelative(int row)JDBC 2.0booleanrowDeleted()JDBC 2.0 Determine if this row has been deleted.booleanrowInserted()JDBC 2.0 Determine if the current row has been inserted.booleanrowUpdated()JDBC 2.0 Determine if the current row has been updated.voidsetApplicationStatement(java.sql.Statement applicationStmt)Set the application Statement object that created this ResultSet.voidsetFetchDirection(int direction)JDBC 2.0 Give a hint as to the direction in which the rows in this result set will be processed.static voidsetFetchedRowBase(long newBase)Debug method used to test the setLargeMaxRows() method added by JDBC 4.2.voidsetFetchSize(int rows)JDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set.<T> Tunwrap(java.lang.Class<T> interfaces)Returnsthisif this class implements the interfacevoidupdateArray(int columnIndex, java.sql.Array x)JDBC 3.0 Updates the designated column with a java.sql.Array value.voidupdateArray(java.lang.String columnName, java.sql.Array x)JDBC 3.0 Updates the designated column with a java.sql.Array value.voidupdateAsciiStream(int columnIndex, java.io.InputStream x)Updates the designated column with a character stream value.voidupdateAsciiStream(int columnIndex, java.io.InputStream x, int length)JDBC 2.0 Update a column with an ascii stream value.voidupdateAsciiStream(int columnIndex, java.io.InputStream x, long length)Update a column with an ascii stream value.voidupdateAsciiStream(java.lang.String columnName, java.io.InputStream x)Updates the designated column with a character stream value.voidupdateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)JDBC 2.0 Update a column with an ascii stream value.voidupdateAsciiStream(java.lang.String columnName, java.io.InputStream x, long length)JDBC 4.0 Update a column with an ascii stream value.voidupdateBigDecimal(int columnIndex, java.math.BigDecimal x)voidupdateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)JDBC 2.0 Update a column with a BigDecimal value.voidupdateBinaryStream(int columnIndex, java.io.InputStream x)Updates the designated column with a binary stream value.voidupdateBinaryStream(int columnIndex, java.io.InputStream x, int length)JDBC 2.0 Update a column with a binary stream value.voidupdateBinaryStream(int columnIndex, java.io.InputStream x, long length)Update a column with a binary stream value.voidupdateBinaryStream(java.lang.String columnName, java.io.InputStream x)Updates the designated column with a binary stream value.voidupdateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)JDBC 2.0 Update a column with a binary stream value.voidupdateBinaryStream(java.lang.String columnName, java.io.InputStream x, long length)JDBC 4.0 Update a column with a binary stream value.voidupdateBlob(int columnIndex, java.sql.Blob x)JDBC 3.0 Updates the designated column with a java.sql.Blob value.voidupdateBlob(int columnIndex, java.io.InputStream x)Updates the designated column using the given input stream.voidupdateBlob(int columnIndex, java.io.InputStream x, long length)JDBC 4.0 Updates the designated column with a java.sql.Blob value.voidupdateBlob(java.lang.String columnName, java.sql.Blob x)JDBC 3.0 Updates the designated column with a java.sql.Blob value.voidupdateBlob(java.lang.String columnName, java.io.InputStream x)Updates the designated column using the given input stream.voidupdateBlob(java.lang.String columnName, java.io.InputStream x, long length)JDBC 4.0 Updates the designated column with a java.sql.Blob value.voidupdateBoolean(int columnIndex, boolean x)JDBC 2.0 Update a column with a boolean value.voidupdateBoolean(java.lang.String columnName, boolean x)JDBC 2.0 Update a column with a boolean value.voidupdateByte(int columnIndex, byte x)JDBC 2.0 Update a column with a byte value.voidupdateByte(java.lang.String columnName, byte x)JDBC 2.0 Update a column with a byte value.voidupdateBytes(int columnIndex, byte[] x)JDBC 2.0 Update a column with a byte array value.voidupdateBytes(java.lang.String columnName, byte[] x)JDBC 2.0 Update a column with a byte array value.voidupdateCharacterStream(int columnIndex, java.io.Reader x)Updates the designated column with a character stream value.voidupdateCharacterStream(int columnIndex, java.io.Reader x, int length)JDBC 2.0 Update a column with a character stream value.voidupdateCharacterStream(int columnIndex, java.io.Reader x, long length)JDBC 4.0 Update a column with a character stream value.voidupdateCharacterStream(java.lang.String columnName, java.io.Reader reader)Updates the designated column with a character stream value.voidupdateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)JDBC 2.0 Update a column with a character stream value.voidupdateCharacterStream(java.lang.String columnName, java.io.Reader reader, long length)JDBC 4.0 Update a column with a character stream value.voidupdateClob(int columnIndex, java.sql.Clob x)JDBC 3.0 Updates the designated column with a java.sql.Clob value.voidupdateClob(int columnIndex, java.io.Reader x)Updates the designated column using the givenReaderobject.voidupdateClob(int columnIndex, java.io.Reader x, long length)JDBC 4.0 Updates the designated column with a java.sql.Clob value.voidupdateClob(java.lang.String columnName, java.sql.Clob x)JDBC 3.0 Updates the designated column with a java.sql.Clob value.voidupdateClob(java.lang.String columnName, java.io.Reader x)Updates the designated column using the givenReaderobject.voidupdateClob(java.lang.String columnName, java.io.Reader x, long length)JDBC 4.0 Updates the designated column with a java.sql.Clob value.voidupdateDate(int columnIndex, java.sql.Date x)JDBC 2.0 Update a column with a Date value.voidupdateDate(java.lang.String columnName, java.sql.Date x)JDBC 2.0 Update a column with a Date value.voidupdateDouble(int columnIndex, double x)JDBC 2.0 Update a column with a Double value.voidupdateDouble(java.lang.String columnName, double x)JDBC 2.0 Update a column with a double value.voidupdateFloat(int columnIndex, float x)JDBC 2.0 Update a column with a float value.voidupdateFloat(java.lang.String columnName, float x)JDBC 2.0 Update a column with a float value.voidupdateInt(int columnIndex, int x)JDBC 2.0 Update a column with an integer value.voidupdateInt(java.lang.String columnName, int x)JDBC 2.0 Update a column with an integer value.voidupdateLong(int columnIndex, long x)JDBC 2.0 Update a column with a long value.voidupdateLong(java.lang.String columnName, long x)JDBC 2.0 Update a column with a long value.voidupdateNCharacterStream(int columnIndex, java.io.Reader x)voidupdateNCharacterStream(int columnIndex, java.io.Reader x, long length)voidupdateNCharacterStream(java.lang.String columnName, java.io.Reader x)voidupdateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length)voidupdateNClob(int columnIndex, java.sql.NClob nClob)voidupdateNClob(int columnIndex, java.io.Reader reader)voidupdateNClob(int columnIndex, java.io.Reader x, long length)Updates the designated column using the given Reader object, which is the given number of characters long.voidupdateNClob(java.lang.String columnName, java.sql.NClob nClob)voidupdateNClob(java.lang.String columnName, java.io.Reader reader)voidupdateNClob(java.lang.String columnName, java.io.Reader x, long length)Updates the designated column using the given Reader object, which is the given number of characters long.voidupdateNString(int columnIndex, java.lang.String nString)voidupdateNString(java.lang.String columnName, java.lang.String nString)voidupdateNull(int columnIndex)JDBC 2.0 Give a nullable column a null value.voidupdateNull(java.lang.String columnName)JDBC 2.0 Update a column with a null value.voidupdateObject(int columnIndex, java.lang.Object x)JDBC 2.0 Update a column with an Object value.voidupdateObject(int columnIndex, java.lang.Object x, int scale)JDBC 2.0 Update a column with an Object value.voidupdateObject(java.lang.String columnName, java.lang.Object x)JDBC 2.0 Update a column with an Object value.voidupdateObject(java.lang.String columnName, java.lang.Object x, int scale)JDBC 2.0 Update a column with an Object value.voidupdateRef(int columnIndex, java.sql.Ref x)JDBC 3.0 Updates the designated column with a java.sql.Ref value.voidupdateRef(java.lang.String columnName, java.sql.Ref x)JDBC 3.0 Updates the designated column with a java.sql.Ref value.voidupdateRow()JDBC 2.0 Update the underlying database with the new contents of the current row.voidupdateRowId(int columnIndex, java.sql.RowId x)voidupdateRowId(java.lang.String columnName, java.sql.RowId x)voidupdateShort(int columnIndex, short x)JDBC 2.0 Update a column with a short value.voidupdateShort(java.lang.String columnName, short x)JDBC 2.0 Update a column with a short value.voidupdateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)voidupdateSQLXML(java.lang.String columnName, java.sql.SQLXML xmlObject)voidupdateString(int columnIndex, java.lang.String x)JDBC 2.0 Update a column with a String value.voidupdateString(java.lang.String columnName, java.lang.String x)JDBC 2.0 Update a column with a String value.voidupdateTime(int columnIndex, java.sql.Time x)JDBC 2.0 Update a column with a Time value.voidupdateTime(java.lang.String columnName, java.sql.Time x)JDBC 2.0 Update a column with a Time value.voidupdateTimestamp(int columnIndex, java.sql.Timestamp x)JDBC 2.0 Update a column with a Timestamp value.voidupdateTimestamp(java.lang.String columnName, java.sql.Timestamp x)JDBC 2.0 Update a column with a Timestamp value.booleanwasNull()A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.
-
-
-
Constructor Detail
-
EmbedResultSet
public EmbedResultSet(EmbedConnection conn, ResultSet resultsToWrap, boolean forMetaData, EmbedStatement stmt, boolean isAtomic) throws java.sql.SQLException
This class provides the glue between the Derby resultset and the JDBC resultset, mapping calls-to-calls.- Throws:
java.sql.SQLException
-
-
Method Detail
-
setFetchedRowBase
public static void setFetchedRowBase(long newBase)
Debug method used to test the setLargeMaxRows() method added by JDBC 4.2. This method is a NOP on a production (insane) build of Derby.
-
next
public boolean next() throws java.sql.SQLExceptionA ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read.
- Specified by:
nextin interfacejava.sql.ResultSet- Returns:
- true if the new current row is valid; false if there are no more rows
- Throws:
java.sql.SQLException- thrown on failure.
-
close
public void close() throws java.sql.SQLExceptionIn some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.
- Specified by:
closein interfacejava.lang.AutoCloseable- Specified by:
closein interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- thrown on failure.
-
wasNull
public final boolean wasNull() throws java.sql.SQLExceptionA column may have the value of SQL NULL; wasNull reports whether the last column read had this special value. Note that you must first call getXXX on a column to try to read its value and then call wasNull() to find if the value was the SQL NULL.we take the least exception approach and simply return false if no column has been read yet.
- Specified by:
wasNullin interfacejava.sql.ResultSet- Returns:
- true if last column read was SQL NULL
- Throws:
java.sql.SQLException- Thrown if this ResultSet is closed
-
getString
public final java.lang.String getString(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java String.- Specified by:
getStringin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getBoolean
public final boolean getBoolean(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java boolean.- Specified by:
getBooleanin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is false
- Throws:
java.sql.SQLException- thrown on failure.
-
getByte
public final byte getByte(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java byte.- Specified by:
getBytein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getShort
public final short getShort(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java short.- Specified by:
getShortin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getInt
public final int getInt(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java int.- Specified by:
getIntin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getLong
public final long getLong(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java long.- Specified by:
getLongin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getFloat
public final float getFloat(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java float.- Specified by:
getFloatin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getDouble
public final double getDouble(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java double.- Specified by:
getDoublein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getBytes
public final byte[] getBytes(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java byte array. The bytes represent the raw values returned by the driver.- Specified by:
getBytesin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getDate
public final java.sql.Date getDate(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Date object.- Specified by:
getDatein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getTime
public final java.sql.Time getTime(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Time object.- Specified by:
getTimein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Timestamp object.- Specified by:
getTimestampin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getDate
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Date object. Use the calendar to construct an appropriate millisecond value for the Date, if the underlying database doesn't store timezone information.- Specified by:
getDatein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...cal- the calendar to use in constructing the date- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getDate
public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Date object. Use the calendar to construct an appropriate millisecond value for the Date, if the underlying database doesn't store timezone information.- Specified by:
getDatein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the columncal- the calendar to use in constructing the date- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTime
public java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Time object. Use the calendar to construct an appropriate millisecond value for the Time, if the underlying database doesn't store timezone information.- Specified by:
getTimein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...cal- the calendar to use in constructing the time- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTime
public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Time object. Use the calendar to construct an appropriate millisecond value for the Time, if the underlying database doesn't store timezone information.- Specified by:
getTimein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the columncal- the calendar to use in constructing the time- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object. Use the calendar to construct an appropriate millisecond value for the Timestamp, if the underlying database doesn't store timezone information.- Specified by:
getTimestampin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the columncal- the calendar to use in constructing the timestamp- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.sql.Timestamp object. Use the calendar to construct an appropriate millisecond value for the Timestamp, if the underlying database doesn't store timezone information.- Specified by:
getTimestampin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...cal- the calendar to use in constructing the timestamp- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getCharacterStream
public final java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLExceptionJDBC 2.0Get the value of a column in the current row as a java.io.Reader.
- Specified by:
getCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- database error.
-
getAsciiStream
public final java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLExceptionPushes a converter on top of getCharacterStream().- Specified by:
getAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
- Throws:
java.sql.SQLException- thrown on failure.
-
getBinaryStream
public final java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLExceptionGet the column as an InputStream. If the column is already of type InputStream then just return it, otherwise convert the column to a set of bytes and create a stream out of the bytes.- Specified by:
getBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
- Throws:
java.sql.SQLException- thrown on failure.
-
getString
public final java.lang.String getString(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java String.- Specified by:
getStringin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getBoolean
public final boolean getBoolean(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java boolean.- Specified by:
getBooleanin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is false
- Throws:
java.sql.SQLException- thrown on failure.
-
getByte
public final byte getByte(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java byte.- Specified by:
getBytein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getShort
public final short getShort(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java short.- Specified by:
getShortin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getInt
public final int getInt(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java int.- Specified by:
getIntin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getLong
public final long getLong(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java long.- Specified by:
getLongin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getFloat
public final float getFloat(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java float.- Specified by:
getFloatin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getDouble
public final double getDouble(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java double.- Specified by:
getDoublein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is 0
- Throws:
java.sql.SQLException- thrown on failure.
-
getBigDecimal
@Deprecated public final java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLExceptionDeprecated.Get the value of a column in the current row as a java.lang.BigDecimal object.- Specified by:
getBigDecimalin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...scale- the number of digits to the right of the decimal- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException- Specified by:
getBigDecimalin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getBigDecimal
@Deprecated public final java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLExceptionDeprecated.Get the value of a column in the current row as a java.lang.BigDecimal object.- Specified by:
getBigDecimalin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the columnscale- the number of digits to the right of the decimal- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object.- Specified by:
getBigDecimalin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getBytes
public final byte[] getBytes(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java byte array. The bytes represent the raw values returned by the driver.- Specified by:
getBytesin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getDate
public final java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Date object.- Specified by:
getDatein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getTime
public final java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Time object.- Specified by:
getTimein interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a java.sql.Timestamp object.- Specified by:
getTimestampin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- thrown on failure.
-
getCharacterStream
public final java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 2.0Get the value of a column in the current row as a java.io.Reader.
- Specified by:
getCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getAsciiStream
public final java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLExceptionA column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.Note: All 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:
getAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
- Throws:
java.sql.SQLException- thrown on failure.
-
getBinaryStream
public final java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLExceptionA column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.Note: All 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:
getBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
- Throws:
java.sql.SQLException- thrown on failure.
-
getUnicodeStream
@Deprecated public final java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLExceptionDeprecated.JDBC 2.0 Deprecated in JDBC 2.0, not supported by JCC.- Specified by:
getUnicodeStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- thrown on failure.
-
getUnicodeStream
@Deprecated public final java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLExceptionDeprecated.Deprecated in JDBC 2.0, not supported by JCC.- Specified by:
getUnicodeStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- thrown on failure.
-
getURL
public java.net.URL getURL(int columnIndex) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.- Specified by:
getURLin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2- Returns:
- the column value as a java.net.URL object, if the value is SQL NULL, the value returned is null in the Java programming language
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getURL
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.- Specified by:
getURLin interfacejava.sql.ResultSet- Parameters:
columnName- - the SQL name of the column- Returns:
- the column value as a java.net.URL object, if the value is SQL NULL, the value returned is null in the Java programming language
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getWarnings
public final java.sql.SQLWarning getWarnings() throws java.sql.SQLExceptionThe first warning reported by calls on this ResultSet is returned. Subsequent ResultSet warnings will be chained to this SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.
- Specified by:
getWarningsin interfacejava.sql.ResultSet- Returns:
- the first SQLWarning or null
- Throws:
java.sql.SQLException- Thrown if this ResultSet is closed
-
clearWarnings
public final void clearWarnings() throws java.sql.SQLExceptionAfter this call getWarnings returns null until a new warning is reported for this ResultSet.- Specified by:
clearWarningsin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- Thrown if this ResultSet is closed
-
getCursorName
public final java.lang.String getCursorName() throws java.sql.SQLExceptionGet the name of the SQL cursor used by this ResultSet.In SQL, a result table is retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.
JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet. The current row of a ResultSet is also the current row of this SQL cursor.
Note: If positioned update is not supported a SQLException is thrown
- Specified by:
getCursorNamein interfacejava.sql.ResultSet- Returns:
- the ResultSet's SQL cursor name
- Throws:
java.sql.SQLException- thrown on failure.
-
getMetaData
public final java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLExceptionThe number, types and properties of a ResultSet's columns are provided by the getMetaData method.- Specified by:
getMetaDatain interfacejava.sql.ResultSet- Returns:
- the description of a ResultSet's columns
- Throws:
java.sql.SQLException- thrown on failure.
-
getHoldability
public final int getHoldability() throws java.sql.SQLExceptionJDBC 4.0Retrieves the holdability for this
ResultSetobject.- Specified by:
getHoldabilityin interfacejava.sql.ResultSet- Returns:
- either
ResultSet.HOLD_CURSORS_OVER_COMMITorResultSet.CLOSE_CURSORS_AT_COMMIT - Throws:
java.sql.SQLException- if a database error occurs
-
getObject
public final java.lang.Object getObject(int columnIndex) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java object.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC spec.
This method may also be used to read datatabase specific abstract data types. JDBC 2.0 New behavior for getObject(). The behavior of method getObject() is extended to materialize data of SQL user-defined types. When the column @columnIndex is a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).
- Specified by:
getObjectin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- A java.lang.Object holding the column value.
- Throws:
java.sql.SQLException- thrown on failure.
-
getObject
public final java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLExceptionGet the value of a column in the current row as a Java object.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC spec.
This method may also be used to read datatabase specific abstract data types. JDBC 2.0 New behavior for getObject(). The behavior of method getObject() is extended to materialize data of SQL user-defined types. When the column @columnName is a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnName, this.getStatement().getConnection().getTypeMap()).
- Specified by:
getObjectin interfacejava.sql.ResultSet- Parameters:
columnName- is the SQL name of the column- Returns:
- A java.lang.Object holding the column value.
- Throws:
java.sql.SQLException- thrown on failure.
-
getObject
public java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLExceptionJDBC 2.0 Returns the value of columnias a Java object. Use the param map to determine the class from which to construct data of SQL structured and distinct types.- Specified by:
getObjectin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...map- the mapping from SQL type names to Java classes- Returns:
- an object representing the SQL value
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getObject
public java.lang.Object getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLExceptionJDBC 2.0 Returns the value of columnias a Java object. Use the param map to determine the class from which to construct data of SQL structured and distinct types.- Specified by:
getObjectin interfacejava.sql.ResultSet- Parameters:
colName- the column namemap- the mapping from SQL type names to Java classes- Returns:
- an object representing the SQL value
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
findColumn
public final int findColumn(java.lang.String columnName) throws java.sql.SQLExceptionMap a Resultset column name to a ResultSet column index.- Specified by:
findColumnin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the column- Returns:
- the column index
- Throws:
java.sql.SQLException- thrown on failure.
-
getStatement
public final java.sql.Statement getStatement() throws java.sql.SQLExceptionJDBC 2.0 Return the Statement that produced the ResultSet.- Specified by:
getStatementin interfacejava.sql.ResultSet- Returns:
- the Statment that produced the result set, or null if the result was produced some other way.
- Throws:
java.sql.SQLException- if a database error occurs or the result set is closed
-
setApplicationStatement
public final void setApplicationStatement(java.sql.Statement applicationStmt)
Set the application Statement object that created this ResultSet. Used when the Statement objects returned to the application are wrapped for XA.
-
getRef
public final java.sql.Ref getRef(int i) throws java.sql.SQLExceptionJDBC 2.0 Get a REF(<structured-type>) column.- Specified by:
getRefin interfacejava.sql.ResultSet- Parameters:
i- the first column is 1, the second is 2, ...- Returns:
- an object representing data of an SQL REF type
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getArray
public final java.sql.Array getArray(int i) throws java.sql.SQLExceptionJDBC 2.0 Get an array column.- Specified by:
getArrayin interfacejava.sql.ResultSet- Parameters:
i- the first column is 1, the second is 2, ...- Returns:
- an object representing an SQL array
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getRef
public final java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLExceptionJDBC 2.0 Get a REF(<structured-type>) column.- Specified by:
getRefin interfacejava.sql.ResultSet- Parameters:
colName- the column name- Returns:
- an object representing data of an SQL REF type
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getArray
public final java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLExceptionJDBC 2.0 Get an array column.- Specified by:
getArrayin interfacejava.sql.ResultSet- Parameters:
colName- the column name- Returns:
- an object representing an SQL array
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
isBeforeFirst
public boolean isBeforeFirst() throws java.sql.SQLExceptionJDBC 2.0Determine if the cursor is before the first row in the result set.
- Specified by:
isBeforeFirstin interfacejava.sql.ResultSet- Returns:
- true if before the first row, false otherwise. Returns false when the result set contains no rows.
- Throws:
java.sql.SQLException- Thrown on error.
-
isAfterLast
public boolean isAfterLast() throws java.sql.SQLExceptionJDBC 2.0Determine if the cursor is after the last row in the result set.
- Specified by:
isAfterLastin interfacejava.sql.ResultSet- Returns:
- true if after the last row, false otherwise. Returns false when the result set contains no rows.
- Throws:
java.sql.SQLException- Thrown on error.
-
isFirst
public boolean isFirst() throws java.sql.SQLExceptionJDBC 2.0Determine if the cursor is on the first row of the result set.
- Specified by:
isFirstin interfacejava.sql.ResultSet- Returns:
- true if on the first row, false otherwise.
- Throws:
java.sql.SQLException- Thrown on error.
-
isLast
public boolean isLast() throws java.sql.SQLExceptionJDBC 2.0Determine if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
- Specified by:
isLastin interfacejava.sql.ResultSet- Returns:
- true if on the last row, false otherwise.
- Throws:
java.sql.SQLException- Thrown on error.
-
beforeFirst
public void beforeFirst() throws java.sql.SQLExceptionJDBC 2.0Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
- Specified by:
beforeFirstin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY
-
afterLast
public void afterLast() throws java.sql.SQLExceptionJDBC 2.0Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
- Specified by:
afterLastin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY.
-
first
public boolean first() throws java.sql.SQLExceptionJDBC 2.0Moves to the first row in the result set.
- Specified by:
firstin interfacejava.sql.ResultSet- Returns:
- true if on a valid row, false if no rows in the result set.
- Throws:
java.sql.SQLException- if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY.
-
last
public boolean last() throws java.sql.SQLExceptionJDBC 2.0Moves to the last row in the result set.
- Specified by:
lastin interfacejava.sql.ResultSet- Returns:
- true if on a valid row, false if no rows in the result set.
- Throws:
java.sql.SQLException- if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY.
-
getRow
public int getRow() throws java.sql.SQLExceptionJDBC 2.0Determine the current row number. The first row is number 1, the second number 2, etc.
- Specified by:
getRowin interfacejava.sql.ResultSet- Returns:
- the current row number, else return 0 if there is no current row
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
absolute
public boolean absolute(int row) throws java.sql.SQLExceptionJDBC 2.0Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
- Specified by:
absolutein interfacejava.sql.ResultSet- Returns:
- true if on the result set, false if off.
- Throws:
java.sql.SQLException- if a database-access error occurs, or row is 0, or result set type is TYPE_FORWARD_ONLY.
-
relative
public boolean relative(int row) throws java.sql.SQLExceptionJDBC 2.0Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
- Specified by:
relativein interfacejava.sql.ResultSet- Returns:
- true if on a row, false otherwise.
- Throws:
java.sql.SQLException- if a database-access error occurs, or there is no current row, or result set type is TYPE_FORWARD_ONLY.
-
previous
public boolean previous() throws java.sql.SQLExceptionJDBC 2.0Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
- Specified by:
previousin interfacejava.sql.ResultSet- Returns:
- true if on a valid row, false if off the result set.
- Throws:
java.sql.SQLException- if a database-access error occurs, or result set type is TYPE_FORWAR_DONLY.
-
setFetchDirection
public void setFetchDirection(int direction) throws java.sql.SQLExceptionJDBC 2.0 Give a hint as to the direction in which the rows in this result set will be processed. The initial value is determined by the statement that produced the result set. The fetch direction may be changed at any time.- Specified by:
setFetchDirectionin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or the result set type is TYPE_FORWARD_ONLY and direction is not FETCH_FORWARD.
-
getFetchDirection
public int getFetchDirection() throws java.sql.SQLExceptionJDBC 2.0 Return the fetch direction for this result set.- Specified by:
getFetchDirectionin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs
-
setFetchSize
public void setFetchSize(int rows) throws java.sql.SQLExceptionJDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. If the fetch size specified is zero, then the JDBC driver ignores the value, and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that creates the result set. The fetch size may be changed at any time.- Specified by:
setFetchSizein interfacejava.sql.ResultSet- Parameters:
rows- the number of rows to fetch- Throws:
java.sql.SQLException- if a database-access error occurs, or the condition 0 <= rows is not satisfied.
-
getFetchSize
public int getFetchSize() throws java.sql.SQLExceptionJDBC 2.0 Return the fetch size for this result set.- Specified by:
getFetchSizein interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs
-
getType
public int getType() throws java.sql.SQLExceptionJDBC 2.0 Return the type of this result set. The type is determined based on the statement that created the result set.- Specified by:
getTypein interfacejava.sql.ResultSet- Returns:
- TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, or TYPE_SCROLL_SENSITIVE
- Throws:
java.sql.SQLException- if a database-access error occurs
-
getConcurrency
public int getConcurrency() throws java.sql.SQLExceptionJDBC 2.0 Return the concurrency of this result set. The concurrency is determined as follows If Statement object has CONCUR_READ_ONLY concurrency, then ResultSet object will also have the CONCUR_READ_ONLY concurrency. But if Statement object has CONCUR_UPDATABLE concurrency, then the concurrency of ResultSet object depends on whether the underlying language resultset is updatable or not. If the language resultset is updatable, then JDBC ResultSet object will also have the CONCUR_UPDATABLE concurrency. If lanugage resultset is not updatable, then JDBC ResultSet object concurrency will be set to CONCUR_READ_ONLY.- Specified by:
getConcurrencyin interfacejava.sql.ResultSet- Returns:
- the concurrency type, CONCUR_READ_ONLY, etc.
- Throws:
java.sql.SQLException- if a database-access error occurs
-
rowUpdated
public boolean rowUpdated() throws java.sql.SQLExceptionJDBC 2.0 Determine if the current row has been updated. The value returned depends on whether or not the result set can detect updates.- Specified by:
rowUpdatedin interfacejava.sql.ResultSet- Returns:
- true if the row has been visibly updated by the owner or another, and updates are detected
- Throws:
java.sql.SQLException- if a database-access error occurs- See Also:
EmbedDatabaseMetaData.updatesAreDetected(int)
-
rowInserted
public boolean rowInserted() throws java.sql.SQLExceptionJDBC 2.0 Determine if the current row has been inserted. The value returned depends on whether or not the result set can detect visible inserts.- Specified by:
rowInsertedin interfacejava.sql.ResultSet- Returns:
- true if inserted and inserts are detected
- Throws:
java.sql.SQLException- if a database-access error occurs- See Also:
EmbedDatabaseMetaData.insertsAreDetected(int)
-
rowDeleted
public boolean rowDeleted() throws java.sql.SQLExceptionJDBC 2.0 Determine if this row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not the result set can detect deletions.- Specified by:
rowDeletedin interfacejava.sql.ResultSet- Returns:
- true if deleted and deletes are detected
- Throws:
java.sql.SQLException- if a database-access error occurs- See Also:
EmbedDatabaseMetaData.deletesAreDetected(int)
-
updateNull
public void updateNull(int columnIndex) throws java.sql.SQLExceptionJDBC 2.0 Give a nullable column a null value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateNullin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a boolean value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBooleanin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateByte
public void updateByte(int columnIndex, byte x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a byte value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBytein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateShort
public void updateShort(int columnIndex, short x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a short value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateShortin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateInt
public void updateInt(int columnIndex, int x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an integer value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateIntin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateLong
public void updateLong(int columnIndex, long x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a long value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateLongin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateFloat
public void updateFloat(int columnIndex, float x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a float value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateFloatin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateDouble
public void updateDouble(int columnIndex, double x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Double value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateDoublein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
updateBigDecimalin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateBigDecimal
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBigDecimalin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateString
public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a String value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateStringin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a byte array value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBytesin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateDate
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Date value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateDatein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateTime
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Time value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateTimein interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateTimestamp
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateTimestampin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLExceptionUpdate a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 theupdateRowor insertRow methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...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_ONLYor this method is called on a closed result set
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLExceptionUpdate a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 theupdateRoworinsertRowmethods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- 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_ONLYor this method is called on a closed result set
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLExceptionJDBC 4.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLExceptionUpdates 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 theupdateRowor insertRow methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...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_ONLYor this method is called on a closed result set
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateObjectin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuescale- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateObjectin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateNull
public void updateNull(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a null value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateNullin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the column- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBoolean
public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a boolean value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBooleanin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateByte
public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a byte value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBytein interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateShort
public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a short value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateShortin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateInt
public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an integer value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateIntin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateLong
public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a long value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateLongin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateFloat
public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a float value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateFloatin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateDouble
public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a double value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateDoublein interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateString
public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a String value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateStringin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBytes
public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a byte array value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBytesin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateDate
public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Date value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateDatein interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateTime
public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Time value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateTimein interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateTimestamp
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateTimestampin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column valuelength- of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column valuelength- of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnreader- the new column valuelength- length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateObjectin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column valuescale- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored.- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateObjectin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column value- Throws:
java.sql.SQLException- if a database-access error occurs
-
insertRow
public void insertRow() throws java.sql.SQLExceptionJDBC 2.0 Insert the contents of the insert row into the result set and the database. Must be on the insert row when this method is called.- Specified by:
insertRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, if called when not on the insert row, or if all non-nullable columns in the insert row have not been given a value
-
updateRow
public void updateRow() throws java.sql.SQLExceptionJDBC 2.0 Update the underlying database with the new contents of the current row. Cannot be called when on the insert row.- Specified by:
updateRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or if called when on the insert row
-
deleteRow
public void deleteRow() throws java.sql.SQLExceptionJDBC 2.0 Delete the current row from the result set and the underlying database. Cannot be called when on the insert row.- Specified by:
deleteRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or if called when on the insert row.
-
refreshRow
public void refreshRow() throws java.sql.SQLExceptionJDBC 2.0 Refresh the value of the current row with its current value in the database. Cannot be called when on the insert row. The refreshRow() method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow() when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one. All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow() is called after calling updateXXX(), but before calling updateRow() then the updates made to the row are lost. Calling refreshRow() frequently will likely slow performance.- Specified by:
refreshRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or if called when on the insert row.
-
cancelRowUpdates
public void cancelRowUpdates() throws java.sql.SQLExceptionJDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row. If no updates have been made or updateRow() has already been called, then this method has no effect.- Specified by:
cancelRowUpdatesin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or if called when on the insert row.
-
moveToInsertRow
public void moveToInsertRow() throws java.sql.SQLExceptionJDBC 2.0 Move to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updateXXX() methods prior to inserting the row into the result set. Only the updateXXX(), getXXX(), and insertRow() methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow(). UpdateXXX()must be called before getXXX() on a column.- Specified by:
moveToInsertRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or the result set is not updatable
-
moveToCurrentRow
public void moveToCurrentRow() throws java.sql.SQLExceptionJDBC 2.0 Move the cursor to the remembered cursor position, usually the current row. Has no effect unless the cursor is on the insert row.- Specified by:
moveToCurrentRowin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException- if a database-access error occurs, or the result set is not updatable
-
getBlob
public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLExceptionJDBC 2.0 Get a BLOB column.- Specified by:
getBlobin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- an object representing a BLOB
- Throws:
java.sql.SQLException
-
getClob
public final java.sql.Clob getClob(int columnIndex) throws java.sql.SQLExceptionJDBC 2.0 Get a CLOB column.- Specified by:
getClobin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...- Returns:
- an object representing a CLOB
- Throws:
java.sql.SQLException
-
getBlob
public final java.sql.Blob getBlob(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 2.0 Get a BLOB column.- Specified by:
getBlobin interfacejava.sql.ResultSet- Parameters:
columnName- the column name- Returns:
- an object representing a BLOB
- Throws:
java.sql.SQLException
-
getClob
public final java.sql.Clob getClob(java.lang.String columnName) throws java.sql.SQLExceptionJDBC 2.0 Get a CLOB column.- Specified by:
getClobin interfacejava.sql.ResultSet- Parameters:
columnName- the column name- Returns:
- an object representing a CLOB
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateBlob
public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Blob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateBlob
public void updateBlob(java.lang.String columnName, java.sql.Blob x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Blob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnName- - the SQL name of the columnx- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateClob
public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Clob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateClob
public void updateClob(java.lang.String columnName, java.sql.Clob x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Clob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnName- - the SQL name of the columnx- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
compareTo
public final int compareTo(java.lang.Object other)
- Specified by:
compareToin interfacejava.lang.Comparable
-
isForUpdate
public final boolean isForUpdate()
* Is this result set from a select for update statement?- Specified by:
isForUpdatein interfaceEngineResultSet
-
isClosed
public final boolean isClosed() throws java.sql.SQLExceptionJDBC 4.0Checks whether this
ResultSetobject has been closed, either automatically or becauseclose()has been called.- Specified by:
isClosedin interfacejava.sql.ResultSet- Returns:
trueif theResultSetis closed,falseotherwise- Throws:
java.sql.SQLException- if a database error occurs
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLExceptionJDBC 2.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- the new column valuelength- the length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLExceptionJDBC 4.0 Update a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column valuelength- of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 theupdateRowor insertRow methods are called to update the database.- Specified by:
updateAsciiStreamin interfacejava.sql.ResultSet- Parameters:
columnName- 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 columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLYor this method is called on a closed result set
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLExceptionJDBC 4.0 Update a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnx- the new column valuelength- of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 theupdateRoworinsertRowmethods are called to update the database.- Specified by:
updateBinaryStreamin interfacejava.sql.ResultSet- Parameters:
columnName- 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_ONLYor this method is called on a closed result set
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, long length) throws java.sql.SQLExceptionJDBC 4.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnName- the name of the columnreader- the new column valuelength- length of the stream- Throws:
java.sql.SQLException- if a database-access error occurs
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader) throws java.sql.SQLExceptionUpdates 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 theupdateRowor insertRow methods are called to update the database.- Specified by:
updateCharacterStreamin interfacejava.sql.ResultSet- Parameters:
columnName- 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 value- Throws:
java.sql.SQLException- if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLYor this method is called on a closed result set
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLExceptionJDBC 4.0 Updates the designated column with a java.sql.Blob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column valuelength- - the length of the Blob datatype- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- 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_ONLYor this method is called on a closed result set
-
updateBlob
public void updateBlob(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLExceptionJDBC 4.0 Updates the designated column with a java.sql.Blob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnName- - the name of the column to be updatedx- - the new column valuelength- - the length of the Blob datatype- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLExceptionUpdates 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 or insertRow methods are called to update the database.- Specified by:
updateBlobin interfacejava.sql.ResultSet- Parameters:
columnName- 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- 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_ONLYor this method is called on a closed result set
-
updateClob
public void updateClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLExceptionJDBC 4.0 Updates the designated column with a java.sql.Clob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateClob
public void updateClob(int columnIndex, java.io.Reader x) throws java.sql.SQLExceptionUpdates the designated column using the givenReaderobject. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion fromUNICODEto 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 theupdateRoworinsertRowmethods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnIndex- the first column is 1, the second is 2, ...x- 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_ONLYor this method is called on a closed result set
-
updateClob
public void updateClob(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLExceptionJDBC 4.0 Updates the designated column with a java.sql.Clob 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnName- - the name of the Clob columnx- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateClob
public void updateClob(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLExceptionUpdates the designated column using the givenReaderobject. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion fromUNICODEto 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 theupdateRoworinsertRowmethods are called to update the database.- Specified by:
updateClobin interfacejava.sql.ResultSet- Parameters:
columnName- 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- 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_ONLYor this method is called on a closed result set
-
updateRef
public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Ref 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateRefin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateRef
public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Ref 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateRefin interfacejava.sql.ResultSet- Parameters:
columnName- - the SQL name of the columnx- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateArray
public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Array 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateArrayin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateArray
public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLExceptionJDBC 3.0 Updates the designated column with a java.sql.Array 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 the updateRow or insertRow methods are called to update the database.- Specified by:
updateArrayin interfacejava.sql.ResultSet- Parameters:
columnName- - the SQL name of the columnx- - the new column value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getRowId
public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String columnName) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException- Specified by:
updateNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException- Specified by:
updateNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLException- Specified by:
updateNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLException- Specified by:
updateNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException- Specified by:
updateNStringin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(java.lang.String columnName, java.lang.String nString) throws java.sql.SQLException- Specified by:
updateNStringin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException- Specified by:
updateNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnName, java.sql.NClob nClob) throws java.sql.SQLException- Specified by:
updateNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
updateNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException- Specified by:
getNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String columnName) throws java.sql.SQLException- Specified by:
getNCharacterStreamin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int i) throws java.sql.SQLException- Specified by:
getNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String colName) throws java.sql.SQLException- Specified by:
getNClobin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException- Specified by:
getNStringin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String columnName) throws java.sql.SQLException- Specified by:
getNStringin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException- Specified by:
updateRowIdin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(java.lang.String columnName, java.sql.RowId x) throws java.sql.SQLException- Specified by:
updateRowIdin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String colName) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
updateSQLXMLin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(java.lang.String columnName, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
updateSQLXMLin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class<?> interfaces) throws java.sql.SQLExceptionReturns false unlessinterfacesis implemented- Specified by:
isWrapperForin interfacejava.sql.Wrapper- Parameters:
interfaces- 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> interfaces) throws java.sql.SQLExceptionReturnsthisif this class implements the interface- Specified by:
unwrapin interfacejava.sql.Wrapper- Parameters:
interfaces- a Class defining an interface- Returns:
- an object that implements the interface
- Throws:
java.sql.SQLException- if no object if found that implements the interface
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLExceptionUpdates the designated column using the given Reader object, which is the given number of characters long.- Specified by:
updateNClobin interfacejava.sql.ResultSet- Parameters:
columnIndex- - the first column is 1, the second is 2x- - the new column valuelength- - the length of the stream- Throws:
java.sql.SQLException- Feature not implemented for now.
-
updateNClob
public void updateNClob(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLExceptionUpdates the designated column using the given Reader object, which is the given number of characters long.- Specified by:
updateNClobin interfacejava.sql.ResultSet- Parameters:
columnName- - the Name of the column to be updatedx- - the new column valuelength- - the length of the stream- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getObject
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws java.sql.SQLExceptionRetrieve the column as an object of the desired type.- Specified by:
getObjectin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String columnName, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
getObjectin interfacejava.sql.ResultSet- Throws:
java.sql.SQLException
-
isNull
public boolean isNull(int columnIndex) throws java.sql.SQLExceptionDescription copied from interface:EngineResultSetIs the designated columnIndex a null data value? This is used by EXTDTAInputStream to get the null value without retrieving the underlying data value.- Specified by:
isNullin interfaceEngineResultSet- Returns:
- true if the data value at columnIndex for the current row is null
- Throws:
java.sql.SQLException
-
getLength
public int getLength(int columnIndex) throws java.sql.SQLExceptionDescription copied from interface:EngineResultSetReturn the length of the designated columnIndex data value. Implementation is type dependent.- Specified by:
getLengthin interfaceEngineResultSet- Parameters:
columnIndex- column to access- Returns:
- length of data value
- Throws:
java.sql.SQLException- See Also:
DataValueDescriptor.getLength()
-
-
DataMelt 3.0 © DataMelt by jWork.ORG