Interface ISqlCursor

All Superinterfaces:

ICursor, IDisposable, IEntity

public interface ISqlCursor
extends ICursor

Represents a database cursor.

Method Summary

Modifier and Type	Method	Description
void	addCursorClosedListener(CursorClosedListener listener)	Registers the CursorClosedListener.
ResultSet	fetch(int position, int numberOfRows)	Fetches rows in the cursor and returns the rows fetched from the database.
ISqlRunner	getSqlRunner()	The SQL Runner that created the cursor.
void	removeCursorClosedListener(CursorClosedListener listener)	Unregisters the CursorClosedListener.
void	reopen(String statement)	Reopens a cursor executing the select statement.

Methods inherited from interface ICursor

close, closeOnIdleTimeout, closeOnSessionCleared, getId, getState

Methods inherited from interface IDisposable

addDisposedListener, removeDisposedListener

Methods inherited from interface IEntity

getUserContext, setUserContext

Method Details

addCursorClosedListener

void addCursorClosedListener(CursorClosedListener listener)

Registers the CursorClosedListener.

Parameters:

listener - Event listener to add.

removeCursorClosedListener

void removeCursorClosedListener(CursorClosedListener listener)

Unregisters the CursorClosedListener.

Parameters:

listener - Event listener to remove.

fetch

ResultSet fetch(int position,
 int numberOfRows)
         throws Exception,
altitude.integrationServer.exceptions.ISException,
altitude.integrationServer.exceptions.ISSqlException

Fetches rows in the cursor and returns the rows fetched from the database.

Parameters:

position - Index of the first row to fetch. The index is zero-based.

numberOfRows - Number of rows to fetch.

Returns:

The rows fetched from the database.

Throws:

Exception

altitude.integrationServer.exceptions.ISException

altitude.integrationServer.exceptions.ISSqlException

getSqlRunner

ISqlRunner getSqlRunner()
                 throws Exception,
altitude.integrationServer.exceptions.ISException

The SQL Runner that created the cursor.

Throws:

Exception

altitude.integrationServer.exceptions.ISException

reopen

void reopen(String statement)
     throws Exception,
altitude.integrationServer.exceptions.ISException,
altitude.integrationServer.exceptions.ISSqlException

Reopens a cursor executing the select statement.

Parameters:

statement - SQL statement to execute on the instance.

Throws:

Exception

altitude.integrationServer.exceptions.ISException

altitude.integrationServer.exceptions.ISSqlException