org.firebirdsql.jdbc

Class FBResultSet

java.lang.Object

org.firebirdsql.jdbc.AbstractResultSet

org.firebirdsql.jdbc.FBResultSet

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, FBObjectListener.FetcherListener, FirebirdResultSet, Synchronizable

public class FBResultSet
extends AbstractResultSet

JDBC 4.2 implementation of ResultSet interface.

Author:

David Jencks, Roman Rokytskyy, Mark Rotteveel

Field Summary

Fields inherited from class org.firebirdsql.jdbc.AbstractResultSet

connection, gdsHelper, row, xsqlvars

Fields inherited from interface java.sql.ResultSet

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

Constructor Summary

Constructors

Constructor and Description
FBResultSet(AbstractConnection connection, AbstractStatement fbStatement, org.firebirdsql.gds.impl.AbstractIscStmtHandle stmt, FBObjectListener.ResultSetListener listener, boolean metaDataQuery, int rsType, int rsConcurrency, int rsHoldability, boolean cached)
FBResultSet(XSQLVAR[] xsqlvars, java.util.ArrayList rows)
FBResultSet(XSQLVAR[] xsqlvars, org.firebirdsql.gds.impl.GDSHelper gdsHelper, java.util.ArrayList rows, boolean retrieveBlobs)

Method Summary

Modifier and Type	Method and Description
java.sql.NClob	getNClob(int columnIndex)
java.sql.NClob	getNClob(java.lang.String columnLabel)
java.sql.RowId	getRowId(int columnIndex)
java.sql.RowId	getRowId(java.lang.String columnLabel)
java.sql.SQLXML	getSQLXML(int columnIndex)
java.sql.SQLXML	getSQLXML(java.lang.String columnLabel)
void	updateNClob(int columnIndex, java.sql.NClob clob)
void	updateNClob(int columnIndex, java.io.Reader reader)
void	updateNClob(int columnIndex, java.io.Reader reader, long length)
void	updateNClob(java.lang.String columnLabel, java.sql.NClob clob)
void	updateNClob(java.lang.String columnLabel, java.io.Reader reader)
void	updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void	updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType)
void	updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
void	updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType)
void	updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
void	updateRowId(int columnIndex, java.sql.RowId x)
void	updateRowId(java.lang.String columnLabel, java.sql.RowId x)
void	updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
void	updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)

Methods inherited from class org.firebirdsql.jdbc.AbstractResultSet

absolute, addWarning, afterLast, allRowsFetched, beforeFirst, cancelRowUpdates, checkCursorMove, checkOpen, clearWarnings, close, closeFields, deleteRow, fetcherClosed, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getExecutionPlan, getFetchDirection, getFetchSize, getField, getField, getField, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getSynchronizationObject, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, getXsqlvar, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowChanged, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from class java.lang.Object

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

Constructor Detail

FBResultSet

public FBResultSet(AbstractConnection connection,
                   AbstractStatement fbStatement,
                   org.firebirdsql.gds.impl.AbstractIscStmtHandle stmt,
                   FBObjectListener.ResultSetListener listener,
                   boolean metaDataQuery,
                   int rsType,
                   int rsConcurrency,
                   int rsHoldability,
                   boolean cached)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

FBResultSet

public FBResultSet(XSQLVAR[] xsqlvars,
                   java.util.ArrayList rows)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

FBResultSet

public FBResultSet(XSQLVAR[] xsqlvars,
                   org.firebirdsql.gds.impl.GDSHelper gdsHelper,
                   java.util.ArrayList rows,
                   boolean retrieveBlobs)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

getNClob

public java.sql.NClob getNClob(int columnIndex)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getNClob

public java.sql.NClob getNClob(java.lang.String columnLabel)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRowId

public java.sql.RowId getRowId(int columnIndex)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRowId

public java.sql.RowId getRowId(java.lang.String columnLabel)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(int columnIndex)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.sql.NClob clob)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.sql.NClob clob)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateRowId

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

Throws:

java.sql.SQLException

updateRowId

public void updateRowId(java.lang.String columnLabel,
                        java.sql.RowId x)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateSQLXML

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

Throws:

java.sql.SQLException

updateSQLXML

public void updateSQLXML(java.lang.String columnLabel,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType,
                         int scaleOrLength)
                  throws java.sql.SQLException

Jaybird delegates to AbstractResultSet.updateObject(int, Object, int) and ignores the value of targetSqlType

Throws:

java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType,
                         int scaleOrLength)
                  throws java.sql.SQLException

Jaybird delegates to AbstractResultSet.updateObject(String, Object, int) and ignores the value of targetSqlType

Throws:

java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType)
                  throws java.sql.SQLException

Jaybird delegates to AbstractResultSet.updateObject(int, Object) and ignores the value of targetSqlType

Throws:

java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         java.sql.SQLType targetSqlType)
                  throws java.sql.SQLException

Jaybird delegates to AbstractResultSet.updateObject(String, Object) and ignores the value of targetSqlType

Throws:

java.sql.SQLException