ifs.fnd.sf.storage

Class FndResultSet

java.lang.Object

ifs.fnd.sf.storage.FndResultSet

All Implemented Interfaces:

java.lang.AutoCloseable

public final class FndResultSet
extends java.lang.Object
implements java.lang.AutoCloseable

Framework internal class: Wrapper class for java.sql.Resultset.

This is a framework internal class! Backward compatibility is not guaranteed.

See Also:

ResultSet, OracleResultSet

Field Summary

Fields

Modifier and Type	Field and Description
static int	CONCUR_READ_ONLY
static int	CONCUR_UPDATABLE
static int	TYPE_FORWARD_ONLY

Constructor Summary

Constructors

Constructor and Description
FndResultSet(java.sql.ResultSet resultSet, TimingsLogger.Counter counter) Creates new instance of the class.

Method Summary

Modifier and Type	Method and Description
void	close() Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
void	finishCounter()
java.math.BigDecimal	getBigDecimal(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
java.sql.Blob	getBlob(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
java.sql.Blob	getBLOB(int columnIndex) Oracle extension.
boolean	getBoolean(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
byte[]	getBytes(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
java.sql.Clob	getClob(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
java.sql.Clob	getCLOB(int columnIndex) Oracle extension.
java.sql.Date	getDate(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
double	getDouble(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
int	getInt(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
long	getLong(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
java.sql.ResultSetMetaData	getMetaData() Retrieves the number, types and properties of this ResultSet object's columns.
java.lang.String	getString(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
java.sql.Time	getTime(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
java.sql.Timestamp	getTimestamp(int columnIndex, java.util.Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.SQLWarning	getWarnings() Retrieves the first warning reported by calls on this ResultSet object.
boolean	next() Moves the cursor forward one row from its current position.
void	updateRow() Updates the underlying database with the new contents of the current row of this ResultSet object.
boolean	wasNull() Reports whether the last column read had a value of SQL NULL.

Methods inherited from class java.lang.Object

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

Field Detail

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY

See Also:

Constant Field Values

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY

See Also:

Constant Field Values

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE

See Also:

Constant Field Values

Constructor Detail

FndResultSet

public FndResultSet(java.sql.ResultSet resultSet,
                    TimingsLogger.Counter counter)

Creates new instance of the class.

Parameters:

resultSet - The java.sql.ResultSet that is about to be wrapped

counter - Conter instance for time statistics or null.

See Also:

TimingsLogger

Method Detail

finishCounter

public void finishCounter()

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is false

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Parameters:

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

Returns:

Throws:

java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

Parameters:

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

Returns:

the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

Parameters:

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

cal - the java.util.Calendar object to use in constructing the timestamp

Returns:

the column value as a java.sql.Timestamp object; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.

Parameters:

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

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language. This method adds time statistics to instance of TimingsLogger.Counter.

Parameters:

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

Returns:

a Clob object representing the SQL CLOB value in the specified column

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language. This method adds time statistics to instance of TimingsLogger.Counter.

Parameters:

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

Returns:

a Blob object representing the SQL BLOB value in the specified column

Throws:

java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Retrieves the number, types and properties of this ResultSet object's columns.

Returns:

the description of this ResultSet object's columns

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed result set

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Retrieves the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object will be chained to the SQLWarning object that this method returns.

Returns:

the first SQLWarning object reported or null if there are none

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed result set

next

public boolean next()
             throws java.sql.SQLException

Moves the cursor forward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on. This method adds time statistics to instance of TimingsLogger.Counter.

Returns:

true if the new current row is valid; false if there are no more rows

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed result set

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Reports whether the last column read had a value of SQL NULL.

Returns:

true if the last column value read was SQL NULL and false otherwise

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed result set

updateRow

public void updateRow()
               throws java.sql.SQLException

Updates the underlying database with the new contents of the current row of this ResultSet object. This method adds time statistics to instance of TimingsLogger.Counter.

Throws:

java.sql.SQLException - if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY; this method is called on a closed result set or if this method is called when the cursor is on the insert row

close

public void close()
           throws java.sql.SQLException

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Specified by:

close in interface java.lang.AutoCloseable

Throws:

java.sql.SQLException - if a database access error occurs

getBLOB

public java.sql.Blob getBLOB(int columnIndex)
                      throws java.sql.SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data. This method adds time statistics to instance of TimingsLogger.Counter.

Parameters:

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

Returns:

the column value as an oracle.sql.BLOB

Throws:

java.sql.SQLException - the column value as an oracle.sql.BLOB

getCLOB

public java.sql.Clob getCLOB(int columnIndex)
                      throws java.sql.SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data. This method adds time statistics to instance of TimingsLogger.Counter.

Parameters:

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

Returns:

the column value as an oracle.sql.CLOB

Throws:

java.sql.SQLException - if a database access error occurs.